Hmm, that would involve a minor tweak in the CTE , andrew... here is the tweaked code..

;WITH CTE(Birthdate,ROWID, DATE_COUNT)

AS

(

SELECT Birthdate, MAX(ROWID) , COUNT(Birthdate) FROM [dbo].[Birthdate] GROUP BY Birthdate

)

SELECT

...

This might be helpful for some who accidentally tumbles upon this thread 😀

IF OBJECT_ID('TEMPDB..#CONCAT_COLUMN_VALUES') IS NOT NULL

DROP TABLE #CONCAT_COLUMN_VALUES

CREATE TABLE #CONCAT_COLUMN_VALUES

(

GROUP_ID INT,

COL_VAL VARCHAR(5)

)

INSERT INTO #CONCAT_COLUMN_VALUES

SELECT...

Andrew, how about this following piece of code??

;WITH CTE(Birthdate, DATE_COUNT)

AS

(

SELECT Birthdate, COUNT(Birthdate) FROM [dbo].[Birthdate] GROUP BY Birthdate

)

SELECT

BD.ROWID,BD.Birthdate, BD.FIRSTNAME, CTE.DATE_COUNT

FROM

[dbo].[Birthdate] BD

LEFT JOIN

...

Good Luck , Trybbe ! 🙂

Ronald beat me to it.. but there is a difference between my code and ronald's.. ron's uses cursors, mine doesnt.. and i have also CASE statements to bring out the...

trybbe, this below code might do the trick for you..

IF OBJECT_ID('TEMPDB..#part') IS NOT NULL

drop table #part

...

The problem is here buddy

You cant pass a local variable to DDL statments.. now what u have resorted to using this...

One of the local variable is initiated to NUL, buddy... Check up all of your local variables for null and then include them in your dynamice sql..

Guess am...

:blush: Thanks, Shilpa!!! Glad that the code helped and happy that your issue is resolved 😉

Buddy, as Lynn said, it really is hard to guess and tell u a solution.. so post ur sample records, ur table structure and desired output..

But for starters, i will...

You wanted a cold-coffee, and here is your coldcoffee presenting you with a cold code :-D!! check...

Hey there, can you give us the complete command u are trying to execute?

Wow, thats a...

Wonderful article WayneS.. a great read.. taught me new things about Ranking... Thanks 🙂