Hello! is there any trick to select a fixed number of rows? I mean, no matter if I have 2 rows which match the select, I need to always return 10 rows. Of course the last 8 would be all null in this example...

I hope I'm clear with my question! Not sure if I'm in the "right path", but if I can do that I can fix very easily a stored procedure I'm working on now.

Thanks!!

Sergio