请问一条有难度的sql语句

if object_id('[tb]') is not null drop table [tb]gocreate table [tb]([ProductCode] int,[ProductName] varchar(7),[Type] varchar(4),[PackCode] varchar(8),[PackName] varchar(7),[PackType] varchar(4))insert [tb]select 400,'乐斯本','208L','00240781','乐斯本','大桶' union allselect 400,'乐斯本','208L','00240786','乐斯本','标签' union allselect 400,'乐斯本','208L','00241150','乐斯本','瓶子' union allselect 400,'乐斯本','208L','00341260','乐斯本','卷膜' union allselect 401,'乐斯本2','218L','00341261','乐斯本2','卷膜'goselect ProductCode,ProductName,Type,Msg=stuff((select ','+PackCode+PackName+PackType from tb where ProductCode=t.ProductCode for xml path('')),1,1,'')from tb tgroup by ProductCode,ProductName,Type/**ProductCode ProductName Type Msg----------- ----------- ---- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------400         乐斯本         208L 00240781乐斯本大桶,00240786乐斯本标签,00241150乐斯本瓶子,00341260乐斯本卷膜401         乐斯本2        218L 00341261乐斯本2卷膜(2 行受影响)**/