Viewing 15 posts - 50,926 through 50,940 (of 59,078 total)
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...
April 29, 2008 at 7:12 am
Adrian's code does create and execute "one big update" statement as you've asked... have you tried it on a test table?
April 29, 2008 at 7:07 am
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,
...
April 29, 2008 at 2:24 am
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...
April 29, 2008 at 2:15 am
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"...
April 29, 2008 at 1:35 am
Lemme ask again... what's in the TEXT column?
April 28, 2008 at 5:09 pm
virgo (4/28/2008)
:w00t: ok Jeff....just in some cases i need to do that way....am using sql server 2005....thanks much for ur reply
Ian's method using ROW_NUMBER() OVER will work just fine, then.
April 28, 2008 at 5:06 pm
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:
April 28, 2008 at 7:02 am
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...
April 28, 2008 at 6:33 am
Never mind...
Master.sys.dm_Exec_SQL_Text is a system table-valued function... I thought it was a system view.
:blush:
April 28, 2008 at 6:14 am
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...
April 27, 2008 at 9:01 am
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...
April 26, 2008 at 11:30 pm
You bet... let us know how you make out on this problem.
April 26, 2008 at 10:57 pm
Viewing 15 posts - 50,926 through 50,940 (of 59,078 total)