Post reply

CASE in WHERE clause

  • March 14, 2013 at 9:41 am

    #1597095

    Note, this isn't just about the WHERE clause. You can also potentially eliminate complete hits (joins) on tables if you don't actually need to filter on them based on input parameters.

    I am wondering - why are you looking to get rid of a java process that already creates the proper (assuming it does) dynamic SQL?

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • March 14, 2013 at 10:20 am

    #1597121

    Keep searching.... :hehe:

    I also like to invent bicycles in my free time. Stupid clients/employers, they don't like to pay me for spending time on such an exciting hobby of mine ... 😉

    _____________________________________________
    "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]

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

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