Hi Lynn,

wonderful. Thanks a lot for tuning. nice Discussion. thanks eirik too.

Awesome. Another great tweak. Thanks.

yes the hierarchy is fixed. I believe your words. I will start working with the real time data and will post back.

Once again thank you so much for your...

Hi Eirik,

I am sorry for the error data and Thank you for the reply and query. I understand how to split. Have a question about i have 100*1000 records...

this is how i achieved.

;

WITH TotalRecords

AS (

SELECT ROW_NUMBER() OVER (

PARTITION BY productnumber

,productname ORDER BY productid DESC

) AS RowNumber

,productnumber

,productname

,Quantity

FROM Test

)

SELECT *

FROM TotalRecords

WHERE rownumber = 1

Awesome Eirik. Perfect sample. Thanks a lot for you and Chris for the wonderful time on this post. Good learning for me.

Cheers!!!!

Hi Eirik,

Am waiting for you Gentle Man. Any hope ?

Hi Eirik,

It's unclear. Could you please show me the change in my previous query? where do i need to put the condition.

Thakns

Hi Erik/Sean,

Any suggestions how to use Rn to get range of data on the sample please

Hi Sean,

Appreciate your time on this. Here is my try to get the range of data

DECLARE @Statement VARCHAR(MAX)

SET @Statement = '

SELECT *

FROM

(

SELECT

Val,

Cat,

Rn = ROW_NUMBER() OVER (PARTITION BY Cat...

Final Quick Question.

Is it possible to select the rows based on the condition? as i said, i am planning to bringing 10000 records each.

where s.Rn > 10000 and s.Rn <...

WOW!! Thanks Chris. Wonderful Query . Works as expected. Definitely you guyz think about why such requirement. I need to get these format data to my spreadsheet. each of...

Hi Chris,

Thanks for your reply.

could you please help me on making the below query to fetch top 5000 records. currently it only take 6 records.

SELECT *

FROM

(

select Val,Cat,ROW_NUMBER() over (partition by...

thank you and am aware of this limitation. Is it possible to give me the dynamic query? i am planing to retrieve first 10000 rows for testing.

Yes You are Correct. Could you please help me on making this as Dynamic to achieve my output.

Thanks