Ah yes, a much more elegant and easier to read solution!

Many thanks Dan.

Ok, I've managed to achieve what I wanted. It doesn't look very elegant, but I can't see another way...

SELECT UserKey, SUBSTRING(Postcode, 1, 2) AS PostCodeMnemonic

FROM ...

Thanks Dan, that's what I decided to do in the end. I have got another question about Named Queries and Named Calculations though:

Is it possible to use more complex logic...

Hello,

You've probably long since found the answer to your question given that your post is almost 1 year old, but it's because the ROW_NUMBER() functions is non-deterministic unless you provide...

An excellent article! It's hard to find examples such as this for Data Mining; I guess not that many people are into it.

Regards

Lempster

The difference between a well-tuned query and a poor one is enormous, both in the elapsed time and the CPU usage. It is common to find Improvements of a...

Got it...I needed to include the TimeKey range in the join clause in the @Working table variable as well as the @RemoveDups table variable like so:

INSERT INTO @Working (ExtranetLinkKey, DateKey,...

GSquared (11/11/2009)

---

I think the way I'd do it would be to join rows based on UserKey, ProductKey and DateKey, with equality tests on those columns, and a join based on...

Thanks GSquared,

Nice to know I was in the right area. 😉

I must admit I am not very good at using some of the (now not so) new T-SQL functions, so...

Hi Uli

From BOL:

The cursor is implicitly deallocated when the batch, stored procedure, or trigger terminates, unless the cursor was passed back in an OUTPUT parameter. If it is passed back...

Phew!! That's a rather large topic and impossible to cover in a forum post. I suggest you get...

Presumably your Fact table is linked to several dimension tables? You will need to change your ETL process to populate the Fact table with data from the new dimension, or...

This sounds like a homework question!

What do you mean by "add a dimension with 5 rows"? Do you mean 5 columns? You will need create a relationship between your Fact...

True, but it is possible to...

Thanks for your reply Ben. I am using 2005 SP2 CU? (build number is 3077). I've downloaded Report Builder 2.0 and launched it, but it can't connect to the specified...