Eric M Russell (5/19/2011)

---

My guess is that either the transaction has already completed or you've rebooted the server by now. However, I found an article on Microsoft's CSS site about...

Had to failover the server to the passive node to get it done, but it's a done deal at this point.

You should see the "Total CPU Time" on that query...

Those look sequential to me. They'll sort correctly as strings if they...

Burhan Insel-262978 (5/19/2011)

---

We, employees,...

Ninja's_RGR'us (5/19/2011)

---

GSquared (5/19/2011)

---

Ninja's_RGR'us (5/19/2011)

---

GSquared (5/19/2011)

---

I've gone from $7.50/hour in 2001 to, well HR says I can't say the number but it's more than 4X that. None of it has...

Ninja's_RGR'us (5/19/2011)

---

GSquared (5/19/2011)

---

I've gone from $7.50/hour in 2001 to, well HR says I can't say the number but it's more than 4X that. None of it has been through...

I've gone from $7.50/hour in 2001 to, well HR says I can't say the number but it's more than 4X that. None of it has been through percentage raises...

Is there a way to tell from that what the next record in the sequence is?

Then your best bet will be to dynamically create a query that checks all string datatypes in all tables.

Something like:

select 'select ' + case system_type_id when 39 then 'convert(varchar(max), '

when...

BI has the best market in the US right now. Good pay, lots of job opportunities for skilled people. I don't know about other markets, but in the...

The only ways I know of are: http://www.winserverhelp.com/2010/04/getting-started-with-powershell-for-sql-server/

I need to know what you want if there are three "C-125"s, for example, before I could write any code. What do you want on the third one, if...

LutzM (5/18/2011)

---

Gus: If this concept is...

Something to keep in mind:

The sample I gave only works if the ID column doesn't have any missing values. If it does, you need to start the Merge with...

That one's easy, assuming I got it right on what you're trying to do.

Start with this:

select *

from MyTable as MT1

inner join MyTable as MT2

on MT1.ID = MT2.ID -1;

You'll see the...