Thanks for the tips.

I think you are right, in that my second post is closer to the actual data.

If we have a range called Tundra and it comes in three different weights and...

Sorry, but ProductName is usually some made up rubbish they give to each product, like Sierra,...

I thought I should perhaps add the most obvious alternative that I could think of, but which I'm somewhat unsure of:

RANGE

RangeID (pk)

RangeName

IsRangeOnePrice = a flag to help application logic know...

Hi all and thanks for all the replies.

Just to clarify: a simple restore of a backup is not the solution.

It might be that the new schema has been live for...

Dave Ballantyne (1/20/2010)

---

Richard McSharry (1/19/2010)

THE PROBLEM

This is an NHS problem related to patient treatments costs for GP's. I need to calculate, for each month of the year, for each General...

I realised that it's not the order that the data is stored in the table that is important - that is only releveant when you are doing a standalone TOP...

Thanks for the feedback matt6288. 🙂

That was my suscipion, but I thought that the order was...

Hi,

I just realised how stupid my question was. I was confused by the fact that the client has setup different datasources pointing at DEV and PROD, whereas they just need...

How many more people are going to tell me off for not posting code?

I've apologised aweady.

...and I'v promised to post code in the future, and I will too.

So can I...

jcrawf02 (7/24/2009)

---

General observation:

Keep in mind Richard that since you have figured out how to make it work, and you see all of the moving parts along the way; you may...

Matt Miller (7/23/2009)

---

Here comes one of those "awful" questions you didn't want to get.... Are you SURE a value is being passed through for the parameter (when you're firing...

Thanks you for your input re. the schemas, I was aware of the need to use fully qualified names, but not sure exactly of the reason why.

Sorry if you think...

Sorry, but I did point out what I had found and what I thought the problem was:

"While trying to debug what was happening I tried different security settings for the...

"Really, you ask a question expecting an answer and don't even bother to show us anyhting?? " :w00t:

Sorry, but I believe the actual code is irrelevent to the problem., which...