Post reply

SQL Task return value - Date value sometimes is a null

  • January 8, 2010 at 8:46 am

    #386066

    I have a SQL Task that calls a stored procedure and passes in 2 variables. The procedure returns a value by using a select command at the end.

    The select command selects a date value if there is one, otherwise it returns a Null. It isn't my stored procedure and other programs use it so I can't change it.

    When I run it and it returns a null value it gives me a date of 11/30/1999 12:00:00 am.

    Is there a way to convert the date type from the return to a string that can handle Nulls or another way to do this?

    Thanks for the help.

  • January 8, 2010 at 1:22 pm

    #1101155

    Have you tried using the ISNULL sql function?

  • January 11, 2010 at 8:23 am

    #1101831

    I ended up using a script function to get the return value and handle it if it is a null value with code.

    Thank's for the reply.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply