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 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy