Stored Procedure Return Value HELP!

[Lisana]

how can I return vaule recordset and @@rowcount from stroed procedure in asp? Stored Procedure: CREATE Pro sp_results ( @FileNumber varchar(100), @StreetNumber varchar(50) ) AS SET NOCOUNT ON BEGIN SELECT RecordIndexDB.entity_id, RecordIndexDB.job_entity_id, RecordIndexDB.file_number, RecordIndexDB.file_location, RecordIndexDB.street_name1, RecordIndexDB.street_name2, RecordIndexDB.street_name3, RecordIndexDB.street_name4, RecordIndexDB.street_name5, RecordIndexDB.street_number1, RecordIndexDB.street_number2, RecordIndexDB.street_number3, RecordIndexDB.street_number4, RecordIndexDB.street_number5 FROM RecordIndexDB WHERE RecordIndexDB.status = 1 AND ( (RecordIndexDB.file_number Like '%' + @FileNumber + '%' AND len(@FileNumber)>0 ) OR (len(@FileNumber)=0) ) AND ( ((RecordIndexDB.street_number1 Like '%' + @StreetNumber + '%' OR RecordIndexDB.street_number2 Like '%' + @StreetNumber + '%' OR RecordIndexDB.street_number3 Like '%' + @StreetNumber + '%' OR RecordIndexDB.street_number4 Like '%' + @StreetNumber + '%' OR RecordIndexDB.street_number5 Like '%' + @StreetNumber + '%') AND len(@StreetNumber)>0 ) OR (len(@StreetNumber)=0) ) ORDER BY RecordIndexDB.file_number ASC END Return @@RowCount In my asp page, I have a recordset to hold the results, but I don't know how to get the @@RowCount value. have any idea??

Lisa

[Private_Void]

Lisa you have a couple of options... First you could execute your sql command as executereader (which returns a data reader) and you could read from that. You could execute your sql command as executescalar which returns the first row of the SP as a string. For both of these options you will need to SET @Rowcount = @@RowCount then SELECT @RowCount. Or you could have an output parameter in your stored proc. Your asp code would need to be looking for a parameter type of output in order to grab this value. This article should help you assess what you would like to do http://aspnet.4guysfromrolla.com/articles/062905-1.aspx[^] I hope this helps.