|
|
Posted by Hugo Kornelis on 10/24/28 11:59
On 28 Sep 2006 00:27:13 -0700, sanju wrote:
>Hi all, I am sanju,
>To generate report I am using table named as "tempTest" for displaying
>count of dealer.
>On back end i am using oracle.
>I am unable to insert the second qry
>The datatype of the table is as follows
(snip)
>----- NOT WORKING
Hi Sanju,
Normally, I'd ask what "not working" means - runs but incorrect results,
doesn't run but yields error message, runs forever without returning,
causes black smoke to come from the server - what?
In this case, though, I see at least one problem:
>UPDATE tempTest SET MIGRATED= Dealer_name ,count(Dealer_name) FROM
You have one column name on the left of SET, but two expressions on the
right. You either need
SET Column = expression
or
SET Column = expression, Other_Column = other_expression
I can't tell if this is the only problem in your code, since I have no
idea how your tables look like, what data is in your tables and what
results you need. So if you need further assistance, I suggest that you
post the following:
- Table structures, posted as CREATE TABLE statements. You may omit
columns that are irrelevant for the question, but please do include all
constraints, properties, and indexes.
- Some rows of sample data, posted as INSERT statements. You don't have
to post thousands of rows - just a few wel-chosen rows to illustrate the
problem suffices. You don't have to post real data either (as you might
be in a business where yoou're not allowed to disclose real data), but
make it realistic.
- Expected results. If you post in the form of a table, please switch to
a fixed-width font before formatting the table and use spaces rather
than tabs to format your data - this is the only way to be sure that
your data looks as good on my screen as it does on yours.
Check out www.aspfaq.com/5006 for more info
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|