USER DEFINED FUNCTIONS (UDF)

(Home)
Top 3 Resources 
Resource SQL Server Performance.com
Resource SQL Server Central.com
Resource SQL Team.com
Quick Reference
   
Code
  CREATE FUNCTION prnType (@myType NVARChar(3))
RETURNS NVARCHAR(20)

BEGIN
DECLARE @myStr NVARCHAR(20)
IF (@myType='01A')
SET @myStr = 'Certificate'
IF (@myType='02A')
SET @myStr = 'Evaluation'
IF (@myType='03A')
SET @myStr = 'Repair'
IF (@myType='01B')
SET @myStr = 'Certificate Reprint'
IF (@myType='02B')
SET @myStr = 'Evaluation Reprint'
IF (@myType='03B')
SET @myStr = 'Repair Reprint'
IF (@myType='01D')
SET @myStr = 'Certificate PDF'
IF (@myType='02D')
SET @myStr = 'Evaluation PDF'
IF (@myType='03D')
SET @myStr = 'Repair PDF'

RETURN(@myStr)
END

 
  CREATE FUNCTION QAStatus (@QualityStatus int)
RETURNS NVARCHAR(20)

BEGIN
DECLARE @myStr NVARCHAR(20)
IF (@QualityStatus=0)
SET @myStr = 'Open'
IF (@QualityStatus=1)
SET @myStr = 'Completed'
IF (@QualityStatus=2)
SET @myStr = 'Rejected'
IF (@QualityStatus=3)
SET @myStr = 'Corrected'
IF (@QualityStatus=4)
SET @myStr = 'Approved'
RETURN(@myStr)
END
  CREATE FUNCTION woStatus (@completed bit, @QACheck bit, @QAReject bit)
RETURNS NVARCHAR(20)

BEGIN
DECLARE @myStr NVARCHAR(20)
IF (@completed<>0)
SET @myStr = 'Completed'
IF (@completed=0 and @QACheck<>0 and @QAReject=0)
SET @myStr = 'Quality'
IF (@completed=0 and @QACheck=0 and @QAReject<>0)
SET @myStr = 'Reject'
IF (@completed=0 and @QACheck=0 and @QAReject=0)
SET @myStr = 'Open'
RETURN(@myStr)
END
  CREATE FUNCTION woType (@Calibrated bit, @Evaluation bit, @Repaired bit)
RETURNS NVARCHAR(20)

BEGIN
DECLARE @myStr NVARCHAR(20)
IF (@Calibrated<>0)
SET @myStr = 'Certificate'
IF (@Evaluation<>0)
SET @myStr = 'Evaluation'
IF (@Repaired<>0)
SET @myStr = 'Repair'
IF (@Calibrated=0 AND @Evaluation=0 AND @Repaired=0)
SET @myStr = 'Unassigned'
RETURN(@myStr)
END