Home Forums SQL Server 2008 SQL Server 2008 - General Error converting data type varchar to datetime in stored Procedure RE: Error converting data type varchar to datetime in stored Procedure

  • January 3, 2012 at 12:54 am

    #1427567

    ,CONVERT(Datetime,E.[LNK_CreatedBy_ID],103) as [LNK_CreatedBy_ID]

    E.[LNK_CreatedBy_ID]= Case when @LNK_Client_ID IS NOT NULL THEN @LNK_Client_ID

    Else E.[LNK_CreatedBy_ID] End and

    @LNK_Client_ID numeric(18, 0) = NULL,

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]