I happened to be doing a little research on different methods for finding "gaps" and ran across this article. Here's a much faster way to find gaps... and, it...

Now, I'm worried for you... the practice of "finding gaps" in a "sequence" column is usually accompanied by the insane idea that you'd ever reuse missing numbers. The INT...

Gail is 100% correct... if all you want to do is add a "sequence" number to the table, then just add an IDENTITY column as she described.

I always create them as "dbo" and grant privs... saves a lot of hassle...

I think keeping them in separate databases is usually a good idea... allows for customization by customer, if need be. If you write a script to accept a little...

Please tell me they don't actually teach how to use Triangular Joins to derive running totals 😛

Just so everyone knows... that little slice of computational heaven will not parse the entire list if a number just happens to straddle the 4000 character mark. Instead, it...

Also, if a fellow by the name of "Madhivanan" responds to this thread, he's got some very good advice on OpenRowSet...

OpenRowSet is one fine way... please the following URL...

http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx

That'll get you started... there are a couple of "finesse" tricks that we can talk about later on, but you need the...

Mike C (1/1/2008)

---

Oops you're right, I did miss that code block. I think the speedup is not really due to UDF overhead though, but rather because of FOR XML...

colin Leversuch-Roberts (1/1/2008)

---

I like the fact you show it's a code issue not a sql issue. I'm constantly asked to index queries to improve them when the reality is that...

I appologize for the semantics... but, in SQL Server 2000, unless you take on the TEXT datatype as an input parameter, the largest character based variable you can define is...

Heh... you think that's going to work on SQL Server 2000? This is a 2k forum, ya know 😛

Heh... if it's a very well written query, it will always run the CPU to 100%... just for a very, very short time... and that's the goal... get everything done...

Actually... good... typing on a blog lickety-split is one of the things that I'd like to get away from during an NCAA game. Leave your bloody laptops at home....