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 |
|
jgeorge
Starting Member
6 Posts |
 Posted - 2015-04-09 : 17:18:36
|
| I am getting 228 rows once I manually inserted the value for the ct.code in test region. I would like to insert into other regions using the SQL, how can I do that ?select distinct ocmi.name, ct.code, ctv.value from cv3ordercatalogmasteritem ocmi join CV3CatalogClassTypeValue ctv on ctv.CatalogMasterGUID = ocmi.guid join CV3ClassType ct on ct.guid = ctv.ClassTypeGUID where ct.code like 'Antimicrobial Stewardship' and ctv.active = 1 and ct.active = 1 order by ocmi.name |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-04-09 : 18:13:56
|
| I'm not clear on what you want. Do you want to just use your SELECT query as the basis for the INSERT? If so, then just put INSERT above the SELECT.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Insert Query