Re: Update help

Hmmmm ... you start with 4 rows ... and end up with 2 rows ... ??

I see where/how you're getting the final 2 rows however, to go from 4 rows to 2 rows will require at least 2 records to be DELETEd (ie, not doable with an UPDATE statement).

Sooooo ... are you *ALSO* looking to delete records?

Or did you leave a couple records out of the final result set? (and if so, please post all 4 'after update' records.)

maggi423 wrote:
Hi Parsons

will this exampl;e help

Initial data b4 update

appldate number1 number2 f1
f2........
may 01 2006 10 1 100 200
may 01 2006 10 2 300 400
may 01 2006 20 1 500 600
may 01 2006 20 2 700 800

After Update

appldate number1 number2 f1
f2........
may 01 2006 10 1 600 800
may 01 2006 10 2 1000 1200




Mark A. Parsons wrote:

I'm with Carl ... I don't understand what exactly you're asking for.

How about posting the following:

1 - the names (and datatypes) of all columns involved in the update ...
from the 'set' clause as well as the 'where' clause

2 - provide 2 sets of sample data ... a 'before' image of the data and an
'after' image of what you want the data to look like after the update has
been applied.

-------------

Alternatively, post back in 2 weeks after I've taken my "Mind Reading 101"
class.

maggi423 wrote:


Hi All,

I have a table which has around 220 columns with the first 3 fields
(date, number, number2) as unique non clustered index and in this table
say number has values (10,20), is there any way to update all 20's to
10 which have the same appldate an number2 values summing up all the
columns with out using all the column names using syabse.Please let me
know

Thanks
Mahesh



.

Relevant Pages

  • Re: Update help
    ... Mark A. Parsons wrote: ... How about posting the following: ... from the 'set' clause as well as the 'where' clause ... 10 which have the same appldate an number2 values summing up all the ...
    (comp.databases.sybase)
  • Re: Update help
    ... I'm with Carl ... ... How about posting the following: ... from the 'set' clause as well as the 'where' clause ... 10 which have the same appldate an number2 values summing up all the ...
    (comp.databases.sybase)
  • Re: any thoughts please?!
    ... please to help if you see me posting again and agian dont get bored ... as a first task i want to "Produce total sales per Product ... ORDE PR ... may be necessary to add an ORDER BY clause after the GROUP BY clause: ...
    (comp.databases.oracle.server)
  • where clause
    ... After posting to the newsgroup I thought I should post to the dbi-users mailing list instead. ... I am unable to get a where clause to work against MS SQL Server. ... SELECT TOP 201 AuUnique, AuRIN, AuCaseID, AuFirstName, AuLastName, AuMiddleInitial, AuSSN FROM Authorize WHERE (AuFirstName LIKE ...
    (perl.dbi.users)
  • Re: Troubles with "OR"
    ... The parentheses are not correct in the WHERE clause. ... For posting, it is ... better to copy and paste (and add new lines for clarity) to avoid typing ...
    (microsoft.public.access.queries)