ChrisM@home (1/18/2012)

---

bicky1980 (1/11/2012)

---

...These are just the basic counts, I will need to then run these incoporating the where clause for various variables. If someone could advise of the best...

SQLKnowItAll (1/18/2012)

---

bicky1980 (1/18/2012)

---

SQLKnowItAll (1/17/2012)

---

I think that we can all agree that this was not a mathematical issue but a logic issue. The two not being mutually exclusive, but being related....

SQLKnowItAll (1/17/2012)

---

I think that we can all agree that this was not a mathematical issue but a logic issue. The two not being mutually exclusive, but being related. Anyway......

L' Eomot Inversé (1/17/2012)

---

GSquared (1/17/2012)

---

I think this whole thing may be getting massively overcomplicated by the math.

Is the actual business requirement simply a count of how many distinct datakeys there...

SQLKnowItAll (1/17/2012)

---

SQLKnowItAll (1/17/2012)

---

If the data could be processed in the following manner that would be great

1. Extract all the data with a landline

2. Dedupe the data on datakey - keep...

SQLKnowItAll (1/17/2012)

---

bicky1980 (1/17/2012)

---

ChrisM@home (1/17/2012)

---

bicky1980 (1/17/2012)

---

SQLKnowItAll (1/17/2012)

---

As far as I can tell, this is...

ChrisM@home (1/17/2012)

---

bicky1980 (1/17/2012)

---

SQLKnowItAll (1/17/2012)

---

As far as I can tell, this is an impossible...

SQLKnowItAll (1/17/2012)

---

As far as I can tell, this is an impossible statement without...

GSquared (1/17/2012)

---

bicky1980 (1/13/2012)

---

GSquared (1/13/2012)

---

The order of the rows in a dataset doesn't really matter to set-based SQL operations on it.

I just need a clarification on this statement, "Total number of...

How do I copy code from the forum to paste into Management studio, without having to refomat it myself everytime?

Hello Chris

I cant post the results due to data protection 🙁 , which is going to be difficult to try and get you to see my issue, this was why...

The datakey & landline doesnt exist in my final table

I edited the query at the end to put the results into a new table

SELECT *

into lvl

FROM Level1

UNION...

The Query does however, appear to exclude some records, which I cant explain.

I had 4 records with the same datakey and same landline, but these results were excluded from the...

Hi Chris

I have run the query on a sample of 100,000 records, in my results there are no duplicate telephone numbers and no duplicate datakeys, which is great! (Ran fast...

ChrisM@home (1/16/2012)

---

They're solutions to a particular type of problem, well known and defined, and I think it's fair to say that one or two folks...