USE ***GO/****** Object: UserDefinedFunction [dbo].[FN_GET_GUIDESHEET_ITEM_INFO] Script Date: 08/15/2012 12:13:39 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER FUNCTION [dbo].[FN_GET_GUIDESHEET_ITEM_INFO](@CLIENTID VARCHAR(15), @PID1 VARCHAR(5), @PID2 VARCHAR(5), @PID3 VARCHAR(5), @GET_FIELD VARCHAR(200), @GuidesheetType . . . .More of same . . . = @VCOMMETS IF UPPER(@GET_FIELD) IN ('TYPE','GUIDESHEET NAME') SET @V_VALUE = @VGuidesheetType IF UPPER(@GET_FIELD) = 'STATUS' SET @V_VALUE = @VGuidesheetStatus IF UPPER(@GET_FIELD) IN ('ITEMS','ITEM') SET @V_VALUE = @VGuidesheetItems RETURN @V_VALUE END
And made it this:
USE ***GO/****** Object: UserDefinedFunction [dbo].[FN_GET_GUIDESHEET_ITEM_INFO] Script Date: 08/15/2012 12:13:39 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER FUNCTION [dbo].[FN_GET_GUIDESHEET_ITEM_INFO] (@CLIENTID VARCHAR(15),@PID1 VARCHAR(5),@PID2 VARCHAR(5),@PID3 VARCHAR(5),@GET_FIELD VARCHAR(200),@GuidesheetType VARCHAR(4000),@GuidesheetItems VARCHAR(4000),@GuidesheetStatus VARCHAR(100))RETURNS VARCHAR(200)ASBEGINDECLARE @VCOMMETS VARCHAR(4000)... more of same ...'ITEMS','ITEM')SET @V_VALUE = @VGuidesheetItemsRETURN @V_VALUEEND
Thank You Internet and Thank you Tao Klerks.
No comments:
Post a Comment