I need count row number in a column. I know I can use @@RowCount but I need run select to make it work. But at the end I need run another select statement to feed the results to dataset in a report. But the dataset takes the first select results. So my question is how can I count the row without using select. Thanks in advance.