CREATE PROCEDURE [dbo].[get_string_id_and_name]
@strName nvarchar(4000) output,
@strid nvarchar(4000) output
AS
select @strName = ''
select @strid = ''
select @strName = @strName + COALESCE(ProductName + ',', ' '), @strPid = @strPid + COALESCE(ProductID + ',', ' ')
from Product_Table
order by ProductName
@strName nvarchar(4000) output,
@strid nvarchar(4000) output
AS
select @strName = ''
select @strid = ''
select @strName = @strName + COALESCE(ProductName + ',', ' '), @strPid = @strPid + COALESCE(ProductID + ',', ' ')
from Product_Table
order by ProductName