Home Forums SQL Server 2008 T-SQL (SS2K8) T-SQL - How to get one row on a table witjh multiple records RE: T-SQL - How to get one row on a table witjh multiple records

  • Remove ",catalog.datfin" from GROUP BY.

    If you include it in the group by, you'll getting the minimum value for each date and that will be each date.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2