Hi SwePeso,

Thanks for taking the time to look at this, your solution apppears way better than mine.

I am going to add CROSS APPLY to my study list along with with...

With a great deal of inspiration from ColdCoffee the following works but I am concerned about the performance of the query with RBAR to calculate the charge for each given...

Thanks. The revised code does solve the last row issue. I'm off to get some shut eye :doze: it is now tomorrows problem!

ColdCoffee (6/28/2011)

---

Paul-202125 (6/28/2011)

---

This is already taken care in...

Hi, thanks for this. Pivot and UnPivot are an area of TSQL I have yet to fully appreciate the capabilities of and your code is much closer than I have...

The effective date range for each charge is held in the table. When I run the procedure to calculate the charges I envisage submitting start and end parameters that will...

Thanks Paul. I have got it coded into my procedures it is working very well and the performance is good.

Paul White NZ (4/9/2010)

---

You just need to add address8 and address9...

Thanks Paul and Chris for your replies. I have decided to use Paul's example with pivot and unpivot. Code using my example data below:

USE TEMPDB

IF EXISTS (SELECT * FROM...

This time with a bit more effort on my part! 🙂

The code is below and it uses 9 address lines not 7 as per my original post. The code shows...

Hi, the only key I have to link to the import without making any assumptions is the systemkey field, the name field is actually split into forename, surname, title. The...

Thanks for the reply Mark. I have had a look at and play with the OUTPUT clause, the problem is that I can't guarantee the name field is unique and...

I have always used newid() for a random selection of records something like:

select top 100 name from names

order by newid()

 

Paul.