TSQL Return Record Counts with Dataset
Posted on 2010-09-20
I've got a stored proc that returns search results using FREETEXTTABLE and all works fine.
However, I would love to also return the count of records that have a value < £100, £100 - £300, £300 - £600, £600 - £1000 and > £1000.
I've got a count select statement to work within the SP, I just dont know how to pass these extra results though a function and onto the web page.
Any help would be greatly appreciated even if it's to tell me this is a bad idea!