Database

eraser950 wrote:

because without zeroes its not sorting in ascending

like i have data
1
2
3
10
11
21
31

without zeroes its sorting like this

1
11
21
31
2
3

eraser950 wrote:

IF EXISTS (SELECT CityName From City WHERE CityName =@CityName)

BEGIN

SET @ReturnVal ='Already Exists!'

--Return @ReturnVal

END

IF EXISTS (SELECT CityName From City WHERE CityName =@CityName AND CityID<>@CityID)

michaelgr1 wrote:

all the names in one row

declare @tmp table (class int, name char)
insert into @tmp values (1, 'm')
insert into @tmp values (1, 'n')
insert into @tmp values (1, 'a')
insert into @tmp values (1, 'b')
insert into @tmp values (1, 'c')
insert into @tmp values (2, 'd')
insert into @tmp values (2, 'e')
insert into @tmp values (2, 'f')

select class,
replace(replace((    
	select replace(name,' ','*') as 'data()'    
	from @tmp t2    
	where t1.class = t2.class   
	for xml path('')),' ',','),'*',' ') as name
from @tmp t1
group by class

SELECT class,
  STUFF(
    (
    SELECT
      ',' + name
    FROM @tmp t2
    WHERE t2.class = t1.class
    FOR XML PATH('')
    ), 1, 1, '') AS data
FROM @tmp t1
GROUP BY class