|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 10th, 2004, 12:34 PM
|
|||
|
|||
|
union query
I want to perform the task which is querying the table using the select statemtent and then inserting some values using the insert/update statement.
Can i perform the both (select and insert) using the union statement.
|
|
#2
July 11th, 2004, 01:18 AM
|
|||
|
|||
|
ummm, no, I don't believe so...if I'm understanding you correct anyway. A UNION gives you the capability to combine 2 parallel queries together to give you 1 combined rs...what you are wanting to do is out of the scope of the UNION.
If you don't mind though, answer me this... You want to run a query that gives you a result [queryA], then you want to INSERT the results from queryA into another table? If so, you can do that w/an Insert statement.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > union query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
