Thanks. I am aware of this kind of approach but I don't have option to modify code on source server.

BTW Does anybody know of real cause of this problem.

Actually the original code looks like as follows

INSERT INTO DestTable

EXEC SourceServer.database.dbo.usp_returnOneRecordSet

I don't have choice of editing code of source server.

MSDTC was configured long time back and servers are rebooted couple of time after the configuration.

Please post the work around.

Run the following DBCC commands before running your benchmark query

DBCC FREEPROCCACHE

DBCC DROPCLEANBUFFERS

These statements will bring your server to cold boot state and after that you know the worst time...

There is the similar post I just found.. may be of help.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=175193

Thanks for your response. The 'someone' is nothing but one of big finencial company SQL DBA on Sybase side. May sybase doesn't have CASE yet.

BTW. Here I have put...

If you know all the columns of your table than you should be able to write a simple query like.

SELECT  CASE @fieldName WHEN colName1 THEN colName1 

                                    WHEN colName2 THEN colName2

                                   ...

It is an old listing but I need this solution for getting Median along with other aggregates in my query single select statement based on specific group by clause.

Anybody...

It returns correct result set but there are performance issues if this is used on big table.

Any other Ideas which provide better performance with desired result.

Thanks

GOpal

CASE fov.pf_category_hj

WHEN '001' THEN col11

WHEN '002' THEN col8

WHEN '019' THEN col6

ELSE 'WTF?!' END = lap.account

Refering above part

If try and keep a mapping of your order_variable.pf_category_hj in a temp table with...

Wayne

Its been a long ago when i posted this thread. Anyway thanks for understanding the problem right. I will look into SQLDiff.

But temporarily I designed my own schema...

You are correct Aaron. I did see a special character just before the beginning of next line after commented line and this must...

I am not sure what to check but I noticed that it happens only from one box even though the SQL Server is same.

Any Guess where could be the...

To add to my previous post. My test resulted in answer of  '2'.

I guess owner of the qustion should review this questiona and site owner should response with better...

At first the data of the tables is not provided correctly. Both are mentioned from #TestUpdateA.

Secondly question is listed under the section of T-SQL which is definitly properitry of...