Ignoring your query for the moment, what is the expected results from the query based on the sample data. In other words, what are we trying to accomplish with...

For those who haven't noticed, The BLOG button is now active on my posts. I now have a blog on SSC. 😉

GSquared (3/26/2009)

---

Lynn Pettis (3/26/2009)

---

It also makes me wonder what company he works for as well. Must not have much in the way of data or they'd probably be complaining...

Have you looked in the SQL Server Logs in the Management Folder in SSMS Obect Explorer?

Lowell has given you the principle you need to figure out what needs to be done. May I suggest you read up on GROUP BY in Books Onlie? ...

It also makes me wonder what company he works for as well. Must not have much in the way of data or they'd probably be complaining about system performance;...

Alvin Ramard (3/26/2009)

---

Derek Dongray (3/26/2009)

---

He still hasn't got it ...

http://www.sqlservercentral.com/Forums/FindPost684294.aspx

Have any of you seen the challace and viewed another way it looks like a face?

Or a cube drawn on paper,...

Changing methods a bit here, so here is some test code for you to play around with:

--DeptID X Y z

--A1 1 10 12 5

--A2 1 13 17 7

--A2 2...

Well the blizzard hasn't hit here yet in...

foxjazz (3/26/2009)

---

Bob, just because I know how to do updates (in mass) or inserts in mass to tables. Doesn't mean I favor the language of use. Don't get me wrong,...

No. SQL Server 2005 will "act like" SQL Server 2000.

Access to SQL Server 2005 features and capabilities.

Good response. I was just trying to make sure that everyone had a good idea as to what is "duplicate" data and that which isn't. In a strictly...

jparra (3/25/2009)

---

I'll jump on the bandwagon here. When designing a database, I first normalize and see where that gets us. When requirements or performance demand denormalization, there isn't...

Scott T (1/16/2009)

---

--With simple calculation we don't care about data-type (float or decimal)

--====================================

--When we start calculation like the following one, we should use decimal

-- Let's see example

--====================================

DECLARE @APR ??????? (18,3)

--------------------------------------

SET...