Microsoft SQL function code example to pull Syteline shipto phone number.
USE [testsite_live_App]GO
/****** Object: UserDefinedFunction [MYSCHEMA].[_chad_SRO_packingslip_shipto_phone_number] Script Date: 06/24/2013 23:41:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [MYSCHEMA].[_chad_SRO_packingslip_shipto_phone_number](
@iDropType FSDropShipTypeType
, @iDropNum FSPartnerType
, @iDropSeq DropSeqType
)
RETURNS PhoneType
AS
BEGIN
DECLARE
@Phone PhoneType
,@UseCons ListYesNoType
SET @Phone = NULL
SELECT
@UseCons = use_consumer
FROM fs_parms
IF @iDropType IN ('C','N')
AND @iDropNum IS NOT NULL
AND @iDropSeq IS NOT NULL
BEGIN
SELECT @Phone = (SELECT phone##2 FROM customer
WHERE cust_num = @iDropNum
AND cust_seq = @iDropSeq)
END
ELSE IF @iDropType = 'U' --consumer
AND @iDropNum IS NOT NULL
AND @iDropSeq IS NOT NULL
BEGIN
IF @UseCons = 1
BEGIN
SET @Phone = (SELECT cons.phone##2
FROM fs_consumer AS cons
WHERE cons.usr_num = @iDropNum
AND cons.usr_seq = @iDropSeq)
END
ELSE --Consumers in Customer table
BEGIN
SET @Phone = (SELECT phone##2
FROM customer
WHERE cust_num = @iDropNum
AND cust_seq = @iDropSeq)
END
END
ELSE IF @iDropType = 'P'
AND @iDropNum IS NOT NULL
BEGIN
SELECT @Phone = MYSCHEMA._chad_Partner_Phone_number(@iDropNum)
END
RETURN @Phone
END