Unfortunately just re-posting the same "table" is not much help. We need to able to run queries against this stuff to help. It seems you did not read the article that was previously suggested.

I think your ddl and dml might look like this:

create table #Rates

(

Country varchar(3),

FromDate datetime,

ToDate datetime,

CostPerSec numeric(5,2)

)

create table #Records

(

Country varchar(3),

Date datetime,

Duration int

)

insert #Rates

select 'USA', '2012-10-10 00:00:00.000', '2012-10-14 23:59:59.000', 0.01 union all

select 'USA', '2012-10-15 00:00:00.000', NULL, 0.02 union all

select 'UK', '2012-10-13 00:00:00.000', NULL, 0.02

insert #Records

select 'USA', '2012-10-14 10:00:00.000', 10 union all

select 'USA', '2012-10-15 20:00:00.000', 10 union all

select 'UK', '2012-10-13 20:00:00.000', 10

select * from #Rates

select * from #Records

drop table #Rates

drop table #Records

The bigger challenge is that it is totally unclear what you want for desired output.

What does that mean? Is the total cost supposed to be the sum of all CostPerSec values that are valid during any of the Date values in #Records?

You do seem to have some major issues in your tables. You have nothing that can be a primary key and your naming convention is a bit too vague. A table called Records or Rates is unclear. Hopefully your real table names have better names. Also, you should avoid reserved words as object names. Date is not a good name for a column. Not only is it a reserved word it gives no indication what it is.

If you can answer the question behind the logic this should be pretty simple.