Home Forums SQL Server 7,2000 T-SQL Return a Table from a Stored Procedure RE: Return a Table from a Stored Procedure

  • Your frontend (Visual Basic) would not really know whethere you have used a temp table or if you are fetching data from the original table. Its all inside your stored procedure. All that your stored procedure returns is a result set and you would use the base syntax of

    IF NOT RecordSet.BOF AND RecordSet.EOF

    Do logic like Recordset.movenext , Recordset.moveprevious etc

    ----

    or you can bind to the grid using

    .Datasource property

    Prasad Bhogadi
    www.inforaise.com