Please don't create duplicate threads for the same issue. This will fragment the replies.

Original Thread: http://www.sqlservercentral.com/Forums/Topic1287441-392-1.aspx

You can add one more column "rownodesc" similar to "rowno" with ORDER BY option as "testCol DESC"

SELECT*,

CASE

WHEN a.rowno>1 AND a.rownodesc = 1 THEN 'Last'

THEN a.rowno>1 THEN 'DUP'

ELSE 'First' END AS...

Is this an Interview/Homework question?

Share what you have tried so far.

We will help you out from wherever you are stuck.

This will help you learn better.

Yes. This is the correct place to ask T-SQL questions related to SQL Server 2008.

Welcome to SSC 🙂

Glad you could solve the issue yourself 🙂

You will learn a few more things if you check the link I referred to in my earlier post

This should help you out for time-being.

I think there was a similar post even earlier which had more than one solution, will check and re-post if I get it.

DECLARE @files...

Good Question. Made me think a lot.

Though I knew the existence of WITH TIES option, I never really used it and never bothered to get the exact details of how...

Annee (3/21/2012)

---

I get the following error when I modified it the way you suggested

'An explicit value for the identity column in table 'DGSData.dbo.DocumentHoldBackup' can only be specified when a column...

Bhuvnesh (3/20/2012)

---

@kinston,

i liked you reply it helped me but one doubt ?

do we really need

case when c.name LIKE '%[0-9]' then '' else c.name end -- needed to sort...

Hope this helps

declare @t table (name nvarchar(50))

insert into @t

select 'count_1'

union select 'acct_id'

union select 'count_19'

union select 'count_2'

union select 'count_29'

union select 'count_3'

union select 'count_30'

union select 'count_100'

union select 'count_stub'

union select 'prod_count_stub'

union select 'count_id'

union...

Not sure what you need exactly. Can you post the expected result based on your updated sample data above.

Jeff Moden (3/16/2012)

---

er.sivaganesh (3/16/2012)

---

thanks for every one who joined in this discussion i just solved this problem by creating cusor in...

jean 93062 (3/12/2012)

---

I want to set taxid = 1 to all new records in this table. I also want the user to be able to change the taxid to...

You can also have a look at the book mentioned in the below link

Mastering SQL Server Profiler - Brad McGehee

http://www.sqlservercentral.com/articles/books/65797/

You can solve the problem by using a CROSS TAB or PIVOT

http://www.sqlservercentral.com/articles/T-SQL/63681/ - Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

http://www.sqlservercentral.com/articles/Crosstab/65048/ - Cross Tabs and Pivots, Part...