This seems like a very dangerous thing to do from a data governance standpoint.  Won't you leave abandoned keys in related tables this way?

Seems like a needless complication to the data.  Just assign everybody a generic numeric bigint identity(1,1) and be done with it.  No need for individuality in a database, and you'll...

Wow, a four year old rerun.  I now understand an interview I had two years ago better.  I left that interview feeling like I was a bad fit for a...

Running out of budget is running out of work. It means you'll be kicked out like yesterday's trash.

It might happen quickly. It might happen slowly...

You've never run out of work?

I reguarly automate, and on average, I run out of work every 18 months in my career. It's the only way I've ever found...

Then I suggest, Jeff, you present your solution for an unknown ahead of time number of columns, which may be different between records. The simplest way I could find...

Unfortunately no, but what I have discovered is it can be done without cursors. Pseudo code is use a select to build your create Table statement, then an Insert...

Here's my vote for a tool I just learned to use this year: SQL Packager from Redgate. Cuts out all the need for hand coding, can also include...

Just the opposite- If you FAILED to patch your server, you got this quesiton right- and failed to patch it EVER since this was fixed in SP1.

Still, interesting behavior for...

Only if you've failed in the server patch department- this was fixed SQL Server 2005 SP1

Bug must be fixed in 2008:

What you see...

-----------------------

print 1

-- Comment one

print 2

-- Comment two

print 3

-- Comment three

print 4

is not what you get!

-----------------------

1

2

3

4