Advertisement
Guest User

Untitled

a guest
Feb 20th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. SELECT *
  2. FROM WRMaster W
  3. WHERE DATEDIFF( minute, W.AckedDateTime, W.ResolvedDateTime )<=
  4. (
  5. SELECT PriorityKey
  6. FROM FMSLAClassPriorityMap
  7. WHERE SLAClassKey=(EXEC dbo.GetSLAClass W.LocationKey,W.ServicCategoryKey,W.ProblemTypeKey,NULL,'')
  8. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement