Turning a view into a stored procedure 1

[CrystalizeCanada]

Hi,

I have a view and I'd like to turn it into a Stored Procedure so I can add a parameter. I will then pick the Stored Procedure as a source for a Crystal Report that I'm creating instead of the view that I currently use.

At the moment the view is:
SELECT * FROM JOB

I'd like the stored procedure to give me
SELECT * FROM JOB WHERE Job_No = MyIntegerNumberParameterHere

Any help would be greatly appreciated.

Thanks
Gordon


Gordon BOCP
Crystalize

 

[Dagon]

Your best bet is to look at pipeline functions. There are plenty of examples on the net if you search.

 

[CrystalizeCanada]

Thanks Dagon

I'll have to spend some time on this before I get my head around it and get a working example.

Thanks for the suggestion.

Gordon

Gordon BOCP
Crystalize