I don't believe you can store this in variables with osql.

Powershell can do something like this if you install it on your servers.

Make this a CTE and then use a "where amt > 0" in the outer query that selects from the CTE?

First you need to provide more data that would show how you get the test2 data as well as the results you are looking for.

Second, this seems like homework or...

Jeff is right. You cannot insert into scalars. you can reassign variables (as in my first post), but INSERT is only for Table(like) structures.

That's what I'd do. Or you can try "Execute AS", not sure if that will work in this context, but it's interesting.

Are you sure you want to move all data? Replication, while a small load on the LIVESERVER, is the least amount of data moving.

there are creative ways to do things....

You must have differnt data or something else different. I have never even seen or heard of a bug returning different data because of different processor counts.

You should report this...

I am part owner in End to End Training, in Orlando, but good training. We do have a custom mentoring course if you want it.

Are you looking to admin or...

Dice and Monster are very popular with recruiters, who list most of the jobs. Some private individuals on Monster. not sure if JustSQLserverJobs.com is still out there or used.

Do you mean reset someone else's password?

I don't think that specific permission exists.

Is that the same issue?

Is Litespeed installed or are you wondering about what you are about to install? I'm not sure other than the filename or the download.

I'd download again and then see if...

I wouldn't recommend 64-bit with SQL 2000, but if you are 2005 or 2008, it should work fine.

This isn't likely a SQL issue, but a display issue. SQL Server does not remove CHR(13) from your text if you insert it with those characters in there. It is...

What do you mean by optimize here?

This sounds like a test or interview question. Please show some effort here and give us what you are looking for, why, what thoughts...