I guess I didn't know you were a "bubble head", Grant. I was the lead ping jockey on SSN 604... did a little time on the Parche (637 stretch...

Adrian's code does create and execute "one big update" statement as you've asked... have you tried it on a test table?

For a single result set that you can join to...

--===== Declare your parameters

DECLARE @pYear INT, @pMonth INT

--===== Set the parameters (simulates a proc or udf parameters)

SELECT @pYear = 2008,

...

To get all of the dates in the range all at once, then the following will do it for you...

--===== Here are the two parameters you wanted

DECLARE @DateStart DATETIME

DECLARE @DateEnd...

Well... lemme shift gears here, a bit. You say you want a "text representation" of the matrix of 100,000 columns and 10,000 rows... that's 1,000,000,000 or a Billion "cells"...

Understood... I was agreeing with you...:)

Lemme ask again... what's in the TEXT column?

Ian's method using ROW_NUMBER() OVER will work just fine, then.

Zactly...

Heh... thanks Grant... I'm just a wee bit embarrased that I didn't pick up on that before I posted the question. 😛 More COFFEE!:hehe:

So use Robert's function as part of a derived table, join it, and pivot it.

It really would help if the OP would post exactly what output is expected from the...

Never mind...

Master.sys.dm_Exec_SQL_Text is a system table-valued function... I thought it was a system view.

:blush:

Why bother? If you want to update a table with an IDENTITY column, then just do it.

If you're trying to create a query that returns a numbered list, then...

Some have tried to come up with a formula... I've not been very successful at it because it really isn't database size dependent. It's impacted more by what the...

You bet... let us know how you make out on this problem.