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 |
|
rammi25
Starting Member
4 Posts |
 Posted - 2011-11-27 : 09:42:25
|
| hai.iam getting [sqlstate01000] in the output log file of sql job because of print statement.how to remove it.plss reply me |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-27 : 18:39:04
|
| Don't know if that's what's causing it butSET @mydate = CONVERT(VARCHAR(25), DATEADD(dd, -( DAY(GETDATE()) - 1 ),GETDATE()), 101)should probably beSET @mydate = DATEADD(dd, datediff(dd,0,getdate())-1, GETDATE())I think - not sure what it's trying to do but the convert doesn't seem to do anything useful and I can't guess what the middle bit is for if it's not this.Could be a lot simpler though==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-28 : 05:33:28
|
| Take out the print statement?Can't see this going anywhere.Note - my previous post was in response to the original question which has now gone.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
urgent pls.....i am getting SQLSTATE 01000.