SELECT Empid, Name, EmergContact,

ROW_NUMBER() OVER (PARTITION BY Empid order BY Name) [Number]

FROM table

Thanks for being kind to my brain today.

Seems like the biggest responses are generated from QOTD answers that are wrong.

A plot to increase activity on the site perhaps?? :hehe:

The US auto industry is still based in Michigan, last I checked. I would think this would have a high priority for a fix.

In my experience, perception is weighted...

Thanks for that question. I have to go stick my brain in a bucket of ice now.

This sounds to me like what PaulB is describing. If there is a unique constraint on the table without an index, each insert has to read the table sequentially...

The wizard loads up to 5 tables simultaneously, so as Steve describes, you will need to set it up manually, or modify the saved package created by the wizard to...

Note that you can do this:

SELECT 1 WHERE NULL is NULL

nise qwestion. two baad their iz two miny tipoz.

My favorite one, but maybe that's because I'm the one that gets the 3:00am calls.

Very nice.

Yep. @@rowcount is a cruel mistress. I avoid her like a rash. 😀

If auto grow is not turned on, then you need to add space to the existing data file.

The easy way is turn auto grow on.

Nice question.

SQL Server uses a role based security model. Your databases get created already without granting access to users on the server. You should set up database roles with...

This happens when an application is designed to be portable across a variety of database platforms. The theory is that all logic is kept at the application layer so...