March 13, 2012 at 9:27 am
Silly Me!!!
DECLARE @FileName varchar(50), is the culprit..
I increased the size @FileName varchar(250), and it's resolved!
March 13, 2012 at 9:29 am
Annee (3/13/2012)
Silly Me!!!DECLARE @FileName varchar(50), is the culprit..
I increased the size @FileName varchar(250), and it's resolved!
hehe 😀
_________________________________
seth delconte
http://sqlkeys.com
March 13, 2012 at 12:15 pm
Your change to use DATEDIFF function will make your qury miss the index on adddatetime.
March 13, 2012 at 12:27 pm
You may want to change your where caluse to this:
...
where adddatetime >= dateadd(dd, datediff(dd, 0, getdate()), 0) and adddatetime < dateadd(dd, datediff(dd, 0, getdate()) + 1 , 0)
March 14, 2012 at 11:12 am
thanks for that input!
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply