Expensive move to compare all columns if you only care if a couple have been updated...

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...

Tim Riley (4/2/2008)

---

When I do that I receive the error::crying:

"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...

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......

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...

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...

Thanks, Jason... I'm still a newbie when it comes to 2k5.

Hey, Matt... why is on the fly bad for this?

Rags (4/1/2008)

---

J-thanks! i'm always up for learning new ways to do things.

Jeff - Like I just said to J, I'm always up for learning new ways of doing...

Nice try on...

Thanks...

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...

Thank you, Matt! You beat me to it!

... and then do a searh'n'replace to kill the brackets, if you'd like.

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...

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...