|
|
Posted by Ed Murphy on 11/27/35 11:59
sanju wrote:
> On back end i am using oracle.
Then why are you posting to a Microsoft SQL newsgroup?
> I am unable to insert the second qry
[snip]
> UPDATE tempTest SET MIGRATED= Dealer_name ,count(Dealer_name) FROM
I agree with Hugo, this looks like the problem. At a guess, you
should change this to
UPDATE tempTest
SET MIGRATED = Dealer_name, DEALER_DATA = count(Dealer_name)
FROM (etc.)
Navigation:
[Reply to this message]
|