That's not true. I'm a

However, you will see a great confusion and misunderstanding among the SQL Server community when it comes to Backup, T-Log...

See if this helps

declare @a varchar(40)

set @a = 'Screw, 1/4 inch diamerter, 1 inch long'

set @a = replace(@a,',','.')

select

ltrim(rtrim(parsename(@a,3)))

,ltrim(rtrim(parsename(@a,2)))

,ltrim(rtrim(parsename(@a,1)))

This will leave some clean up work for you to do.

I don't think you'll get the excellent responses that you need from online communities. You should really consider some consulting advise who can determine your needs and requirements right at...

It is an acceptable randomizer used to return random rows.

Oh my, probably easier is to simply look at the execution plan

StmtText ...

Oh, I see.

But are you concerned about the difference on the 14th decimal place anyway?

When you play with the example given in BOL and recalculate this in Excel you'll...

Sure, there are myriads of source out there.

Personally I like this one:

http://mathworld.wolfram.com

Do a site and/or online search (including the Google Groups) with smart search criterias. You will find almost everything you need to know there. If not, feel free to ask here.

I think you can't use the aliases here at all. Try and replace this with (Max(o.originaltotal)/Max(s.quantity) as [qty]) AS AVGPrintPrice

Aah, more of this...

Hm, strange. Are you sure you have the latest version of BOL?

This is what I can find in my BOL version:

WITH CHECK | WITH NOCHECK

Specifies whether the data in...

IMHO, I would say the latter in the case

This one works for me:

use northwind

select cast(unitprice * quantity as decimal(8,2)) as price from [order details]

group by productid,cast(unitprice * quantity as decimal(8,2))

Without knowing your environment in details, it's like a shot in the dark. Maybe you should get some consulting advise on that. In the meantime, this might be of some...

Michael,

just out of curiosity, can you post the text from BOL.

All I have found in the explanations for ALTER TABLE is:

When a new PRIMARY KEY or UNIQUE constraint is...