Thanks Alan. B for the response.

Here are the answers to your questions with additional notes/observations from today.

Anyhow,Is SSRS and SQL Server running on the same box or sharing any resources?

Yes...

Thank you both. Yes, my bad to think of the secondary axis as the z-axis. Adding secondary vertical axis worked just fine. Had seen this option while playing but did...

17 views but no replies :(.

Actually I did that, however I am stuck at how to only select the one that are duplicates and not the ones that are not duplicates. The row_number() function will...

I also need the record that has DupNR > 1 as part of the results.

What I don't want is the rows that only have DupNR = 1, i.e. that are...

Hi Rozema,

I am not trying to delete but I am rather trying to display the ones that are selected as duplicates.

This requirement makes it trickier.

Thanks

R.P.Rozema (2/15/2012)

---

Similar to Paul's suggestion:

SELECT

...

Thanks a lot Paul for the tip.

I was guessing it would be a rank functions but since I never used before, could not get it to work.

Is there way in...

I am using the following query to partition the items based on matching attributes, however, not sure if there is any function which will label them into groups based on...

Hi,

I wanted to edit the title of this post but I believe that is not possible.

I wanted review the title of this post to state " Grouping unique items based...

I tried to to get this done via IIS again and it still does not seem to redirect to default URL without using /Reports. It seems this option is disabled...

Anybody has any feedback on this. Would greatly appreciate if you could share any experiences you have had.

I checked documenation on setting URL access and could not fine any mention...

Never Mind. I hadn't enabled the Email Setting in SSRS.

I see the "Email" option now.

Thanks

Thanks Paul and Dixie for your resolutions.

I have used CTE's however haven't got the hang of recursive CTE's as yet, but will definitely will look into it as it is...

This is the desired output. It is also attached as an excel file to the initial post.

CreatedDateCodeValue

1/1/2009 0:00a1

1/1/2009 0:00b2

1/1/2009 0:00c1

1/1/2009 0:00d2

1/2/2009 0:00a1

1/2/2009 0:00b1

1/2/2009 0:00c2

1/2/2009 0:00d2

1/2/2009 0:00a0

1/3/2009 0:00b2

1/3/2009 0:00c2

1/3/2009 0:00d1

Thank you Imu92 for your response and suggestion.

Here is a script to create the table, insert some sample data and my starting query to accomplish the task.

--Creating the table

CREATE TABLE...