CRM 2011 组织关系树查询
摘要:
declare @username nvarchar(20),@id nvarchar(50) set @username='李帅'; select @id=businessunitid from systemuser where fullname=@username; select name ,parentbusinessunitidname from businessunit where businessunitid=@id;WITH StepCTE AS (SELECTbusinessunitid,parentbusinessunitid, parentbusinessu 阅读全文
posted @ 2013-04-03 10:26 HelloHongfu 阅读(187) 评论(0) 推荐(0) 编辑