Thank you ...

I took the result set into temp table (that had name ,id) and then looped through its records(using while loop) and updated the original table. Thanks !

Changing Select to Update doesn't work.Can you please post the UPDATE Query .Thanks !

Can you please modify the query to Update .Thanks !

Thanks. But i need an update script to Update the records directly in DataBase.

The sample query that I have mentioned in my post is the similar to what I need to write.

So as per your comments, I need to use multiple If's.... But if there are more than 100 types , then having 100 if's would not be good practice ?

Based on the Type I need to query different tables to get the data.

I hope this helps!

The ccount is not obtain directly from table as done here.Am rather using the View written as below

With compTable(cid,ccid,ccount)

as

AS

(

select ...

As per my requirement , it would be something :

SELECT

CId,

CCId,

CCount,

(select totalCount = SUM([First]) OVER (PARTITION BY (SELECT NULL))

FROM (

SELECT *,

[First] = CASE WHEN 1 =...

Thank you

thanks for the reply !!!

Thanks !!!

THNKS FOR THE rEPLY 🙂

OOps , this is not what i require.