FruitBatInShades Code

CREATE FUNCTION CSVTable(@Str varchar(7000))
returns @t TABLE (numberval int, stringval varchar(100), DateVal datetime)
AS
begin
 
declare @i int;
declare @c varchar(100);
 
SET @Str = @Str + ','
SET @i = 1;
SET @c = '';
 
while @i <= len(@Str)
begin
IF substring(@Str,@i,1) = ','
begin
INSERT INTO @t
VALUES (CASE WHEN isnumeric(@c)=1 THEN @c else NULL END,
rtrim(ltrim(@c)),
CASE WHEN isdate(@c)=1 then @c else NULL END)
SET @c = ''
end
else
SET @c = @c + substring(@Str,@i,1)
SET @i = @i +1
end
RETURN
end

CREATE FUNCTION fn_greatest_date
   (@date_1 datetime, @date_2 datetime, @date_3 datetime)
RETURNS datetime
AS
BEGIN
    DECLARE @return_date datetime
    SELECT @return_date = max(dateval)
    FROM
    (    SELECT @date_1 AS dateval UNION ALL
        SELECT @date_2 UNION ALL
        SELECT @date_3
    ) dates
 
 <a href="http://www.fruitbatscode.com/sql/get-largest-date#more-9" class="more-link">Read more...</a>