Then maximum of the two dates should be chosen.

Sorry, this actually had to be in SQL2005 forum as it used table datatype in sample query, by mistake i posted in SQL2000.

hi,

but what if all values are same and only date is diiferent for 2 rows.

then which date will be selected ?

like for example

[Code]

insert into @tbl

select 1,'R','1/1/2009',1,'A'

union

select 1,'R','1/2/2009',1,'A'

union

select 2,'M','1/1/2009',3,'A'

union

select 2,'M','1/2/2009',3,'A'

union

select 3,'N','1/3/2009',6,'A'

[/Code]

Thanks :w00t: thats what i needed

Is this magic of recursion ?

I will be very thankful if you give a brief idea of that query.

Thanks again.

Hi,

I did this,

[Code]

SELECT STUFF((SELECT ', ' + Table.ColumnName FROM Table FOR XML PATH('')),1, 1, '') AS CSVColumn

[/Code]

Hi,

I used the normalized design for my case.

If i want my output to be in this form for a student then?

Name SelectedSubjects

--------------------------

A Maths,History,Drama

B ...

Thanks for your help

Hi,

So i will have 3tables. viz.

1) tbl_Names : All students names (with a unique id nId).

2) tbl_AllSubjects : A pool to have all the subjects from where students can choose...

Thanks a lot friends !! it helped me a lot !

Hi,This one takes a string...

arun.sas (6/25/2009)

Hi,

try this

--create table #temp (name1 varchar(5))

declare @s-2 varchar(500)

set @s-2='1,2,3,4,5'

select @s-2 = 'select ''' +...

Thats amazing thank you so much !! :w00t:

Anything to take care using

Thanks again ... i am a newbie so few doubts are still there !

Sorry, but if i use any random integer like 89 then this also works ?

Is it always needed to write 0 and 1 in the case.

What does 0 and 1 refer here?

does select becomes " select t from @t order by 1,t" at...