Mapping tables

[kritishines]

i have to popuate one table(say sales) in database with the values in another table(say temp). the mapping details of sales and temp table exist in a table called mapper.

how can i populate(insert values into) sales table's fileds with temp table's fields WITHOUT using the column names of the tables, but instead i have to use the mapper table.

mapper table( SalesFieldName, TempFieldName)

[azimmer]

i have to popuate one table(say sales) in database with the values in another table(say temp). the mapping details of sales and temp table exist in a table called mapper.

how can i populate(insert values into) sales table's fileds with temp table's fields WITHOUT using the column names of the tables, but instead i have to use the mapper table.

mapper table( SalesFieldName, TempFieldName)

Compile the proper INSERT statement into a string then EXEC the string.

[KritiGuleria]

Compile the proper INSERT statement into a string then EXEC the string.

but my problem is i cannot write in the COLUMN NAMES, neither in insert part nor in values part.
i have to select colum names dynamically from mapping table.

[azimmer]

but my problem is i cannot write in the COLUMN NAMES, neither in insert part nor in values part.
i have to select colum names dynamically from mapping table.

Easy, easy. When I said you should compile the statement into a variable I meant something like this (not actually tried (I cannot now) but should illustrate the point):

declare @columns as varchar(255)
declare @sqlstatement as varchar(1024)
 
select @columns = columnnamecol+',' from mappingtable
set @columns=left(@columns,length(@columns)-2)   ' remove trailing comma
 
set @sqlstatement = 'INSERT INTO datatable (' + @columns
set @sqlstatement = @sqlstatement + ') VALUES (1,2)'
 
exec (@sqlstatement)
 

[KritiGuleria]

Easy, easy. When I said you should compile the statement into a variable I meant something like this (not actually tried (I cannot now) but should illustrate the point):

declare @columns as varchar(255)
declare @sqlstatement as varchar(1024)
 
select @columns = columnnamecol+',' from mappingtable
set @columns=left(@columns,length(@columns)-2)   ' remove trailing comma
 
set @sqlstatement = 'INSERT INTO datatable (' + @columns
set @sqlstatement = @sqlstatement + ') VALUES (1,2)'
 
exec (@sqlstatement)
 

hey thanks a lot.
it worked