Here's another way using ROW_NUMBER():

;WITH Projects AS (

SELECT CLIENTID, PROJECTID

,rn=ROW_NUMBER() OVER (PARTITION BY CLIENTID, PROJECTID ORDER BY (SELECT...

Not 100% sure Alan, but I think I get it. Two ways (if I'm right).

DECLARE @Sums TABLE

(ID INT IDENTITY, Reviewed FLOAT, [Non Reviewed] FLOAT)

INSERT INTO...

Jason Tontz (10/9/2012)

---

But you CAN check for the exitence of a file on your user's workstation.

With the appropriate permissions on both the server and workstations such as domain admins, you...

I always find it best to learn from examples, so here for you is an example of how you'd set this up to execute as dynamic SQL:

DECLARE @sql ...

Just for fun, here's a nasty piece of work:

create table #t1(name varchar (100))

INsert into #t1

select '1234ABC123456XYZ1234567890ADS'

INsert into #t1

select 'cbv736456XYZ543534534545XLS'

;WITH ChunkIt (RowID, n, str1, str2, str3) AS (

...

vinay.varaala (10/8/2012)

---

alright

I will explain it clearly from that first table unleaded product I want to sum up based on codetype like c,h and l.

output should be in 3...

Gabe,

This sounds exactly like the problem posted here (just recently): http://www.sqlservercentral.com/Forums/Topic1369495-391-1.aspx

You'll find that the SSC team of volunteers got into a bit of a performance contest over the best way...

lm_hamilton (10/8/2012)

---

Thanks for the script, that will go a long way to speed up finding issues to evaluate for fixing.

Also, thanks for the concern to make sure I am not...

Your DDL is nearly perfect except that I prefer seeing a temp table or table variable so that I don't create actual tables in my sandbox. Setup data is...

ChrisM@Work (10/8/2012)

---

Jeff Moden (10/8/2012)

---

I did say that I needed to make a change to get it to work...

Jeff Moden (10/8/2012)

---

I did say that I needed to make a change to get it to work and...

Chris - I'm gonna keep moanin' until I win one of these performance races against you.

So I'll submit this (stealing your Tally table):

;WITH Tally (n) AS (

...

ChrisM@Work (10/8/2012)

---

That's unlikely. If a column has a not null constraint, it won't allow nulls.

A shotgun approach like this puts shivers down my spine. You have a legacy app which...

I like Euros better, just don't have that character...

ChrisM@Work (10/8/2012)

---

dwain.c (10/8/2012)

---

<<snip>>

Nagaram's is the fastest so far - it's a good 20% faster than mine. I'm having a look to find out why - probably the tally-table generation. Yours...