Isn't this the best solution for the stated problem?

select Total, Type1Count, Type1Count*100.0/Total as Perc1, Type2Count, Type2Count*100.0/Total as Perc2

FROM (

select count(*) as Total,

sum(case...

I highly recommend you download the latest copy of SQL Server 2005 Books Online, install it, and get very familiar with it. It is a wonderful resource!!!

Here is the...

This is a perfect scenario where a cursor...

Well done.

I have been doing this type of analysis for a decade now, but have never done the execution histogram like you have done with the case statements....

msdb.dbo.restorehistory table as well.

Mani-584606 (11/29/2009)

---

ok.. these are the values I got from perfmon for

0.022792896

0.018652975

So do I need to divide these numbers with any value?

If I get a value 2.0 or >2.0,...

sherifffruitfly (11/27/2009)

---

I'm no sql genius or anything, but is anyone concerned that the poster apparently has 2+ versions of the truth running around in his or her database?

Besides the technical...

Barkingdog (11/27/2009)

---

Our developer's claim they need to run a "ransaction" that updates two databases on two servers. So I think that linked servers are were not enough. We need...

1) I believe the OP inquired is DTC required for distributed transactions. remember that dist trans can be done completely from client-side code.

2) even with linked servers I believe...

Looking at your stats now I can see that you definitely aren't new around here Seth! :w00t:

Just asking is all, since there are quite a few of them and you are (to me) a new entity here. 🙂 I do seem to recall most of...

Seth, did your update meet all of the requirements of the quirky update?

1) you have no where clause - do you REALLY need to return all 10+M rows?

2) can you please provide expected output? I can't for the life of me...

the classic scenario is a while loop:

declare @i tinyint

set @i = 1

while @i < 10

begin

do something here

set @i...

are you really inserting your output into the temp table shown? If so, try these things:

a) insert a few rows using explicit VALUES just to see...