[RESOLVED] [2005] Duplicate Rows sqlexpress

[gooden]

do you guys know any command sql or by .net that duplicate rows only editing some values?

Glad if you could help =)

[si_the_geek]

Do you mean that you have two or more completely identical rows in your database table, and you only want to edit one of them?

If so, that isn't really possible, and is a sign of bad database design.. the best you can do is modify the table so that it has a unique key, or move the data around around a bit to eliminate duplicates. Neither of these are options to be used in your program, they are both manual changes to the database itself.

[gooden]

Do you mean that you have two or more completely identical rows in your database table, and you only want to edit one of them?

If so, that isn't really possible, and is a sign of bad database design.. the best you can do is modify the table so that it has a unique key, or move the data around around a bit to eliminate duplicates. Neither of these are options to be used in your program, they are both manual changes to the database itself.

Well the problem is that the row that i want to duplicate is called a document and is going to transform it to other tipe of documento.
SO i have for example a document like:
|Doc1|tipe1|

and i want to make a copy like:
|Doc1|tipe2|

[si_the_geek]

OK, well in that case we are going to need more info, such as:

How do you know which record you want to copy?
How do you know what 'changes' you want to make?
What code do you have already, if any?
...

[gooden]

si_the_geek thanks for the help but the thing i whant to do is more complicated. i discovered that now :S well i need to make some selects and joins and select inside select :| anyway ty for the help