use [artea.mes]go/****** object: userdefinedfunction [dbo].[unionpart] script date: 11/18/2015 15:39:34 ******/set ansi_nulls ongoset quoted_identifier ongo-- =============================================-- author: -- create date: -- description: -- =============================================alter function [dbo].[unionpart](-- add the parameters for the function here@orderno varchar(30))returns [nvarchar](4000)asbegin-- declare the return variable heredeclare @returnvalue [nvarchar](4000)set @returnvalue = ''-- add the t-sql statements to compute the return value hereselect @returnvalue=@returnvalue + rtrim(ltrim(c.partname)) + ','from table1 c left join table2 d on d.orderid=c.orderidwhere d.orderno = @ordernoset @returnvalue = substring(@returnvalue,1,len(@returnvalue)-1)return @returnvalueendgo