-
5th May 2010, 09:47 PM
#31
Senior Member
Diamond Hubber
Originally Posted by
app_engine
Checking whether the first name / last name exists in table B is no big deal (for set processing, use EXISTS clause)
OTOH, if you have 10000 NEW addresses to be updated to table A, you got to STORE those addresses in a table (unless the requirement is to directly update from a flat file, then you need a script). Obviously, this flat file or table with new address should have the name reference as otherwise how you're going to relate?
what is that?
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
5th May 2010 09:47 PM
# ADS
Circuit advertisement
-
5th May 2010, 10:05 PM
#32
Senior Member
Platinum Hubber
abbreviation for "on the other hand"
-
9th May 2010, 02:02 PM
#33
Senior Member
Senior Hubber
Originally Posted by
PARAMASHIVAN
Is any one familiar with the hardest thing in SQL code, known as Cursor?
I will explain what I need to do..
I have table A , and Table B
Table A Table B
--------- ------------
First_name First_name
Last_name Last_name
Address1 Address1
Adreess2 Address2
What I want to do, see if the firstname and last_name in Table B exist in Table A, if so then I want to update Address1 and address2 in table A with a value. This is easy to do for couple of rows.
using
Update Table A
set address1='test',
address2='test2'
where first_name in (select first_name from table B
where first_name like 'Super')
but the problem is in Table B , i have 10,000 first_name with values in the address1.. I need update table A9Address1) with a value based on table B's contact name, hence you end up with 10,,000 different names, with 10,000 different address, if it was just one addreess it would have been very easy, I can use the above script.
any ideas any one ?
Update A set address1=B.Address1,address2=B.address2
from TableA A, Table B B where A.FirstName=B.FirstName
Hope this helps
Nice to see this thread in this forum.
கிறுக்கன்
-
10th May 2010, 06:51 PM
#34
Senior Member
Diamond Hubber
Originally Posted by
kirukan
Originally Posted by
PARAMASHIVAN
Is any one familiar with the hardest thing in SQL code, known as Cursor?
I will explain what I need to do..
I have table A , and Table B
Table A Table B
--------- ------------
First_name First_name
Last_name Last_name
Address1 Address1
Adreess2 Address2
What I want to do, see if the firstname and last_name in Table B exist in Table A, if so then I want to update Address1 and address2 in table A with a value. This is easy to do for couple of rows.
using
Update Table A
set address1='test',
address2='test2'
where first_name in (select first_name from table B
where first_name like 'Super')
but the problem is in Table B , i have 10,000 first_name with values in the address1.. I need update table A9Address1) with a value based on table B's contact name, hence you end up with 10,,000 different names, with 10,000 different address, if it was just one addreess it would have been very easy, I can use the above script.
any ideas any one ?
Update A set address1=B.Address1,address2=B.address2
from TableA A, Table B B where A.FirstName=B.FirstName
Hope this helps
Nice to see this thread in this forum.
கிறுக்கன்
Thanks kirukan, I will give it a go and see
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
26th May 2010, 06:27 PM
#35
Senior Member
Diamond Hubber
Any one here good at SQL 2008 / 2005 SSRS
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
27th May 2010, 07:25 PM
#36
Senior Member
Platinum Hubber
Rita Mulcahy passed away :
http://www.theicpm.com/certification...ect-management
(Excellent author of PMP training books)
-
27th May 2010, 07:39 PM
#37
Senior Member
Devoted Hubber
Originally Posted by
sakaLAKALAKAlaa Vallavar
linux experts, how to share internet btw 2 laptops running ubuntu, thru wifi?
SKV, this is a late response but have you tried this link?
http://www.ubuntugeek.com/sharing-in...in-ubuntu.html
-
29th May 2010, 11:12 AM
#38
Senior Member
Veteran Hubber
Originally Posted by
app_engine
RIP, her book helped me a lot in earning the PMP certification. Really a big loss for Project Management Community
Damager - 30 roovaa da, 30 roovaa kuduththa 3 naaL kaNNu muzhichchu vElai senju 30 pakkam OttuvaNdaa!
-
1st June 2010, 02:41 PM
#39
Senior Member
Diamond Hubber
my hotmail account is infect, it is sending out automnatic messages to all the ppl in my contact list,
how do i stop this crap pls help
Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye
-
1st June 2010, 08:21 PM
#40
Senior Member
Platinum Hubber
Originally Posted by
PARAMASHIVAN
my hotmail account is infect, it is sending out automnatic messages to all the ppl in my contact list,
how do i stop this crap
pls help
Temporarily remove the contact list. (You can add them later once this menace dies down)
Also, immediately change your password!
Bookmarks