copy from table A to table B

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008R2

Dear expert,

1. Want to copy from TABLE A TO TABLE B in a stored procedure in MS SQL SERVER 2008.

table B is a replica of table A.

2. Need to append the period the following

a. The Month
b. The Year
c. The Date

should be appended to the copied table to Table B.

How do you accomplish the above .

Thanks

Posted 31-Jul-15 18:39pm

Member 10744248

Updated 31-Jul-15 18:40pm

v2

Add a Solution

Comments

Wendelius 1-Aug-15 1:52am

Do you mean that you have already copied the data to table B and you want to add the date information to existing records?

sasanka sekhar panda 1-Aug-15 3:33am

More information required ...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2015-07-31T19:17:00

Solution 1

Try:

SQL

INSERT INTO TableB SELECT *, GETDATE() FROM TableA

A very simple google would have found you this: http://www.w3schools.com/sql/sql_insert_into_select.asp[^]

Posted 31-Jul-15 19:17pm

OriginalGriff

Comments

Member 10744248 1-Aug-15 1:38am

The critical point is how to attach the additional information
1. Month 2. year 3. Date(). which are constants for each record

Please assist

Thanks