This query doesn't work as expected.
select
rd.System_Id as BizStoryID ,0 as TechStoryID ,0 as TaskID from
#UpdatedWorkItemRawData rdleft join #ItemHierarchyPrep ihon rd.System_Id = ih.BizStoryIDand rd.System_WorkItemType = 'eScrum Product Backlog Item'and rd.TeamProjectSK = @ProductBacklogProjectNodeSKwhere ih.BizStoryID is null
To get what I need, the following query is needed.
select rd.System_Id as BizStoryID ,0 as TechStoryID ,0 as TaskID from
#UpdatedWorkItemRawData rdleft join #ItemHierarchyPrep ihon rd.System_Id = ih.BizStoryIDwhere rd.System_WorkItemType = 'eScrum Product Backlog Item'
and rd.TeamProjectSK = @ProductBacklogProjectNodeSKand ih.BizStoryID is null
Join The Fabric User Research Panel!
-
As you probably know, I work on the Fabric Customer Advisory Team at
Microsoft. Apart from advising customers a lot of our team’s time is spent
collecting ...
4 days ago
No comments:
Post a Comment