So far as I know, Management Studio does not have a debug tool.

Could you rephrase your question?

Wait. I'm confused. Are you selecting from an Excel spreadsheet or from a SQL Server table (dynamically generated)?

I know you're inserting INTO an Excel spreadsheet. I just don't understand the...

LiveJournal.

CirquedeSQLeil (9/27/2010)

A mouth full...

It's...

Because he can't afford all the others. @=) It's not just the dentist he has to pay, you know. Daughters expect kickbacks whilst they slumber.

I could look this up, I'm sure, but since we're on the topic of blogs, I'm going to be lazy (besides I can't look it up right now because if...

That's how I learned SQL. I tried to help out...

AhHA! A coworker figured it out. The System log had a whole bunch of "Side by Side" errors, referring to access denied on several different .dlls and other files. Turns...

I appreciate the advice. I do want to know what happened, though, so we can prevent it from occurring again.

The last time we "lost" a resource on the cluster--the Agent...

Okay, here's redone code taking into account the event date & time columns being on the same row. However, you're making an assumption that Event 1's menu will always be...

Chris, your code doesn't do what he wants Menu1 and Menu2 to do.

Also, you forgot to remove the # sign from your table name. Since he's a newbie and didn't...

Kit,

Try using DatePart, DateAdd, and CharIndex in your code. It'll make your select statement a lot less messy.

select Venue as VName,

address1 as VAddr1,

city + ', ' + state...

Glad I could help.

Definitely thanks for posting the solution. I'd never thought of that one.