|
|
Posted by Roy Harvey (SQL Server MVP) on 12/29/07 11:56
On Sat, 29 Dec 2007 08:11:55 +0100, "info"
<informatyk@fitness[CUT]authority.pl> wrote:
>Hi,
>
>I have one table name: art
>
>column:
>
>symbol_art price1 price2
>----------- ------- -------
>AG-0001 20 40
>AG-0001S null null
>AG-0002 40 60
>AG-0002S null null
>...
>How paste in null price1 and price2 from oryginal symbol_art AG-0001,AG-0002 ?
>(duplicate symbol_art %-%'S ' it's always the same for oryginal symbol_art)
>
>thanks for any help
>Tom
As a side note, it should be understood that the way the symbol_art
column is being used it should have been two columns. The sort of
complications that result from not using two columns require a
complicated query. With two columns it would have been simple and
obvious.
Roy Harvey
Beacon Falls, CT
Navigation:
[Reply to this message]
|