Schnurdle (2/18/2008)

---

I'm not defending the cursor, but wouldn't the proposed solution cause potential Tempdb locking problems?

I always create the temp table first, then INSERT into it to avoid such issues.

e.g.

--Create...

Sure thing, CA... thanks for asking...

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

... and thanks for the kudo on formatting. I do it mostly so I can read it 😀

What are you using to measure the times with? Typically, I'll use SET STATISTICS TIME ON... the CPU time is the actual time it took sans any display. ...

Heh... if you don't care so much about a trigger providing a friendly error, you can always just have the table lock itself up when you create it...

CREATE TABLE YourTable...

Thanks for the feedback, Julie... hmm... maybe I should publish it here, as well.

What an awesome article... I've seen quite a few on the same topic, but this one "nutshells" the whole 9 yards very nicely. It's definitely a keeper.

Thanks for...

Actually, the help system in SQL Server is pretty good. Comes free with SQL Server. It's called "Books Online".

Yes... it does have a disadvantage similar to many other programs that import data... the date must be formatted consistently from row to row including the header, if there is...

ebuss_2004 (2/17/2008)

---

Thanks. I am new at this cursor and trying to modify someone else code so that it run faster. I wonder why would someone use Cursor if we can...

I had to make a bigger table to get some timing stats.... also means I had to convert both scripts to use a Tally table and make a large enough...

I kinda thought that, as well. Thanks, Matt. It'll be interesting to see what you come up with...

...

Thanks for the feedback and glad it suits your needs... now you know why I kept asking for more detail...

Folks, this is a perfect example of why I wrote the...

I don't know the differences between a Blackberry and a SmartPhone because I haven't had to carry either.

I with Johan, though... if you're gonna put a ball and chain on...

Never mind... I just had another cup of coffee...

Here's the untested answer...

--===== If the temp table exists, drop it

IF OBJECT_ID('TempDB..#tt_Mum','U') IS NOT NULL

...