Home Forums SQL Server 2005 T-SQL (SS2K5) Date Conversion Fails in Stored Procedure - But code works in a Trigger !? RE: Date Conversion Fails in Stored Procedure - But code works in a Trigger !?

  • May 7, 2013 at 5:47 am

    #1612935

    SteveEClarke (5/7/2013)

    Totally amazing when you read a piece of code so many times and blind by your own perfections.

    Have a sandwich .... have a drink .... come back ....

    Only to discover that those pesky little code faries have put the columns in a different order !!

    So ( after correcting their meddling! ) putting the date field instead of the string field - amazingly it works brilliantly.

    Thanks for listening -

    Apologies for wasting any of your valuable time

    Thanks for posting back and no problem - we all do it:-)

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.