Post reply

how to write a select query using a procedure name instead of a view name

  • June 13, 2006 at 5:24 am

    #168836

    i have written a select query using a view name which i pass to crystal reports through the crystal report control in vb 6. it works perfectly. it is as follows :

    "Select * from vRptListofMembers"

    vRptListOfMembers is the name of my view

     

    i now want to use a stored procedure named pListOfMembers instead of the view. so how should i word my select query ?

    thank you in advance for your help

     

     

  • June 13, 2006 at 6:45 am

    #643351

    Hi Janice,

    try this: "exec pListOfMembers".

    You don't select from a procedure in the same way that you can from a view. With procedures, you just execute them.

    Hope that helps,

    Karl
    source control for SQL Server

  • June 13, 2006 at 7:05 am

    #643360

    thanks karl

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply