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.)