Viewing 15 posts - 2,806 through 2,820 (of 7,429 total)
Personally I would consider doing like so.
Replace all occurrances of @DateHolder with
DATEADD(ss,-1,DATEADD(d,DATEDIFF(d,0,GETDATE()+1),0))
in your query code and get rid of the variable declaration.
Replace @tdate with
GETDATE()
and get rid of variable declaration.
Not...
June 17, 2003 at 4:40 am
I noticed it the other day too. Looks fairly straight forward and not overly complicated. I think it has more of a reach in the MSDE crowd but definently has...
June 17, 2003 at 4:06 am
No it will not create any conflicts. They however need to be carefull not to create the objects under their username but instead should make sure is dbo so that...
June 16, 2003 at 10:26 am
Oops, sorry got out of the SQL frame of mind there.
June 16, 2003 at 8:44 am
quote:
quote:
The good thing here is it is the other guy it messed up. If...
June 16, 2003 at 7:09 am
Oh yes I do agree I just wanted to make sure your message didn't lead anyone down a bad assumption of what you meant.
As for Frank
June 16, 2003 at 5:21 am
I read this a few weeks ago. But here take alook at the comparison at the bottom. http://www.microsoft.com/windowsserver2003/evaluation/overview/family.mspx And note the question did state Datacenter.
June 16, 2003 at 4:39 am
Windows Load Balancing with an Active/Active setup can increase efficiency from the user perspective simple because you have both nodes under use (although I have seen WLB favoring one node...
June 16, 2003 at 4:32 am
I agree, you create issues with a single account with regards to security considering people do come and go.
June 16, 2003 at 4:27 am
Never use reserved words or keywords in your table names (there is a list in BOL but it is so common to see Name and ID used).
Do comeup with a...
June 16, 2003 at 4:26 am
Actually depending on how you move your data the process will generally throw errors if the data is corrupted or cannot be moved. You may just need to look for...
June 16, 2003 at 3:54 am
quote:
Thanks MW.I'm using stored procedures and the logic looks simple enough. Maybe 24 hours is as good as it gets.
June 16, 2003 at 3:50 am
It depends. Cursors are notroious for being used where not actually needed, but generally this is because the better solution is not seen. Look at you code and consider what...
June 16, 2003 at 3:42 am
quote:
quote:
For me, it is not important what language a program is written in... A...
June 16, 2003 at 3:37 am
Viewing 15 posts - 2,806 through 2,820 (of 7,429 total)