**ducking** I had chicken for lunch....

Todd - when you use the "complex expression" version of CASE, don't list the column name ouside of the WHEN.

As in -

case ...

Kevin Rathgeber (6/13/2008)

---

Ok, so for the fun of it I tried to add a Primary Key Clustered in my in memory table. The difference is substantial

New times for the...

Other than the variable about whether it's faster to select out what you want to keep, or delete out the stuff you don't want, I'd say most of the workable...

Hmm - I see you added some details. Try this on for size - see if this gets you started. No loops or cursors.

drop table #MySubMasterList

drop table #tmpperson

drop...

very nice idea Michael. Order by does guarantee that the identities will be assigned in that order, so that's a very nice catch.

The best way to do that might be to set it up to be able to run from Master, but using the current DB's context.

Take a look at the following:

http://weblogs.sqlteam.com/mladenp/archive/2007/01/18/58287.aspx

Are the other columns involved in the insert enough to be used as a natural key? I understand that would be a multi-column join, and probably not the most...

So there will an auto-number available in the master list when you want to tackle this?

The thing is I am not doing this sequentially, I want to select every 7th...

This might not apply in a lot of cases, but would it make sense to have a "throwaway" column that would allow you to get the "old" ID involved? ...

Thankfully - you don't have to. Peter Larsson published an article on his solution for dynamically doing this kind of stuff...Pretty slick if you ask me...

http://www.sqlservercentral.com/articles/Advanced+Querying/pivottableformicrosoftsqlserver/2434/%5B/url%5D

Jeff Moden (6/13/2008)

---

Best thing to do is to write set based code from the "Git"... then you don't have to worry about stuff like this. And, even if you're...

If you use database queries/web queries from the import external data, yes - refreshing data is very simple. By default - it would refresh each time you open the...

Cross-post. Try to avoid that - it dilutes the answers. Most of the regulars read all forums, so it's not going to help (it might actually annoy some...

A former manager used to say - "there really are only two kinds of names for jobs that don't allow you to really take time off: one is jail,...