Home Forums SQL Server 2008 SQL Server 2008 - General SQL syntax error RE: SQL syntax error

  • December 10, 2013 at 10:25 am

    #1672381

    The query doesn't seem to haev an error. However, there's something that intrigues me. You're using WHERE offc_code IN (@Offc) and seems that @Offc might be a comma-separated value.

    If it's really a comma-separated value and you're building a string value for the query, then that might be the error, if you're not building the query on the fly, you might not get the correct value on your SELECT.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2