Viewing 15 posts - 51,286 through 51,300 (of 59,072 total)
Expensive move to compare all columns if you only care if a couple have been updated...
April 2, 2008 at 11:14 am
That's a big one for me... the use of "Trusted Accounts" means that I don't have to hard-code user names or passwords in any code. Very big security advantage...
April 2, 2008 at 8:25 am
Tim Riley (4/2/2008)
"Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 72
An INSERT EXEC statement cannot be nested."
There are 'INSERT' statements in various...
April 2, 2008 at 8:23 am
On the subject of VM's... heh... Steve said he's got friends doing it... reminds me of what everyone's Mother in the World has probably said at one time or another......
April 2, 2008 at 8:15 am
No... just leave it like the other million or so posts. It's a resource that others can search on. Your post and it's answers might help someone else...
April 2, 2008 at 8:12 am
Heh... you certainly did.
I'm mostly a data troll, so I don't really know... but my gut tells me that SQL Server probably shouldn't be calling a Web Service... maybe the...
April 2, 2008 at 8:09 am
Thanks, Jason... I'm still a newbie when it comes to 2k5.
Hey, Matt... why is on the fly bad for this?
April 2, 2008 at 8:04 am
Rags (4/1/2008)
Jeff - Like I just said to J, I'm always up for learning new ways of doing...
April 2, 2008 at 8:01 am
Temp Tables are created in the SQL Server TEMPDB database and therefore require more IO resources and locking. Table Variables and Derived Tables are created in memory.
Nice try on...
April 1, 2008 at 11:06 pm
Would you please read what I said more carefully? The code I wrote does your split the way you want it... the load stuff was just a suggestion to...
April 1, 2008 at 10:43 pm
Thank you, Matt! You beat me to it!
April 1, 2008 at 10:41 pm
... and then do a searh'n'replace to kill the brackets, if you'd like.
April 1, 2008 at 10:37 pm
Where you want to start is the last code I posted... it will do the job.
The whole thing is that I wonder how the data got into the parameters column...
April 1, 2008 at 10:33 pm
GSquared (4/1/2008)
select dateadd(month, 1, cast(enddate + '01' as datetime)) - 1
from dbo.sasimp
Should give you what you need. If it gives you an error about converting enddate to varchar, try...
April 1, 2008 at 10:23 pm
Viewing 15 posts - 51,286 through 51,300 (of 59,072 total)