Ah, redeemed!  Thanks Remi.

I always appreciate your answers.

Ok David, so is the .0  sort of a shortcut to force the float calculation?

Actually,

only Jesper got it right

either   select 426.0/852

  or

Select 426/852.0

with or without parens will return .50

select (426.0/852) /100.0  returns .0050

Thanks all, this tip will help simplify some of my...

Remi,

select (426/852)/100.0

Returns .000000

What did I do wrong?

Ok Ok.

Gomen-A-Sai  mattemasu

(I'm Sorry)

So it's been 34 years since I was in Japan! 

Gomen Asai matemas! (Most humbly sorry! Nipponese)

Of course this would assume that you would only want to see records where Value A was in both tables.  If You wish to see all of the records from...

Maybe this is more complicated than I see at first blush but could it be as simple as a union?

SELECT     Category, BrokersCost, OurPrice, Brokerscost - Ourprice AS [Total Savings]

FROM         TableName

UNION

SELECT    ...

Also, make sure the spreadsheet is not open and that it is located on a "Shared" source that can be seen by SQL.

I import into SQL from Sales_Force and use the Attached Link Server just fine.  Just a qwirk, but try renaming the Sheet name with a single character.  SF has mixed...

Calli,

Have you tried OpenRowset?

select *

from openrowset('SQLOLEDB','SERVER=ServerName;database=DatabaseName;UID=***;PWD=***', 'select * from TableName')

Give this a try:

declare @list varchar(8000)

set @List = ''

select @List = @List + egChar + ' 'cast(egInt as char(2)) + ', ' FROM egTable

Print @list

I...

Try this subquery in the Select statement:

(select Count(*) from theScoresTable where Agent_Name = dbo.QUALITY_TEST.agent_name and QUALITY_SCORE > 82.5) AS [Total Passes]

Exactly.  The SP I presented the beginning of then takes the data in your example and pivots it using a cursor( I only know how to do a pivot table...

This is one of two stored procedures I am trying to develop to display a call distribution.  I was hoping to do it this way to stay awau from more complex...