SELECT * FROM TaskBrowseView as A
OUTER APPLY(
SELECT
[keys]= STUFF(REPLACE(REPLACE(
(
SELECT [key] FROM TaskSearch N
WHERE taskId = A.id
FOR XML AUTO
), '<N key="', ','), '"/>', ''), 1, 1, '')
)N
Create View As
select * from (
select b.id as id, b.TaskNum as taskNo, b.ProductName as name, b.UserId as userId,
s.name as storeName, b.ProductImage as image, b.TaskType as type, b.ProductURL as url,
b.SearchCriteria as search, b.TaskState as state, p.NotReceived as received,
p.ToBeOperated as operated, p.ToBeEnsure as ensure, p.Completed as completd ,
b.CreatedDate as createDate from TaskBaseInfo as b, TaskProgress as p, Shops as s
where b.ShopId=s.Id and b.id = p.TaskId
) A
OUTER APPLY(
SELECT
[keys]= STUFF(REPLACE(REPLACE(
(
SELECT [key] FROM TaskSearch N
WHERE taskId = A.id
FOR XML AUTO
), '<N key="', ','), '"/>', ''), 1, 1, '')
)N
ps:
http://www.360doc.com/content/11/0806/23/5482098_138580249.shtml