Edit: Removed redundant parts of my post, leaving nothing left. 🙂

(In other words, yeah, I chose the is_identity answer, because that's the one I'd be most likely to use.)

Have you tried using my approximate solution? Should give you results in under a second.

I think creating barrier to entry is the wrong way to go. Sure, it makes it easy to write bad software (see my signature), but nothing we do...

Definitely doesn't do that to me. Are you sure you're clicking Properties?

There isn't a guaranteed sequence. SQL Server will decide how to resolve the query, and which sequence to apply Where statements in, based on how much work it thinks...

I believe DTS can do most of this work for you, if you want it to. You might want to look into using that.

There was an article on this page a little while back about generating running totals. The technique outlined in it should be able to do what you need.

Take a look at OpenRowset in Books Online. It can connect to non-linked servers. Will that do what you need?

Have you tried casting the columns as Int in your join?

It looks to me like you have different values in CurrentLevelXID column, and you are grouping by that column.

Instead of grouping by all the columns, you should use a derived...

You might get a concurrent select improvement if you had duplicate indexes on different drives/arrays and each select used a different one. Haven't tried that, don't really have a...

Matt Miller (4/25/2008)

---

Jeff Moden (4/25/2008)

---

GSquared (4/25/2008)

---

That's going to work better than spaces around the "like" statement. Of course, if you want it to include "pros" (plural), or "professional"/"professionals", you...

Well, that'll certainly change a few things! (Like maybe I'll start paying attention.... nah ... that'll never happen.)

For that, you'll...

Since it's binary, it won't have the contents in there in a selectable format. (At least, I'm pretty sure it doesn't.)

SQL 2008 is supposed to be able to deal...

See my reply to your "regex" post for how to do this in 2005. There is a way to do it in 2000, using the system tables, but I...