All categories - 21 June 2007

Pretty much all this place is gonna be all summer?

2007-06-21 04:07:04 · 15 answers · asked by Anonymous in Polls & Surveys

2007-06-21 04:07:02 · 2 answers · asked by Anonymous in Investing

I have a table in my database that has two columns. The first column has some names of individuals and the second column has some group names. I have another table with over 500,000 records. What I want to do is to do a lookup of sorts on the two column table and wherever the individual name comes up in the large table, to return the group name. I am able to change the name with this query:

UPDATE CommonNames
SET Customer = 'Group A'
WHERE Customer = 'Bill Smith.'
OR Customer = 'John Smith'
OR Customer = 'Aaron Smith'

But then I will have to constantly update my query when the two column table changes (frequently). Is there a query I could use that does a lookup on the two column table and based on what's there changes the large table? Your help is greatly appreciated.

Chris

2007-06-21 04:06:58 · 3 answers · asked by Mr Chris 4 in Programming & Design

We had to replace our central air this summer and we put in a nice trane - 12 seer and quiet. I also got the uv light and clean effects air system. We are planning to move in about 2 years.

2007-06-21 04:06:56 · 4 answers · asked by goblue_1967 2 in Maintenance & Repairs

I repeatedly see claims that "that part isn't valid anymore" or "you have to twist it around 18 different ways to get the true context".

While these claims additionally violate the concept of Sola Scripture (which is officially the teaching of many Protestant denominations); what is the use of such a book if these claims are true?

2007-06-21 04:06:53 · 22 answers · asked by Anonymous in Religion & Spirituality

How did they first make pink lemonade?
When did it first appear? And where did they get the pink lemons?

2007-06-21 04:06:34 · 3 answers · asked by Cookie Girl 3 in Other - Food & Drink

if for some reason you didn't have internet access at home or work (for at least a week), what lengths would you go to to make sure you didn't miss anything on YA? What would you do?

2007-06-21 04:06:30 · 25 answers · asked by ♥ justbnme ♥ 6 in Polls & Surveys

2007-06-21 04:06:29 · 39 answers · asked by ? 4 in Philosophy

i joined the delayed entry progam for the marines and when they give me my physical i was wondering if they won't let me in becasue i might have scoliosis. but it is not that bad.

2007-06-21 04:06:18 · 7 answers · asked by patsfan206 1 in Military

hi there, as many of you know we are hoping to emigrate to queensland in Australia within the next 12 months. My son is 17 and once we get to Australia will aim to go to college for a year to study. he wants to know if he will be able to join and train in the Australian police? Or do you have to be Australian of origin to do this?

2007-06-21 04:06:11 · 5 answers · asked by laplandfan 7 in Other - Australia

I haven't but just wondering if you have.

2007-06-21 04:06:03 · 8 answers · asked by Stella S 5 in Etiquette

Remember he has not been proven guilty for steriords which the main purpose for taking is to help you heal faster. Also there is no proof that pitchers were not doin the same, and many people have been found guilty of it, Mcgwire, Palmeiro, Grimsley, Mota, Giambi etc.... so don't be to quick to judge one of the greatest hitters ever

2007-06-21 04:06:02 · 22 answers · asked by coolio1133 1 in Baseball

Mercep Bencsch is a man who encounters the party at outllandish moments each with different roles. In the end he's both a music player and a shopkeeper in Plotnik. Before the party's departure he was actually living in Accretion City, and his real name was Bradley Gregg. He was a famous man; however he fell at a prize ceremony, received brain damaged, and began to think he was Mike Jitlov. He was later locked in a nanoreactor and placed in suspended animation bofore Plotnik fell and woke up 300,000 years later in the present day Christian era, still thinking he was Mike Jitlov.

2007-06-21 04:05:50 · 5 answers · asked by Sniper of Goth 4 in Languages

my fishes water is looking a little dirty and i wanted to change it but i wanted to do it without killing them so help would be nice

2007-06-21 04:05:42 · 6 answers · asked by Anonymous in Fish

