I want the no. of rows returning from a specific query. <BR>Eg. Select * from xyz where ID="1" has 10 rows... <BR>In my asp page I want it to return the no. 10...I am getting all my rows individually but it is not picking up the no. <BR>In my stored proc I have taken it as an output parameter. <BR>set @row_count = (Select @@rowcount) <BR>and in the asp page I have <BR>row_count = cmd.Parameters("@row_count").value <BR><BR>but when I call <%=row_count%> it doesnt display anything. <BR>I am going wrong somewhere???