USE [xtfsdz0331]
GO
/****** Object: UserDefinedFunction [dbo].[F_GetdepName] Script Date: 05/28/2019 13:46:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER function [dbo].[F_GetdepName](@depName VARCHAR(500))
returns table
as
return
with aa
as(
select * from confDep where depName like ‘%’+@depName+’%’
union all
select c.* from confDep c inner join aa a on c.depParentid=a.depID
)
select * from aa where LEN(produceDepCode) = 3