Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cmcmc
Starting Member
2 Posts |
 Posted - 2011-12-02 : 02:15:07
|
| I have a table format like this:X A1x B1x C1x D1xX A2x B2x C2x D2xY A1y B1y C1y D1yY A2y B2y C2y D2yi want to insert the value in a new table from the above table.new table format like this:X A1x A2x B1x B2x C1x C2x D1x D2xY A1y A2y B1y B2y C1y C2y D1y D2ypls help me. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-12-02 : 02:20:55
|
Will you have more than 2 records for the same X or Y value ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
cmcmc
Starting Member
2 Posts |
Posted - 2011-12-02 : 02:27:54
|
| yesi have more than 2 records for the same X or Y value . |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-12-02 : 02:57:31
|
so for such case then how do you want to display it ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
SQL Quary Request