Scott,

Post the first 10 records of data (including the header) and let me take a crack at it tonight for ya...  I think there may be a couple of ways...

Prakash,

Serqiy is, although a bit brusk, still absolutely correct.  Why do you need a cursor at all?  And building one dynamically is like the worst of two worlds.  Why can't...

Thanks, DC and Ieea,

I always thought cursors were a part of SQL Server... didn't know they were actually added as a "feature" at...

Just following up... here's a cool problem that I just ran across that I was able to answer because I'd done something like it before...

Here's the problem...

You have a payment...

Absolutely concur!  I was just demonstrating one method of getting the CPU time expended by a single spid.  I usually get the I/O the same way as well as measuring...

Reet,

You'll undoubtably get several suggestions using a self-joined correlated sub-query which are usually pretty darned slow.  They'll usually take about 29 seconds to do 10,000 records and the duration get's exponentially...

To summarize your request for a view to simply reject those things where "somecolumn" has things in it besides numeric digits...

CREATE VIEW dbo.someviewname

    AS

SELECT somecolumns...

Ummmm.... press the {f8} function key...

Thought I'd throw one of my own into the circle...

If you don't have a "Tally" or "Numbers" table, now is as good a time as any to make one.  A...

Jacques,

I'm not sure how your example helps because the cpu time you produce is for the entire server, not an individual spid... as you said about simple elapsed time, if...

I have to admit... I've never seen an ideally designed database  (usually, too many cooks in the design with too little knowledge, you know...

I'm thinking that's likely true because, as someone else pointed out, the TEMPDB database is set to the "SIMPLE" recovery mode.  However, most other operations on temp tables are logged......

If I understand the problem correctly... this might be a good job for a trigger.

... of course, there are no possibilities when you don't respond to the people trying to help.

Does anyone have a Microsoft reference or test code to support that one?  I'm kinda in the "Myth Buster" mode at work about Temp Tables and Table Variables... anything you...