Search results for query: *

I need to do an INSERT where I SELECT, concatenate and INSERT all in one statement. I've researched thread183-90896, and FAQ183-1067 but neither are exactly what I need. Would someone please be able to help me with the syntax? This code works for one record at a time but uses too many...

Hi, I am writing a stored procedure to convert our client's data and move it into our database. I am using SQLSvr 2000 and Win2000. I have a table containing 3 fields: Table1 ID | Date | Code ----------------- 1 | Jan 1 | OD1 ----------------- 1 | Feb 1 | SD1 ----------------- 1 | Mar 1 |...

I am writing a stored procedure that will take in a table name and some field names and use the info from that table to update or add records to another table. I can't just use the UPDATE INTO because an ID is retrieved from yet another table. (Not my table design - came down from higher up). My...

I am trying to write a stored procedure that will get a colour description from a table (SQL Server 2000). The procedure has to be able to get info from several different tables (supplied by our clients). The only assumption is that the client table has the two fields and that both are varchar...