Great thanks for clearing that one up for me!

Sorry Dave, I see you had already indicated that in your first post. I need more coffee...

Bear with me for a sec.

The result of Value1/Value2 is 129200.84577771904321395533

What I would like is to fit this into a Decimal(18,17)

The following works:

CAST(Value1/Value2 AS DECIMAL(18,12))

But the following gives the...

I'm working on an old stored proc; the author of which I will not be able to get hold of.

I suppose I could reduce the precision but that could potentially...

How about casting to a decimal first?

What is the range of your values?

SELECT CAST(CAST(330420968 AS DECIMAL(32,0)) AS VARCHAR(32))

Hi thanks all for your feedback and Manu for your comprehensive post.

There is currently no appplication involved, all this happening through Mangement Studio. None the less I suppose it is...

Thanks.

Out of interest sake...

The reason I've used OPENQUERY is because I got errors when trying to use INSERT INTO-EXEC approach.

Is OPENQUERY the better approach (although i doubt it) when working...

Thanks for the suggestions ... will look into TVF approach.

Thanks again.

Thanks Bob that works for me.

A bit off topic...in order to execute the storedProcs on the DB1 the linked server needs to be configured to allow remote procedure calls.

Is this...

Thanks Jack, it works for me!

Thanks ARUN, this worked for my scenario.

Thanks everyone for taking time to help me out.

I've spent a bit of time to rework my sample code and redefine my problem (@ARUN SAS - thanks for that link)

Ok here goes.

My Problem:

From the sample data below I...

Hi Wayne,

I have overly simplified my sample; in my real world sample BID is GUID (with multiple rows) and I will not be able to use it as you have...

Thanks very much for taking time to answer. Im still not able to accomplish what I intended (but then again I'm not the brightest crayon in the box 😛 )

Your...

Hi Wayne ... sorry about that i switched my keys :crazy:

Below is the more accurate sample.

In the included SELECT you will notice there are two rows for Bob. I need...