Post reply

Why does my SELECT query only return results with "TOP XX" in front of it?

  • May 23, 2012 at 10:17 am

    #1491901

    tarr94 (5/21/2012)

    Thanks for the responses. I figured the function was probably causing this, but unfortunately, this is a query that is getting executed in our .NET code, and we'd rather not have to change our code which had been working fine up until we changed the data source recently. [..]

    When you say you "changed the data source", do you mean you changed the db server? Anything interesting there - ie are they both the same version/edition/patch level? options? (two digit year cutoff, anyone?) SET LANGUAGE? Codepage/collation?

    What about on the .NET side, do we have a potential problem with your fn_convert function handling different regional settings? What's the code look like there?

    If by "changed the data source", you mean something different... what exactly changed?

    >L<

  • May 23, 2012 at 10:35 am

    #1491921

    Hmm... My guess, at this point, is that it has something to do with your view definition. Can you post DDL for the view and any tables referenced within the view?

    Jared
    CE - Microsoft

Viewing 2 posts - 16 through 16 (of 16 total)

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