Try using the SET ROWCOUNT command...

Example:

/* Limit the result set to just 1 row*/

SET ROWCOUNT 1

/*Here comes your query... */

/* Disable the result set limit,...

I think you wolud use a temp table, like #Temp1 (Caption varchar(50), value decimal) ... make data type of value field match your requirements... an sql_variant would help...

I have 2 questions:

1) Would you consider sponsoring for HB1 Visa?

2) Would you help for international relocation? (Some kind of loan would be fine, salary plus, a plus!

Check this code... it would fit...

create table t1(i int, v varchar(10))

insert into t1 values (1,'H')

insert into t1 values (1,'e')

insert into t1 values (1,'l')

insert into t1 values (1,'l')

insert into t1...

..noeld wrote:

..Now be aware that you are changing ms stored procedures and that may

..lead to loose support from them. I understand that...