Home Forums SQL Server 2008 T-SQL (SS2K8) Should I use a nested subquery? RE: Should I use a nested subquery?

  • October 11, 2012 at 8:41 am

    #1548168

    thomasrichardson2000 (10/11/2012)

    Didn't work just pulled back the same result set, I need the query to be able to search the vehicle table for all the modelid on the fleet at that time linked to the particular Modelid of the row returned. So if the modelid of a row is GRANDE PUNTO 1.2, I need the TotalModels column to reflect the count of that particular model on the fleet at that time. Thanks for the effort

    What didn't work?

    [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]