Can someone help out here? I started to answer yet another question about catching output from a procedure which builds dynamic SQL. Jeffrey Williams and I...

Thanks Mohit.

I've got the Delaney books for 2005. Just finished reading "Internals" but never ran across this.

I appreciate the help 🙂

Arrrg... it's a % and not a / ..... must drink more caffeine and get more sleep...

That's kind of where my DBA and I are at. But we were hoping someone knew of some reliable authority to that effect. Thanks 🙂

(looking at watch.... then calendar....)

sigh....

Important distinction to remember in SQL:

In SQL, IF is a control statement, used for branching logic. It controls whether certain code executes or not. ...

I'm sorry, but I'm having trouble seeing exactly what you mean. Would you please give me an example of a table that would be generated dynamically, with column...

That's helpful, thank you. Now what is dynamic about your output? Different selection criteria? Different columns every time? Can you give me...

I can think of a poster child. I'll bet Lynn can too.

Are we...

Once you have the name of the new table passed back you can interrogate system data to find out the names and data types of the columns in it,...

My topic would more likely be... Laughable SQL

Other contenders:

Sensual SQL (potential best seller title here, Jeff take note)

Cooking with SQL

Why isn't there an SQL equivalent to Iron Chef? ...

With respect to testing, and I apologize for not having done more, it seems there are at least three or four variables about the test data to consider:

1. ...

Definitely easier on the eyes ...

Thanks, everyone.

Guys, I hadn't even considered submitting an abstract, and the time seems kind of short. I've never even been an attendee before. I do...