Brilliant. That's fixed it.

Thanks very much 🙂

Jeff Moden (1/27/2009)

---

Can't tell... not enough information. You need to prove to yourself that you're passing something besides a null or a negative number for pages, pages, and rows...

Hi guys. Still cant get to the bottom of this. This is how im calling the SP:

exec [uspSearchProduct] @ListID=23,@OrderBy=N'Price',@OrderByDESC=1,@Page=0,@Pages=@p5 output,@RowsPerPage=10,@SearchString=N''

Definitely an integer value being passed.

Thanks again.

hey my friend.

OK i tried that and it generates the...

Brilliant stuff.

Thanks for the swift reply. Much appreciated.

Brilliant.

Thanks very much for your help GilaMonster! Top lady!

Ahhh ok mate, sorry i didn't notice one was asc and the other desc.

Is there any difference in...

GilaMonster (1/22/2009)

---

Row_Number is what you're looking for....

hi sam.

yeah i can see where your coming from. However i still don't understand this. The nested sub-query is going to bring you back the top 10 which is fair...

Hi sam, cheers for the...

Brilliant guys.

Thanks for the help, much appreciated.

Hi mate, cheers for the reply.

Is it not the case that would bring back a random 4 rows but not necessarily from the top 10?

Cheers.

Hi there, thanks very much for the swift response.

Basically im looking to pull 4 random products from a product table, however these four products should be in the top 10...

Hi Steveb, thanks again.

I need all the fields.........but its only distinct ReviewId's im interested in.

[ReviewID] is an integer field on the base table which the view is looking at.