Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reacha
Starting Member
49 Posts |
 Posted - 2010-10-07 : 14:19:28
|
| When i run the below procedure i am getting the following error messageMsg 257, Level 16, State 3, Procedure get_AuditCompleted, Line 7Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.create procedure get_AuditCompleted(@pkgid int,@AuditCompleted datetime output)asset @AuditCompleted = (select Auditstamp from audit where AUDIT.AUDITMSG = 'completed by user' and AUDIT.PKGID =@pkgid)return @AuditCompleted Please help me out!!Thanks,reacha |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
reacha
Starting Member
49 Posts |
Posted - 2010-10-07 : 14:33:37
|
| Mrs. Tara Lyn Kizer Thank you!! it worked |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Procedure help with date