Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jjasper
Starting Member
25 Posts |
 Posted - 2008-04-03 : 10:11:24
|
| I have been doing fine with select, insert, update and such statements but all of a sudden I was given a problem I am not sure how to handle:I was given 2 tables One that has a field called "labelname" (about 2 million records):labelname--------------asprin 50 tabaspirin liquidaspirin 30 tablotion 500mg...One table has a “like” field (checkme) and a quantity field (about 200 records)checkme quantity------- --------asp%30% 7lotion% 20...I need to loop through each labelname and if it matches the "checkme" field, do a calculation based on the "quantity" fieldCan this be done in a SQL query statement - is it possible ?Thank you John |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-03 : 11:21:04
|
| Duplicate post:-http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100219 |
 |
|
|
|
|
|
beginner but have a tough SQL problem