Home Forums SQL Server 2005 SQL Server 2005 General Discussion Query RE: Query

  • November 5, 2013 at 3:10 am

    #1664076

    Fix your join:

    left join VoucherType vt on vt.VoucherTypeCode = vt.VoucherTypeCode

    Comment out the date filter and rerun the query.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]