Joined: 15 Feb 2010
Online Status: Offline
Posts: 53
Topic: Stored Procedure Question? Posted: 22 Mar 2010 at 3:45pm
If I have a stored procedure that has data fields, does the data have to be in table somewhere?
Let me explain. I have a stored procedure that is called R_Cell_History. In this it has fields In Time, Out Time, Inmate Name and Cell. What I would like is these fields but not have the parameters that go along with it.
Is there a way to find these fields from this stored procedure or can write something to just pull these fields from this procedure?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 23 Mar 2010 at 4:19am
Do you mean you have s pre-existing SP that someone wrotet hat uses parameters but you want to use that same sp (or the data that it is combines) with no parameter usage?
Since the SP has the params in it you cannot use that one but you can create a new stored proc or a view that uses the same fields (and joins) and then use this as your data source.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
