Re: Update help

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
    ... How about posting the following: ... from the 'set' clause as well as the 'where' clause ... post back in 2 weeks after I've taken my "Mind Reading 101" ... 10 which have the same appldate an number2 values summing up all the ...
    (comp.databases.sybase)
  • 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: 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)