Dear <a title="Go to ChrisM ,
       Thank you very much for your valuable suggestion.

Dear Luis Cazares ,
         Thank you...

Hi Please some one help me who have a good knowledge in XML its little emergency.

Hi ,

normally its working .

better you post some sample data or check any chacters or (comma , instead of dot . found) ..! then only we can able to...

Dear Shekhu ,

Thank you very much for your valuable time . your code is working well. it showing clustered & nonclustered index only ,...

No John ,

i dont try before , i just wanna indexcoding for given index_name which one i have created

Dear SSC-Forever ,

Thank you very much. its working well.

Dear Eirikur Eiriksson ,

Thank you verymuch for your valuable time. its working.

Dear drew.allen ,

I am going to save expression only.

Solution :

select [KPI ID]

,[KPI Name],

[KPIFormula] = case when [kpi id] = 'SA2' then '[QW1]+[SA2]+[BG7]'

when [kpi id] = 'XS3' then '[QW1]+[BG7]'

when [kpi id] = 'BG7' then 'BG7' else [kpi id]end

from...

Dear Kingston Dhasian ,

really your coding is really fantastic. (i was developed...

Dear Phil Parkin ,

first I have tried to...

Hello sir ,

thank u very much for your valuable time. i am using SQL server 2008. it will...

dear The Dixie Flatline ,

...