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 &#060;%=row_count%&#062; it doesnt display anything.<BR>I am going wrong somewhere???