To me, its not the least bit intimidating. In fact, its reassuring. For there to be so much collective knowledge, and for it to be so accessible and easy...

You have the parameters in the wrong order, I believe.

Can't you just do a group by clause and use avg for this?

select ClientId, ProductName, Avg(Size), dateadd(month, datediff(month, 0, MeasuredDate),0)

from WHATEVERYOURTABLEISCALLED

where WHATEVER YOUR RESTRICTIONS ARE

group by ClientId, ProductName, dateadd(month, datediff(month,...

Is that display intented to match the sample data you provided?

Because the sample you showed for client 101, product tkczfbag , month june, you said you want it...

So you have a customer table with 11 account fields on it?

lol, if I was a genius I'd probably have gotten it right the first time.

Bleh, I'm making a mess of this. Now I see why they ask people on here to post compileable versions of their tables with test data.

Also had a brain...

Think I just forgot to put "END" after ELSE 0 in both case statements.

phil.cooper.2 (7/12/2010)

---

thing is, he's not a developer. He's just a guy that picked up some SQL in school and was able to use it to fit a requirement.

I am not...

My bad. I assumed from your sample data that they would have all matching rows.

You can use a full outer join instead of an inner join to...

It looks like you may be misunderstanding what a union does. It will give you all the rows from both queries, not merge them together.

What you actually...

Mike Cunningham (7/9/2010)

---

good morning.... assumptions... well, I still find the biggest has to be that the users in work (and out, including neighbours, friends etc) seem to think that all...

I think a DBA reacting to situations like this they encounter is fine. If you learn of critical data being stored in an unsafe way, by all means speak...

James Stover (7/2/2010)

---

I'm a believer in contract-to-hire. It gives everyone a chance to "kick the tires" and if it doesn't work out, you cut your losses. Oh sure, the contractor...

I recently started as an IT manager for a company (formerly a programmer elsewhere) without a DBA. And as Mark Magnus suggested back on page 1, there is...