apa manggilnya bukan begini aja? AFAIKyang namanya procedure nggak ada
return valuenya.
DECLARE @date_after_clarify_close datetime
EXEC dbo.sp_date_after_clarify_close @date_clarify_close, @int_issue_id,
@date_after_clarify_close
On Tue, Jul 1, 2008 at 11:10 AM, Dannie Tj. <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Aku ada masalah lain nih, mau minta tolong kasih masukan soalnya udah mumet
> nih kepala :((
>
>
> Ceritanya aku manggil SP sp_date_after_clarify_close untuk return datetime
> value.
>
> Problemnya, tiap kali SP itu aku run/compile, selalu dapat error
>
> Msg 257, Level 16, State 3, Procedure sp_date_after_clarify_close, Line 57
> Implicit conversion from data type datetime to int is not allowed. Use the
> CONVERT function to run this query.
>
>
>
> Problem nya itu aku perhatikan dibagian RETURN(...), kalau aku remark '--'
> hasil compile nya sukses.
>
> Kenapa ya? padahal @date_time = date_after_clarify_close = datetime type.
>
> Thx sebelumnya.
>
>
>
>
>
>
> ----------------------------------------------------------------
> Main Program
>
>
> DECLARE @date_after_clarify_close datetime
>
> EXEC @date_after_clarify_close=dbo.sp_date_after_clarify_close
> @date_clarify_close,
> @int_issue_id,
> ''
>
>
> -----------------------------------------------------------------
>
> STORED PROCEDURE
>
>
> set ANSI_NULLS ON
> set QUOTED_IDENTIFIER ON
> go
>
> ALTER PROCEDURE [dbo].[sp_date_after_clarify_close]
> @date_clarify_close datetime,
> @int_issue_id int,
> @date_after_clarify_close datetime OUTPUT
> AS
> BEGIN
> SET NOCOUNT ON;
>
> DECLARE @date_temp datetime
>
> DECLARE cr_date_after_clarify_close CURSOR
> FOR
> SELECT date_response
> FROM responses
> WHERE issue_id = @int_issue_id
> ORDER BY date_response
>
> OPEN cr_date_after_clarify_close
>
> FETCH NEXT FROM cr_date_after_clarify_close into @date_temp
>
> WHILE @@FETCH_STATUS = 0
> BEGIN
>
> IF @date_temp = @date_clarify_close
> BEGIN
> FETCH NEXT FROM cr_date_after_clarify_close into @date_temp
>
> SET @date_after_clarify_close = @date_temp
> END
> ELSE
> FETCH NEXT FROM cr_date_after_clarify_close into @date_temp
>
> END
>
> CLOSE cr_date_after_clarify_close
>
> DEALLOCATE cr_date_after_clarify_close
>
> RETURN (@date_after_clarify_close) ---> Suspect issue disini, karena
> kalo aku remark '--', run/compile nya jalan mulus.
>
> END
>
> --------------------------------------------------------------------
>
>
> Msg 257, Level 16, State 3, Procedure sp_date_after_clarify_close, Line 57
> Implicit conversion from data type datetime to int is not allowed. Use the
> CONVERT function to run this query.
>
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------------------
>
> --
> www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
> Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
>
> Yahoo! Groups Links
>
>
>
>
--
// syarifl.com
[Non-text portions of this message have been removed]
------------------------------------
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
