You're welcome.

Yeah, this site is pretty cool. Gotta agree with that.

The RedGate one is what I'm more familiar with.

When I want to export the data, I generally just query it myself directly.

cast(

case sum(IsNull(hmss.delivered_to_date, 0))

when 0 then 0

else

...

LOL!!!

Gail, your intimidation skill must be out the roof!

You can use @@Rowcount and your @value variable that way.

If you use @@Rowcount with a Where clause like you have, the code will compile and run, but it won't give...

You'd do the same thing as with the other division issue that I posted.

Use NullIf to turn the denominator into a null if it's zero, then use IsNull to replace...

Would "Paxton" be considered a valid "is contained by" for "Paxtonville"?

If so, then use something like:

select *

from TableA

inner join TableB

on TableA.Place like '%' + TableB.Place +...

You're welcome.

SQAPro (8/5/2009)

---

GSquared (8/5/2009)

---

You also have to assess the cost of protecting it.

If your company loses an average of one laptop per year, and spends an extra $100k per year on...

Role Playing Game

Rocket Propelled Grenade

Report Program Generator

Reasonable and Probable Grounds

And more, I'm sure.

One could even say, "In...

Forums are fine for whatever, but I second the idea of submitting it as an article.

Are you saying that the field contains more than one place name per row, in that column? That's what I'm reading it as, but I'm not certain I'm understanding...

This is probably/possible where the Div 0 error comes from:

SUM(hmss.BEDDING_CLOSE)/SUM(hmss.BEDDING_OPP)

If you use NullIf on the Bedding_Opp sum, you should be able to get rid of the error. If you...

Try this, see if it'll do what you need:

create table #T (

ID int identity primary key,

Col1 char(10));

insert into #T (Col1)

select 'AC/01/2008' union all

select 'AC/02/2008' union all

select 'AC/03/2008' union all

select 'AC/04/2008'...

Is it an inline or multi-value UDF?

Multi-value UDFs are treated like table variables by the database engine, which means it estimates one row per call, regardless of how many it...