22,209
社区成员
发帖
与我相关
我的任务
分享
function [dbo].[fun_CategoryCodeName](@teamname uniqueidentifier)
returns varchar(4000)
as
begin
declare @temp varchar(4000)
set @temp = ''
set @temp = STUFF( (SELECT ','+M.CategoryCode+'|'+MC.CategoryName FROM (SELECT * FROM BookCategoryDetail where BookGuid = @teamname ) M
LEFT JOIN BookCategory MC ON M.CategoryCode=MC.CategoryCode FOR XML PATH('')),1,1,''
)
return @temp
end
select a.*,
[dbo].[fun_CategoryCodeName](a.BookGuid) AS CategoryCode
from BookInfo a
select a.*,
STUFF( (SELECT ','+M.CategoryCode+'|'+MC.CategoryName FROM (SELECT * FROM BookCategoryDetail where BookGuid = a.BookGuid ) M
LEFT JOIN BookCategory MC ON M.CategoryCode=MC.CategoryCode FOR XML PATH('')),1,1,''
) AS CategoryCode from BookInfo a