Kelvin Phayre (12/9/2008)

---

I put 1.5m rows into a table and then ran your query. I then stopped the query before it crashed the server.

I then took a different tac. I...

1. Remove the WHERE from your CTE.

2. Add the line

INNER JOIN TestStep T ON P.ProcessID= T.ProcessID

to your final select

Give this article a read.

http://www.sqlservercentral.com/articles/T-SQL/63681/

The X is the derived table alias, doesn't have anything to do with the GROUP BY.

I think this will be more along the lines of what you're looking for to get all your products. Please note, that this may be very slow, but I...

Ok, I thought that might be what you were attempting, but 25% chunks seemed a bit large, so I wanted to verify ;). David's examples come out of the...

What are you trying to do with the TOP 25 Percent's?

I'm not quite getting what you want returned here, can you provide your expected results based on that...

Kelvin Phayre (12/9/2008)

---

I have a table with thousands of sales history records. Some of the records have skewed data i.e products being sold for £250k or £0.00 (company fudges etc)....

I knew you were going to say that.

If the situation is really as simple as your example, you can always use an IF instead. (It's probably not, but I'll try the easy way out first).

IF @Field1...

CREATE PROCEDURE Test

@Field1varchar(5) = 'foo'

AS

INSERT INTO MyTable (Field1)

VALUES (@Field1)

Bob Hovious (12/7/2008)

---

The mighty Garadin is correct. My last couple of examples were step-by-step, each dependent on the last. You can of course nest the...

Note that this only...

Jeff Moden (12/6/2008)

---

I remember how I used to code SQL when I first started... one huge query for each batch project... it was actually worse than any cursor anyone...

If you created a stored procedure, and your header looks like this:

CREATE PROCEDURE Blah

@firmname varchar(50)

AS

and not like

CREATE PROCEDURE Blah

@firmname varchar(50)...

Goldmine... ack. Some nasty memories of that one.

Can you just add an identity column to the table and import that as well for uniqueness?