MODIFYING TABLE PROBLEM

[aas1611]

Hi,
I don't know if this forum is the right one, however, I wonder if someone could help me. I need to modify a table,

for example, from: Name Number
----- ------
AAA 123
AAA 456
AAA 789

into: Name Number
---- ------
AAA 123
456
789

got the idea?

Is there a way to do that in stored procedures? any SQL language?

Thanks Much!!!

 

[geopat]

It is kind of strange that you want a field as "Blank". However, you may try:

Update T Set Name = ''
From TableName T
Join
(Select Name, minNumber = Min(Number) from TableName Group By Name) as T1
on T.Name = T1.Name
Where T.Number > T1.minNumber

 

[tlbroadbent]

I recommend that you consider the impact of spacing out the data in a table. You will lose all data integrity and selectivity. I suspect, though I may be wrong, that you have a reporting requirement and want to display the data in a certain format with blanks for duplicate fields. MS Access provides an excellent report generation capability which can do just what that without destroying the data. Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com