I think you can remove this block:

OR A.[MESSAGE] LIKE '%[$][0-9] OFF%'

OR A.[MESSAGE] LIKE '%[$][0-9][0-9] OFF%'

OR A.[MESSAGE] LIKE '%[$][0-9][0-9][0-9] OFF%'

OR A.[MESSAGE] LIKE '%[$][0-9].[0-9][0-9] OFF%'

OR A.[MESSAGE] LIKE '%[$][0-9][0-9].[0-9][0-9] OFF%'

OR A.[MESSAGE] LIKE '%[$][0-9][0-9][0-9].[0-9][0-9]...

Why don't you use referential integrity (foreign key) with cascade delete?

For some reason SQL Server does not accept the data as valid XML.

I get the error "XML parsing: line 3, character 75, semicolon expected"

We just need to be careful: once we're short on apostrophes, quite a few letters (including the "blank") will be in highe demand, too. (It's vs. it is not, won't...

@tina:

Don't get confused by CELKO's reply.

He's a strong advocat of ISO style programming and the usage of exactly the right terms / names when asking questions or naming a column....

ColdCoffee (9/19/2011)

LutzM (9/19/2011)

Hey folks,

just keep in mind, this is still a professional SQL Server site....

WayneS (9/19/2011)

LutzM (9/19/2011)

WayneS (9/19/2011)

Slow compared to QU, but still faster than c.u.r.s.o.r.

Maybe I ought to do some comparison tests with Hugo's set-based methods, and others that come out of this...

Hey folks,

just keep in mind, this is still a professional SQL Server site. 😎

OUCH!!! My fault!! Total simple error:

SELECT

SUM (CASE WHEN SomeDate > ='20100701' and SomeDate < '20110701' THEN YourValue ELSE 0 END) as FY2011,

SUM (CASE WHEN SomeDate > ='20110701' and SomeDate...

The order used to process the data leads to a NULL value at the last pass (after delete of the last row SELECT @db will return NULL. When you concatenate...

Most likely it's due to the usage of FLOAT and DOUBLE. There might be some rounding differences.

Do you really need FLOAT on the SQL Server side? I 'd recommend to...

The easiest solution would be a calendar table where you'd have a separate column to identify the fiscal year.

But you could also use a CASE function:

SELECT

SUM (SELECT CASE WHEN...

WayneS (9/19/2011)

Slow compared to QU, but still faster than c.u.r.s.o.r.

Maybe I...

Ninja's_RGR'us (9/17/2011)

LutzM (9/17/2011)

I don't think so...

If the post count is still...

Tom.Thomson (9/17/2011)

LutzM (9/17/2011)

I don't think so...

If the post count is still...