Guest User

Untitled

a guest
Apr 19th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. var ans = from a in vw_DimLabAsset
  2. join w in vw_FactWorker on a.LabAssetAssignedToWorkerKey equals w.WorkerKey
  3. join o in vw_DimOrganizationHierarchy on w.OrganizationHierarchyKey equals o.OrganizationHierarchyKey
  4. where o.OrganizationHierarchyUnitLevelThreeNm != null && o.OrganizationHierarchyUnitLevelFourNm != null
  5. group new { o, a } by new { o.OrganizationHierarchyUnitLevelThreeNm, o.OrganizationHierarchyUnitLevelFourNm, a.LabAssetSerialNbr } into oag
  6. select new {
  7. oag.Key.OrganizationHierarchyUnitLevelThreeNm,
  8. oag.Key.OrganizationHierarchyUnitLevelFourNm,
  9. oag.Key.LabAssetSerialNbr,
  10. MinCreated = oag.Min(oa => oa.a.SystemCreatedOnDtm)
  11. };
Add Comment
Please, Sign In to add comment