Advertisement
Guest User

Untitled

a guest
Jan 18th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.42 KB | None | 0 0
  1. DECLARE @Item hierarchyid
  2. SELECT @Item = [DirNode]
  3. FROM [dev].[dbo].[Files]
  4. WHERE ClientID = 2
  5.     AND ProjectIDFilter=1055
  6.     AND [DirNode] ='/3/3/'
  7.  
  8. SELECT [DirNode].ToString()
  9.       ,[DirLevel]
  10.       ,[ParentDirNode].ToString()
  11.       ,[ClientID]
  12.       ,[ProjectID]
  13.       ,[ProjectIDFilter]
  14.       ,[Name]
  15. FROM [dev].[dbo].[Files]
  16. WHERE ClientID = 2
  17.     AND ProjectIDFilter=1055
  18.     AND [DirNode].GetAncestor(1) = @Item
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement