pls confirm are the the FE tables now linking to SQL or the "old" BE (.after you made the table deletions) ?

out of interest...what are your "many issues"

concurrency?

performance?

data integrity?

iirc...a properly...

I think there's a small issue with the math. Using factorial would work for permutations (i.e. the orders of the colors matter), but is not right for combinations. ...

mmiller 85218 (2/6/2012)

---

Sean Lange (2/6/2012)

---

J Livingston SQL (2/6/2012)

---

2 type of House

4 type of Colour

3 type of Size

5 type of Flavour

2*4*3*5 = 120 combinations

though how they are related beats...

2 type of House

4 type of Colour

3 type of Size

5 type of Flavour

2*4*3*5 = 120 combinations

though how they are related beats me 😀

edit typo

KFC

Jeff Moden (2/5/2012)

---

Nah. I do...

Hi.. please provide table create / insert data scripts

we have been here before 🙂

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

So...you...

Jeff Moden (2/4/2012)

---

I'd say "spot on" except that you can simplify it all quite a bit.

SELECT prod_id, SUM(quantity)

FROM dbo.TestTable

GROUP BY prod_id

HAVING COUNT(DISTINCT sale_date)...

preetpalkapoor (2/4/2012)

---

The result that i want is:

Prod id quantity

p2 11

p3 16

This...

Assuming that by Ranking Functions you mean RANK,DENSE_RANK,NTILE & ROW_NUMBER are to be excluded

http://msdn.microsoft.com/en-us/library/ms189798.aspx

here is one possible way that manages duplicates

SELECT Salary,rn = IDENTITY(INT, 1, 1)

INTO #tmp

FROM SalaryTable

GROUP BY...

Why "without rank functions"...??? (homework maybe 😉 )

_______________________________________________________________________

Not sure what you are expecting if...

...anywhere close???

prod_id SumQty

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

p2 11

p3 16

if you provide the create table / insert data scripts as I have below...and your...

if this a one time operation to...

you're welcome 🙂