Would it work to have a ClientType column and a column to hold their key?

Something like:

CREATE TABLE dbo.ClientData

([Name] char(8),

[ClientType] char(10),

[IdentityValue] char(6),

That would eliminate two column of nulls on every record.

You certainly didn't waste my time. I am willing to help I just need some details about what you are trying to do. Make it easy for me (or somebody...

Oh look at the pants, time to go home.

Now that is some pantastic news!!!

Elliott Whitlow (10/18/2011)

---

Sean Lange (10/18/2011)

---

Here is a MySQL article about this very topic. http://www.scribd.com/doc/2569355/Geo-Distance-Search-with-MySQL

You can take a look at that and see if it helps. Otherwise You are probably going...

nicetohaveyou (10/18/2011)

---

say that we have a table naming "abc" with their values

id name address email

1 ...

Here is a MySQL article about this very topic. http://www.scribd.com/doc/2569355/Geo-Distance-Search-with-MySQL

You can take a look at that and see if it helps. Otherwise You are probably going to increase your google-foo....

Well it seems pretty obvious there a number of people willing to help. We have all taken a stab at what it MIGHT be you are looking for. They are...

You really should post to the forum instead of PM.

However, the excel file contains data but I don't want to have to create a table and try to figure...

pants pants pants pants...

...pants pants pants egg and pants; pants pants pants pants pants pants baked beans pants pants pants...

Have you got anything without pants?

Well, there's pants egg sausage and...

Does this butt make my pants look big??

I will not eat them on a train. I will not eat them on a plane. I do not like green eggs and pants.

The pants??? You can't handle the pants!!!

Your question is a bit vague on the details but I think you could brute force this using ROW_NUMBER. Of course if your second table has fewer rows than your...

Not sure I understand what you want for output based on your description. If you could explain the desired output we can help put together the sql.