Yup you're really looking for a function here... however, it might even be better to just use a derived table in this case. What's the code of the proc?

Also,...

Do you have a primary key on the table?

Hard to say what's heppenning I'd have to be there cause I never saw that either.

Well like I said I would drop the function part of it and just put the code function in the page since there shouldn't be much else on that page...

Tell them to use the freaking wizards, it types them by default and it saves 'em typing time .

Who requested this to you???

Never been bitten by this one... and I'll keep it that way .

the sp resides on sql server

asp code resides on another machine (at least another process)

asp uses this code to call the code on the server and execute it.

This is the most important part of my request : SAMPLE DATA/RESULTS.

Something like this?

Select YourColumns from dbo.tblOrders O inner join dbo.tblOrderPayments OP on O.OrderID = OP.OrderID

where ?.ProductCode = @SomeValue and OP.PaymentSuccess = 1

Set MyParam = New ADODB.Parameter

starts with a fresh parameter object

MyParam.Name = "@SRhospitalCanvass"

sets the name, mandatory

MyParam.Value = SRhospitalCanvass

sets the value, mandatory

MyParam.Size = 10

sets the size of the...

You can't filter squat without a where condition.

As for the 5th row, that's another problem altogether. What is the primary key of the table?

Read the link and follow the instructions. I'm ready to help you but you have to give me the info I need (SAMPLE DATA/RESULTS).

Ya those were good times .

"Am I 3 minutes slower than Remi "

That's almost a compliement to you .