For all you sports fans...
Yahoo.com is buying Rivals.com:
This is Yahoo's new CEO: Mr. Jerry Changs first Move as company leader.
What are your thoughts...
Your feelings about this merger?
Respondents...please leave your sarcasms
At the door...and move on
To a no brainer question.
If ya don't give a hoot>>>scoot...

2007-06-21 04:05:36 · 7 answers · asked by Brains & Beauty 6 in Baseball

don't you feel bad for or even think twice about the starving children everytime you take a bite???????? This just upsets me sooo much!! You should only eat to survive! It should not be a hobby or something that is taken for granted!! The poor starving children need food and we should all want to help!!!

2007-06-21 04:05:33 · 9 answers · asked by Anonymous in Diet & Fitness

Firstly my highest bid is still there even though Ive tryed to retract it what do I do also , I want to buy tickets online from pay pal on my debit card as its an AMAZING offer but its slighty over what I have will it allow me to go over on my debit on pay pal or will it stil act as a normal debit card????????

2007-06-21 04:05:31 · 2 answers · asked by ☺♥ harribboprincess ♥☺ 2 in Other - Business & Finance

2007-06-21 04:05:19 · 31 answers · asked by Deana 3 in Polls & Surveys

i think that the brewers will make it to the playoffs and the yankees will have to strugle to maked to the playoffs...

2007-06-21 04:05:02 · 11 answers · asked by marcos f 1 in Baseball

2007-06-21 04:04:58 · 5 answers · asked by Ronatnyu 7 in Polls & Surveys

http://www.debka.com/headline.php?hid=4334

This link says that we have 3rd aircraft carrier headed to the Persian Gulf and a 4th one off the coast of Saudi Arabia...the largest force the U.S. has ever deployed against Iran.

2007-06-21 04:04:48 · 20 answers · asked by Brand X 6 in Military

What is the equivalent of the beef tenderloin muscles in the human body?

2007-06-21 04:04:44 · 6 answers · asked by xkayce 3 in Biology

2007-06-21 04:04:40 · 25 answers · asked by Anonymous in Other - Music

What,

2007-06-21 04:04:31 · 33 answers · asked by **ZARA** 7 in Polls & Surveys

I would have to disagree, as during sexual intercourse with my wife I routinely think about our next door neighbour Brenda and her border collie.

2007-06-21 04:04:21 · 6 answers · asked by Anonymous in R&B & Soul

We are going to pride in Seattle this weekend and want to take my partner's little brothers, they are 7 year old twins. They recognize our relationship and dont really think about it much because she is their sister and they just accept whatever she says. Pride is always somewhat family oriented, and people bring kids all the time. The parade is televised so they are very strict in enforcing clothing and conduct rules.
What pro's and con's do you see to taking children to a pride celebration? I feel like at this point they may ask some questions for sure, but i'd rather them be curious now than not be exposed to it and turn out to be homophobic and vile 10 years down the road....

2007-06-21 04:04:20 · 12 answers · asked by marcyp06 2 in Lesbian, Gay, Bisexual, and Transgender

suggest me any good products regarding it or any home remedy would be even helpful ...in my family every one has it...can a regular appliaction of rosewater will reduce it..or getting up early morning will help...

2007-06-21 04:04:08 · 5 answers · asked by Anushka 1 in Other - Skin & Body

like a runaway train...plunging ahead with no direction? Or, do you take charge and focus on what you want, letting nothing distract you? Or, is it a little of both sometimes? Thank you for answering and have a great day. :-)

2007-06-21 04:03:59 · 11 answers · asked by Anonymous in Philosophy

The church has wronged in the past.

Child molestation cases, the Spanish Inquisition to name the worst to.

But why is it many liberals(I can't believe I used that word since I consider myself one) and evangelicals bash the Catholic Church?

The Catholic Church is against the death penalty and abortion, all life is sacred.

The Catholic Church believes the acts of homosexuality a sin, not the people, unlike some Christian denominations.

So why is it, particularly on here, the Catholic Church's failings are popular and its good points are overlooked.

2007-06-21 04:03:44 · 15 answers · asked by eorpach_agus_eireannach 5 in Religion & Spirituality