You're welcome.

If you have any edition of SQL Server, you have a pretty much unlimited license to install SSMS on workstations. Whatever installation media you installed SQL Server with has...

GilaMonster (5/15/2009)

---

Ahhh!!!! Damn it! Twice this year!

Flat broken into again last night. Among other things, took the zune that I bought to replace the ipod that they stole last bloody...

I'm here (most of the time).

You're ahead of me. When I'd been working with database for 4 hours, I didn't even know that it was called "DBA". Or is that "hours" supposed to...

mmunson (5/14/2009)

---

Can I get your opinion? Is my script pretty beginner stuff? I was just wondering because I have no frame of reference, I'm the only one in...

Will this do what you need, or am I getting this backwards?

;with

CTEMain as

(SELECT CRM_StatusCodes.TRANSACTION_ID as [Service Order ID]

, CRM_Partners.PARTNER

, CRM_Partners.PARTNER_FCT

, CRM_Partners.DESCRIPTION [Function]

, CRM_StatusCodes.SYSTEM_STATUS as [Confirmation Status]

, CRM_Partners.ADDRESS

, CRM_PartsLabor.DESCRIPTION

, CRM_orders.created_at...

You don't have to convert them. SQL 2008 still supports compat 80. Doesn't support 75. It goes back two major versions.

You might, on the other hand, want...

Only thing I can think of is restore to the last good point. That's probably your last backup.

That won't work. You're selecting a distinct value in an inline sub-query, that means that one row is distinct when compared to nothing at all. That won't prevent...

Use row_number(). You can order it by whatever you want, in a sub-query, then filter the way you want in the outer query.

Like this:

;with CTE as

(select GroupNumber, SubGroup,

row_number()...

I created a test table:

set nocount on;

go

create table dbo.MyTable (

SSN char(9),

ID uniqueidentifier not null default(newsequentialid()) primary key);

go

insert into dbo.MyTable (SSN)

select top 5000000 null

from dbo.Numbers N1

cross join dbo.Numbers N2;

Then, using the...

RBarryYoung (5/14/2009)

---

GSquared (5/14/2009)

---

If you base it on time, if you do the query too fast, you'll end up with duplicate values.

...

This will generate 5-million unique fake SSNs.

set nocount on;

create table...

If you base it on time, if you do the query too fast, you'll end up with duplicate values.

On updating it into the primary table, does that have an ID...

I guess I'm not clear on what you're using the row number for. I see you limiting it to the first row, but I'm not sure what you're trying...