create FUNCTION [dbo].[GetApplySpec](@ApplyID int)
RETURNS varchar(200)
AS
BEGIN
declare @ret varchar(200)
set @ret=''
declare @spec varchar(50),@Quantity varchar
declare s_cursor cursor for
select spec,Quantity from V_SwatchDetail where
OPEN s_cursor
FETCH NEXT FROM s_cursor INTO @spec,@Quantity
WHILE @@FETCH_STATUS = 0
BEGIN
select @ret=@ret+'【型号:'+@spec+' 数量:'+@Quantity+'】'+'<br />'
FETCH NEXT FROM s_cursor INTO @spec,@Quantity
END
CLOSE s_cursor
DEALLOCATE s_cursor
RETURN @ret
END