You might care to read this:

http://msdn2.microsoft.com/en-us/library/ms187024.aspx

Given that document - I would assume that you upgraded a SQL 2000 to 2005. When you do that it retains the max worker...

I'd look at setting up a CLR function using Regular Expressions. You haven't given me enough to understand why ' fox ' and not any one of the other words;...

GSquared (4/17/2008)

---

Unless they read this forum, in which case, you just gave away "the code", and it could be reverse engineered.

Either go for truly random (Matt's solution), or completely meaningless...

All right. I just noticed your original code.

Try this....

declare @max1 int

select @max1 = max(acid)+1 from cms_2a

alter table cms_3a add cwid int identity(1, 1)

dbcc checkident(CMS_3a, RESEED,@max1)

Well...you CAN, meaning it's a query that is "legal" and will get past the parser...I'm just not sure you should.

Inequality joins (otherwise known by some on this board as "triangular...

I personally prefer to never use anything that can be used to derive the "real" information in a demo scenario. For example - if all of your local phone...

One more thing - depending on what you're returning using each index, you might care to include extra stuff in the INCLUDE sections of your indexes.... Might save you some...

My memory may be faulty - but I didn't think you could just upgrade Windows 2003 from 32 to 64-bit. I was under the assumption you had to "wipe...

dajonx (4/17/2008)

---

Thank you for the replies!

Lynn Pettis - The reason I'm using an alter statement is because I wanted to add the "cwid" column with an identity seed...

GSquared (4/17/2008)

---

In that case DO NOT REPLACE THEM!!!!!

If you replace them with random numbers, they'll be gone.

Instead, use encryption. That way, you can...

thanks - it works pretty well as long as you dont' have to say it ten times fast....that's...

Jeff Moden (4/16/2008)

---

"Must look eye"...

See anything wrong with the following?

from dbo.dwTreatment tvp join dbo.TreatmentVisit tv

on...

Try something like this...

select RIGHT('1234567890'+cast(cast(9999999999*rand(checksum(newid())) as bigint) as varchar(10)),10)

Vicki Peters (4/17/2008)

---

Yes, but that isn't working in my pivot table, when the column I'm trying to format is a grouping (one of the row labels). I can format the...

If nothing else - add a sort task after the UNION ALL..... I don't recall a sort option one way or the other within the UNION ALL task....