caseyo (7/15/2010)

---

@LutzM Thank you so much. I think this will get me where i need to go.

This was exactly what I was needing. I modified...

Based on your sample data I would use the following concept.

Unfortunately, I was unable to run your original query since there are tables and functions missing. So I had to...

@ Joe Celko:

You've demonstrated to design the view for YTD_Averages.

What is your recommendation to get MTD, QTD and ALL_avg?

As far as I can see, one option would be to UNION...

Steve Jones - Editor (7/15/2010)

---

Jeff Moden (7/15/2010)

---

...

And, no... I'm not trying to be a smart guy here or challenge anyone's answer... I've never run into such a problem and I'd...

Ok, here's what I came up with:

DECLARE @overall_avgs TABLE

(

[system_id] [TINYINT] NULL,

[id] [TINYINT] NULL,

...

Tom.Thomson (7/15/2010)

---

Paul White NZ (7/14/2010)

---

I'd put it a bit stronger than that: there are cases where using a sequence table is appropriate and a column with the IDENTITY property is...

Jeff Moden (7/14/2010)

---

What "philosophy" are...

Did you make your customer aware of the consequence?

I'm not sure if that's what's intended. I'd recommend asking for clarification.

You're welcome 😀

@chad-2:

Since the posted table GPK has no unique constraint for gpk column you might end up with duplicates causing your code to fail.

Either a unique constraint is required for the...

I can't confirm what you describe:

Example:

DECLARE @tbl TABLE

(

field4 CHAR(20)

)

INSERT INTO @tbl

SELECT '1' UNION ALL

SELECT '700' UNION ALL

SELECT '23,000.00' UNION ALL

SELECT '600,000.00' UNION ALL

SELECT '2,101.50'

SELECT *,CAST(REPLACE(field4,',','')...

Did you consider BOL (BooksOnLine, the SQL Server help system), section "sp_addrolemember" as a resource?

The problem is the comma.

You would need to remove the comma in order to be able to convert the value to a decimal format.

SELECT

PLANT AS plant,

ITEM_NUMBER AS item_number,

ITEM_DESCRIPTION AS...

Hi caseyo,

please provide the table definition (CREATE TABLE ...) for the table in question (overall_avgs and tblResults). One way to do it is by Right-clicking at the table in Management...

OUCH!!!!

I immediately blacklist vendors with such a philosophy as soon as I'm getting aware of it...