Re: [NF] Returning record count from SQL Server stored proc that returns cursor

2006-07-24 Thread Eugene Vital
vfpmcp wrote: Got a stored procedure that returns a record set just fine. There are times however that I just want the count. Rather than creating the SQL logic again, substituting the fields desired with the COUNT(*) instead, is there an easier way to simply say something like "give me the

[NF] Returning record count from SQL Server stored proc that returns cursor

2006-07-24 Thread vfpmcp
Got a stored procedure that returns a record set just fine. There are times however that I just want the count. Rather than creating the SQL logic again, substituting the fields desired with the COUNT(*) instead, is there an easier way to simply say something like "give me the @@rowcount of th