One of five orders?

Wouldn't a simple

SELECT TOP 20 PERCENT OrderID

FROM Table1

ORDER BY NEWID()

do?

Thank you very much for your insights and patience with me!

I think maintenance team will have enough information now to stop "bugging" me, and you, any more for this matter.

I have a follow-up question.

The application is run on a desktop and when the application fails to connect to primary data site (for any reason), it will then try to...

Thank you again.

I'll pass on the links to maintenance team for examination.

Have a great day!

No, we haven't looked at database mirroring. Thank you for the tip!

There are 5-6 databases of 15-20 gb each.

You maybe don't need virtualization.

You can use instances, for example the 8 old servers can be 8 instances on the new server.

No problem.

Just be aware of that only one instance can be DEFAULT instance.

The other instance must be fully named in your connection string as [Computer]\[Instance]

If this doesn't suite your needs, your only option left is to have 5 separate updates.

UPDATEuser

SETname = CASE WHEN @name name THEN @Name ELSE Name END,

type = CASE WHEN...

Great!

I know I have a good solution for original AdventureWorks, but I have no idea how well it scales.

Sorry for the interruption people...

Hi Adam!

You're done testing Grouped String Concatenation Challenge?

create procedure update_user

(

@id int,

@name nvarchar(100),

@type nvarchar(6),

@add_date date,

@email varchar(50),

@phone int

)

as

set nocount on

UPDATEuser

setname=@name

, type=@type

, add_date=@add_date

, email =@email

, phone=@phone

WHEREid =@id

and (

name @name

or type @type

or add_date @add_date

or email...

You want the result as a comma-delimited string?

Hi jsanborn.

Did you try my second suggestion yet?

Not really.

Try with the sample data provided by Mr Young.

AVGCorrectSequence

0.848343807091231

1.941816529992232

3.1029747509888821

3.637067671983737

3.7789496156818643

4.224919996747955

Here is a recent article about Paging

http://www.sqlservercentral.com/articles/T-SQL/66030/

And here is the following discussion

http://www.sqlservercentral.com/Forums/Topic672980-329-1.aspx