I Want to copy and data in same Table and Update date Column values? any please help?
closed as not a real question by Mat, Paul White, ypercube, Mark Storey-Smith, dezso May 8 '13 at 9:20
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. If this question can be reworded to fit the rules in the help center, please edit the question.
It's difficult to understand your question. Do you mean that you want to copy the data in a table into new rows, but update DATE values?
For example, is the following what you're trying to do?
And you want to produce:
In that case, you can just run a regular insert, using the source data as the source for the insert. Copying all other values directly save for DATEFIELD where you just manually use whatever value you want.
To create the scenario above in the code segments, you can for instance use this script (you have to come up with the filters for which range of data you want, since we don't know):
But as Raj said, you need to open up your question more. At this point it's not even logically clear what you're even asking for, let alone the technical specs for what you want.