Home Forums SQL Server 7,2000 T-SQL Single record from Multiple child records via Select statement only RE: Single record from Multiple child records via Select statement only

  • I created a view that returned a record number for each sku within the group then modified your query to be based on this view and it works fine.

    Thanks for the suggestion   =:-)