write a procedures along with cursors to dump data from one table to another table
-
-
thank you in advance
-
thank you in advance
That is not a question, it is an assignment; one that is lacking enough data to complete it. If you need to dump data from table1 into table2, I'd recommend a single "select" statement. No need for cursors there. If you are wondering how to build a cursor, I'd recommend the examples on MSDN. You're welcome.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
-
thank you in advance
TSQL - Cursor[^] TSQL - Select statement[^] TSQL - Insert[^] This is some links to the msdn documentation on various method that you will need to employ to complete your task as you have stated. BUT as others have stated I would also look into the SELECT INTO commands TSQL - Select Into[^] if you need more help after this please post your sql statements that you have you and describe the problem that you are facing. Sadly no one will be willing to just hand you the code without any effort.
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
-
thank you in advance
Your request is rude. Consider yourself lucky you got some pointers.
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
