Viewing 15 posts - 13,666 through 13,680 (of 15,381 total)
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.
October 19, 2011 at 8:13 am
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...
October 19, 2011 at 7:32 am
Oh look at the pants, time to go home.
October 18, 2011 at 4:03 pm
Ninja's_RGR'us (10/18/2011)
@steve-2, looks like we figured out how to get your 300 hits in your pants daily, just as you requested from us 😀
Now that is some pantastic news!!!
October 18, 2011 at 4:00 pm
Elliott Whitlow (10/18/2011)
Sean Lange (10/18/2011)
You can take a look at that and see if it helps. Otherwise You are probably going...
October 18, 2011 at 2:59 pm
nicetohaveyou (10/18/2011)
id name address email
1 ...
October 18, 2011 at 2:44 pm
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....
October 18, 2011 at 2:40 pm
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...
October 18, 2011 at 2:28 pm
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...
October 18, 2011 at 2:17 pm
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...
October 18, 2011 at 2:15 pm
Does this butt make my pants look big??
October 18, 2011 at 2:06 pm
I will not eat them on a train. I will not eat them on a plane. I do not like green eggs and pants.
October 18, 2011 at 2:05 pm
The pants??? You can't handle the pants!!!
October 18, 2011 at 1:56 pm
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...
October 18, 2011 at 10:58 am
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.
October 18, 2011 at 10:04 am
Viewing 15 posts - 13,666 through 13,680 (of 15,381 total)