Database

CREATE FUNCTION fn_Split
    (
        @sText 	 varchar(8000), 
        @sDelim  varchar(20) = ' '
    )
RETURNS @retArray TABLE 
    (
        idx smallint Primary Key, 
        value varchar(8000)
    )
AS
BEGIN
DECLARE @idx smallint,
    @value varchar(8000),
    @bcontinue bit,
    @iStrike smallint,
    @iDelimlength tinyint
 
    SELECT
        @idx = 0,
        @bContinue = 1,
        @sText = LTrim(RTrim(@sText)),
        @iDelimLength = CASE
            WHEN @sDelim Is Null THEN 0
            WHEN @sDelim = 'Empty' THEN 0
            WHEN @sDelim = 'Space' THEN 1
            ELSE DataLength(@sDelim)
        END,
        @sDelim = CASE
            WHEN @sDelim Is Null THEN ''
            WHEN @sDelim = 'Empty' THEN ''
            WHEN @sDelim = 'Space' THEN ' '
            ELSE @sDelim
        END
 
 
    IF NOT (@iDelimlength = 0)
    BEGIN
        WHILE @bcontinue = 1
        BEGIN
--If you can find the delimiter in the text, retrieve the first element and
--insert it with its index into the return table.
 
            IF CHARINDEX(@sDelim, @sText)>0
            BEGIN
                SET @value = LTrim(RTrim(SUBSTRING(@sText,1,CHARINDEX(@sDelim,@sText)-1)))
 
                INSERT INTO @retArray (idx, value)
                VALUES (@idx, @value)
 
--Trim the element and its delimiter from the front of the string.
--Increment the index and loop.
                SELECT
                    @idx = @idx + 1,
                    @iStrike = DATALENGTH(@value) + @iDelimlength,
                    @sText = LTrim(RTrim(Right(@sText,DATALENGTH(@sText) - @iStrike)))
            END
            ELSE
            BEGIN
--If you can’t find the delimiter in the text, @sText is the last value in
--@retArray.
                SET @value = LTrim(RTrim(@sText))
                INSERT INTO @retArray (idx, value)
                VALUES (@idx, @value)
--Exit the WHILE loop.
                SET @bcontinue = 0
            END
        END
    END
    ELSE
    BEGIN
        WHILE @bcontinue=1
        BEGIN
--If the delimiter is an empty string, check for remaining text
--instead of a delimiter. Insert the first character into the
--retArray table. Trim the character from the front of the string.
--Increment the index and loop.
            IF DATALENGTH(@sText)>1
            BEGIN
                SET @value = SUBSTRING(@sText,1,1)
                INSERT INTO @retArray (idx, value)
                VALUES (@idx, @value)
 
                SELECT
                    @idx = @idx+1,
                    @sText = SUBSTRING(@sText,2,DATALENGTH(@sText)-1)
 
            END
            ELSE
            BEGIN
--One character remains.
--Insert the character, and exit the WHILE loop.
                INSERT INTO @retArray (idx, value)
                VALUES (@idx, @sText)
                SET @bcontinue = 0	
            END
        END
    END
 
    RETURN
END

Create Proc dbo.spSetBillingPlan_Custom
(
    @ContractNumber int,
    @PhaseNum       varchar(8000),
    @Perc           varchar(8000)
)
As
DECLARE @ArgTable TABLE(PhaseNum int, Perc decimal(5,4))
    INSERT INTO 
        @ArgTable (PhaseNum, Perc)
    SELECT
        CAST(PhaseNum.value As int),
        CAST(Perc.value As decimal(5,4))
    FROM
        dbo.fn_Split(@PhaseNum, ',') As PhaseNum
        INNER JOIN
        dbo.fn_Split(@Perc, ',') As Perc
        On PhaseNum.idx = Perc.idx
 
    --yadda yadda yadda

CREATE TABLE [CaseSense] ( 
        [ColA] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL , 
        [ColB] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL 
) ON [PRIMARY] 

insert into CaseSense values ('aaaa','aaaa')
insert into CaseSense values ('bbbb','BBBB')

--then

select * from casesense where cola=colb
-- will return the first record

select * from casesense where not cola=colb
 -- will return the other one.

<br />
SELECT table1.name COLLATE SQL_Latin1_General_CP1_CS_AS <br />
FROM table1<br />
WHERE table1.name NOT IN<br />
    (SELECT table2.name COLLATE SQL_Latin1_General_CP1_CS_AS FROM table2)<br />