I second!

That doesn't make a whole lot of sens to me... if rand or newid() is called only once in the query, then how come the result is really random... and...

Try reinstalling the application... or see if you have a place where you can setup the server info (server name, login,, password, database, etc).

Maybe there's some info that needs to...

Oh boy!, can you give us the loginc behind all this?

I'm sure we can optimize most of it, if not all of it, but we need more info.

No idea, I never used that.

What do you have to go on (what errors do you have)?

Please post the full code of the sp... and table definitions and sample data, along with the required results.

The short answer is do insert into () Select Make, Calculations, In...

Thanks for the info.

This is where I still have an issue :

Select order by newid() returns 95 rows

Select @concat = .... order by newid() = 1 row????

The query itself...

Since when can DateofBirth = "" ???

A date value is set to a date.... or null, period (sql server side).

Using the command prompt to start the installation :

SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword"

Get all the rest of the details here :

http://www.devnewsgroups.net/group/microsoft.public.dotnet.framework.adonet/topic12142.aspx

That's exactly the behavior I'm noticing: The order by newid() is working alright, the problem is further down the line where the concatenation happens (or does NOT happen).

The working plans have an extra compute scalar operation... which seems to be where the data is shot in the variable.

In the failing plan, there's a difference in the compute...

That's so cool, so many ways to screw up with the engine ;).

Hey Gaby, any way you can zip a backup of that DB here and post it in the forums?

I see many of you have far more experience in that domain that I'll ever have.

I have a new client with a hugely critical server for their system (central server...

And about me??? I met her there last year!!!!!!!!