I think you'd

select @a = myval, @b-2 = myval2, etc.

from myCTE

How current do the reports need to be? Database mirroring and snapshots (if you have enterprise) can help here. Or replication to a second server.

This kind of sounds like a test question, so I'll ask you to show some work.

As a hint, a subquery and a max() aggregate can help.

No idea. the column is undocumented and so I'm not sure anyone has decoded all the values.

That's a little strange. I'd think that a user would have problems with xp_cmdshell before DTSRun.

Does the proxy have access to msdb?

there isn't really a good way to do this. You could move to dynamic SQL, but that's not really recommended. You could cause yourself other issues.

I can understand that you...

The newsletter easily fits on about half my 1152x864 screen (image attached).

I'm guessing that you have pictures blocked. Outlook leaves large placeholders in their place which affects scrolling.

Also, please post...

I think the author is OK, and hope we'll see more.

Again, apologies.

Hey, I resemble that remark!

I didn't see that in today's newsletter. I have Outlook 2007, and my resolution is 1152x864. A message window about 2/3 the screen shows the newsletter formatted fine.

Can you send...

I'd think the biggest issue with datetime is the "doh!" that you say everytime a report looks for sales on a date, forgetting there's a time component.

How many of you...

And I'll add that I don't do projects myself to save money. It's good to do so, but about half the time I spent the same amount because I do...

I knew you were a bunch of tinkerers and it's interesting to see how many people enjoy working with wood.

For a few items:

A bush hog is a brand of rotary...

Ben,

I haven't done enough cluster work and don't have a good environment in which to test a proper cluster with AD dependencies, etc. So I didn't expand on it for...

We do that here, but basically use a 2 step process.

We have a set of tables where we can store email info and then recipient info and link them....