-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: anoop_cm
Message 4 in Discussion
hi rama,
Hope the followin sp will help you. But pls note that
string concatenation is not the very best thing to be done in sql.
CREATE procedure spGetDeptCodeAsCommaValues
AS
set nocount on
declare @comma table (
id int identity(1,1),
code char(5)
)
insert into @comma(code) select DepartmentID from department
declare @rowid as int
declare @maxrows as int
declare @returnString as varchar(8000)
declare @lenString as int
declare @code as varchar(5)
select @maxrows = count(*) from @comma
set @rowid = 1
set @returnString = ''
while @rowid < @maxrows
begin
select @code = code from @comma where id = @rowid
set @returnString = @returnString + ',' + @code
set @rowid = @rowid + 1
end
set @lenString = len(@returnString)
if ( @lenString> 1)
select right(@returnString,@lenString-1) as DeptCodes
RETURN
GO
HTH,
Anoop C M
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
