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 |
|
IanasI
Starting Member
2 Posts |
 Posted - 2014-07-16 : 11:39:56
|
Hello sure this is easy, i have a list of names and using select and joins i matched most to a UID. I have a table to insert the values into and i am sure a union would work for me here. The table has five other columns and the information for each uid in the other columns will be the same. would a loop be a smaller query to write but less efficient. im just starting out, less than 6 months DB experience. id like to know what others views are on how to best do this.  |
|
|
IanasI
Starting Member
2 Posts |
Posted - 2014-07-16 : 12:23:07
|
| Ok,i think if i select values into a te,p table, then insert temp table into the dbo with the values i need will work. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-16 : 12:23:34
|
| http://www.sqlservercentral.com/articles/Best+Practices/61537/Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Insert Multiple values into one column