Home Forums SQL Server 2012 SQL Server 2012 - T-SQL stored procedure troubles RE: stored procedure troubles

  • May 9, 2013 at 6:03 am

    #1613745

    You cannot put SET in the middle of SELECT.

    It is a separate statement and should be placed before INSERT!

    Also, if you have some dates in English, then CONVERT will fail for this dates. As I've said before, dates in different languages should be processed separately. Please check my sample where it checks for date convertibility in the specific language.

    So, if you have dates in two languages you will need to do two separate inserts with checking if date is convertable (using ISDATE function).

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]