hi thank you very much for your inputs. Ireally appreciate your response.

Finaly i get rid of this mess by using PIVOT table in slq server as below.

select ServerName,

SYBASE,...

Hi SSC,

I have found one link. They are telling, by tabbed reports in ssrs we can achive our requirement.

Please give me suggestions.

Here is the link

http://bistuffwithdigven.wordpress.com/2013/01/20/tabbed-ssrs-reports/

Hi SSC,

Thanks for you Prompt reply.

Is it something you referring to Linked Report in SSRS???

Thank you folks..I appreicate your help.

That query absolutely worked for me.

Hi Lowell,

Thanks for your pormpt reply. But i do have 1000 records to macth in both tables. So, we have to put all the thousand values in the way you...

Hi Evil Craig,

Thank you soo much. I appreciate your promt response.

Yes, Exactly it is working from local SSMS and unable to query though clinet. But It solved my problem, all...

Thanks alot..its working

Hi Thanks for your reply...I am not getting the result with your query. I have written like below.

for the belwo proc few folks in this same forum suggesting me to...

Hi Thanks for your conern..yes it is sql server 2008R2 but i never work with merge statements.

Could you please help me.

Thanks in Advance.

Awesome..its working..

Thanks for your help

Hi the below query

Cost == "DRU" ? Values : NULL(DT_I4)

giving null values..could you please help me

yes..I need to get those values in seperate columns with respective values

What would be the logic int his scenario.

Hi,

yes we have relationship with server name. we need to compare with server name and update the tableA.

If the server name is mathcing in both table the staus column is...

Thanks alot...I appreciate your help