I have an store procedure which will return the file type rights of the user with one column "FileTypeID" with multiple rows.
Now i have an another requirement in another stored procedure which will have to take that "FileTypeID" and based on that it has to retrieve the documents in the DB.
For this I need to know how to assign the output of the stored procedure to
For e.g., SELECT * FROM Docs WHERE FileTypeID IN ([file types to which the user has the rights which is retrieved from the previous stored procedure]
Can any one help in this regard?Thanks a lot in advance.
Nothing is impossible with Hard Work