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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Insert Multiple values into one column

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.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-07-16 : 12:23:34
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -