Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Why won't my query work?
OK let me clarify a little more here. Here's essentially what I'm trying to do in MSSQL: UPDATE Table1 SET col001 = table2.Col007 FROM Tabl1 JOIN Ntable2 ON (Where the text in table1.col002 can be found in table2.col001) Hope this helps. Again thanks in advance for any help/suggestions... -
Why won't my query work?
SELECT * FROM table WHERE columname1 LIKE '%' + columname2 + '%' How do I get this type of query to work? Kevin -
-
Combining data from two columns
OK Sorry. It's on MSSQL Server. basically what I need is this: UPDATE Table1 Set Columname = Table2.Columname1 + Table2.Columname2 Hope this sheds a little more light on the subject. Kevin -
Combining data from two columns
Hi all again. I have another SQL Query question for you. I need to update a column in one table with data from two columns in another table. How would I go about this? Thanks again in advance for any help. Kevin -
Updating a clolumn in one table with data from another
Thanks all for your responses. JamesLean, I tried what you suggested and it worked beautifully. Thanks. Everyone else, thanks again and maybe I'll be able to use your solutions in the future. Thanks all again!. Kevin -
Updating a clolumn in one table with data from another
Hi all. I have an existing table (we'll call it table1)with one column with all null fields. Other columns in table1 have data in them already. I am trying to update the column of nulls with data from another table (table2) which also shares another column in common with table1. I've been...
