Hi, is it possible to combine Stored Procedure and Text Command Type in Select Statement?
I have a stored procedure that compute available items, it quite a bit long select statement,
now i need to call this statement in another select statement which is in text command type, how will i do it?
Select Barcode, ItemCode, Get_itemCount From Product
where Get_itemCount is my storedProc
Im using vb.net and Sql server 2008 R2
thanks in advance