Jeff Moden (2/5/2014)

---

Divide all totals by the number of days (Fridays, for example) contained in a given month and then multiply by 5. Think of it as a normalized...

Thanks guys, yes im currently working my way through the kimbal toolkit books ill have a look at the Star Schema The Complete Reference also.

xsevensinzx (1/27/2014)

---

ps_vbdev (1/8/2014)

---

Both good points well made. first one answers my question on scaleability but also second one explains why the ETL's ive seen before do a drop of the...

the question was written with that having already been established.

thanks

Both good points well made. first one answers my question on scaleability but also second one explains why the ETL's ive seen before do a drop of the DW first...

Thanks guys, very helpful info.

one thing im not clear on. If have seen data warehouses being dropped and recreated then populated on a nightly basis. this obviously means the ETL...

Hi thanks for the replay, is the word "difficult"missing from the...

Expected reply.

Not a smart arse, just tired off people with misplaced self-worth.

below is an answer from a forum member for the same post

"you can apply an UPDATE based on DENSE_RANK...

stated in my post "When i bulk insert the csv i was using a case statement to apply a points based on the position field".

the logic behind how the points...

yes that is an option, and the best one so far as there will be a number corrections necessary i.e. duplicate riders, name spelling. but if possible to to...

yes that's a great spot thanks, "Assing point to race times" should read "Assigning Points to race times".

Lowell (3/20/2013)

---

i cannot imagine any way to automate this;

this really requires someone to go thru the data, and familiar with a lot more than just the names/users;

you don't have any...

anyone

I DO HAVE ACCESS TO THE SERVER. I dont have access to the share point DB on it. The reason i want access to it is to set up a...

Sorry when i said access the instance i did of course mean through using the surface area configuration tool where you can enable remote connections. I have only got visibility...