Programming Forums - View Single Post - Help me to solve this problem(sqlserver & visual basic)

fosiul.alam · Aug 5th, 2005, 12:43 PM

I am using sqlserver and vb6
Problem - I made 2 tables in sql server. 1) emp and 2) tmpemp
Some data in emp table :
Id Name address
1 Fosiul Uk
2 Steve Uk
3. Martin uk

Want to make a procedure, which will copy record for ID 1 to table tmpemp.

like , if id = 1 from emp table, copy record to tmpemp table.
and want to execute it from visual basic.
like user will select Id from combo box. and that employee record will shift to tmpemp table.
this is basicaly for reporting purpose.
Can any one help me please.

Aug 5th, 2005, 12:43 PM	#1
fosiul.alam Newbie Join Date: Aug 2005 Posts: 1 Rep Power: 0	Help me to solve this problem(sqlserver & visual basic) I am using sqlserver and vb6 Problem - I made 2 tables in sql server. 1) emp and 2) tmpemp Some data in emp table : Id Name address 1 Fosiul Uk 2 Steve Uk 3. Martin uk Want to make a procedure, which will copy record for ID 1 to table tmpemp. like , if id = 1 from emp table, copy record to tmpemp table. and want to execute it from visual basic. like user will select Id from combo box. and that employee record will shift to tmpemp table. this is basicaly for reporting purpose. Can any one help me please.