You two are freaky scary sometimes.. 😀

Either that or bloat your tables with computed columns to represent the columns you want in your queries.

I suppose you COULD write a server level trigger to append the SPID to the table extended properties. Not sure how useful that would be.

Hey Jeff?

I read your article and I know it's been a loooooooooooooooong time but you know you could replace this:

--===== If the...

Something like this might get you started?

DECLARE @d1 DATETIME,

@d2 DATETIME

SELECT @d1 = '04/01/2013',

...

You'll notice that Lowell prefaced it with Order By... this case structure goes in the Order By portion of your statement.

Could run a SQL task in SSIS to do it. Just write a script to do it and have SSIS run that script or scripts.

I'm not sure I even understand the question.

I concede that this task can be done with a set-based command that generates a list of commands.. lol.. now let's consider a moment.

Now consider your task may take...

That's a nice bit of code there, Sean.

While I've used dynamic sql to either a) build the list of commands I want to run, or b) run dynamic commands, I...

That's seems like an interesting task. What do you hope to gain from it?

🙂

Give me a set based statement that goes...

If you're looking specifically on how to use an identity column in a select into temporary table situation the following code should give you a leg up.

select IDENTITY (int,1,1)...

I imagine if you take each number and use it as a basis for outer apply you'd get a cartesian product with every number comination but it's going to get...

You mean something like this?

select empno

from

(

select 12 empno

union

select 34 empno

union

select 3 empno

union

select 78 empno

union

select...