Is it possible that you only have 8 John Walter in the data, meaning that no more than 8 rows can be returned??

Wow... that's the simplest solution I have ever seen .

Why can't you use a counter client side when you display the data?

Try without the upper.

See any difference??

There's just no way around this one... BTW you should do that for ALL objects. It avoids a whole lot of troubles down the line.

Check it out in the...

Have you actually tested this solution Riyaz???

Yes there's a big tradeoff both is security and performance.

Check those out :

Arrays and Lists in SQL Server

The Curse and Blessings of Dynamic SQL

Dynamic Search Conditions...

...the patches are up...

Well it's his job at risk (or not), not mine :-).

This is what you are looking for :

This example uses the DISABLE TRIGGER option of ALTER TABLE to disable the trigger and allow an insert that would normally violate...

My questions was aimed at him avoiding the use of dynamic sql.. not encourage him :-).

You want to bypass in a specific tsql batch, or you need to bypass on a column base?

That's just a good habit.... First print the command, see if it will exec what you think it must exec, then make it run.  If you don't do that you...

As I said it changes in the exec itself, but that context is completely independant than the calling context.

Try something like this

DECLARE @dbname varchar(30)

SET @dbname = 'pubs'

declare @sqlt varchar (500)

set...

It does change it. The exec creates a new execution context. The db is use is changed for that new context but not for the current context.

What do...