Home Forums SQL Server 2008 T-SQL (SS2K8) forming a dynamic query RE: forming a dynamic query

  • May 2, 2014 at 2:10 am

    #1710266

    ssurekha2000 (5/1/2014)

    i think query is unclear

    Transcation tbl has transcationdate, amount and cid

    Mas_C has cid and cname

    Transcation date displayed will be from & todate passed from the application

    1) the output needed is in all conditions

    transcationdate, amount

    if @<>type''

    output shld be transcationdate, amount

    if @cid<>''

    output shld be transcationdate, amount cname

    It's unclear what you want to do. You almost certainly don't need dynamic sql. How many result sets are you expecting from this? Try to write the query(ies) without using dynamic sql and post back if it doesn't work.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden