I have a stored procedure that performs a SELECT query. I call it with the command object like this:
Set rs = cmd.Execute
Can anyone show me how I can retrieve the row count? I was able to get it using @@rowcount in the stored procedure, but it only worked if I executed cmd without setting it to rs. I know I can do an rs.Open and get a record count, but I want to use the command object in this case. Can anyone help me?