CREATE FUNCTION DBO.GetEmployeeContractInfo(@EMPLOYEE_UUID nvarchar(40), @FiledName nvarchar(20))
RETURNS sql_variant AS
BEGIN
DECLARE @Date sql_variant
SELECT @Date = @FiledName FROM EMPLOYEE_CONTRACT GROUP BY EMPLOYEE_UUID, VALUE
HAVING EMPLOYEE_UUID=@EMPLOYEE_UUID
RETURN @Date
END
RETURNS sql_variant AS
BEGIN
DECLARE @Date sql_variant
SELECT @Date = @FiledName FROM EMPLOYEE_CONTRACT GROUP BY EMPLOYEE_UUID, VALUE
HAVING EMPLOYEE_UUID=@EMPLOYEE_UUID
RETURN @Date
END
sql_variant output) AS
BEGIN
DECLARE @Date sql_variant
SELECT @Date = @FiledName AS VALUE FROM EMPLOYEE_CONTRACT GROUP BY EMPLOYEE_UUID, VALUE
HAVING EMPLOYEE_UUID=@EMPLOYEE_UUID
RETURN @Date
END
RETURNS sql_variant AS
BEGIN
DECLARE @Date sql_variant
SELECT @Date = @FiledName FROM EMPLOYEE_CONTRACT GROUP BY EMPLOYEE_UUID, VALUE
HAVING EMPLOYEE_UUID=@EMPLOYEE_UUID RETURN @Date
END
RETURNS sql_variant AS
BEGIN
DECLARE @Date sql_variant
SELECT @Date = @FiledName FROM EMPLOYEE_CONTRACT GROUP BY EMPLOYEE_UUID,VALUE
HAVING EMPLOYEE_UUID=@EMPLOYEE_UUID RETURN @Date
END