From a performance point of view you would probably be better off having 2 stored procs, one for quantity and one for amount

Try re-writing your function (getChild) which I am assuming is using the parameter in a where clause

Create a local parameter of type int and set that parameter to the value...

Hi,

You are trying to output the recordset object, what you need to do is output it's contents. Have a look at the rs.getstring method or you can loop the recordset

do...

okay assuming your temp table is called #wl and contains all the words you want

and you have a table PThread that has ID and URL fields

and you have a...

Is the clustered index on the Word or the RowID? (I assume the rowid is there simply to make a unique value

If your search app is trying to find all...

In the same way that you can use HOST_NAME to get the HOST you can also use APP_NAME() to get the application that initiated the proc

From BOL

This example checks whether...

Try

="In Herd " & First(Fields!Id.Value) & " " & "[" & First(Fields!ProfilePinNumber.Value) & "]"

G