as someone in Business intelligence (providing data warehousing and management reporting) there is stuff that the cloud isnt ready for, practicable or secure enough yet. He says hoping he will still have a job in five years 😉

http://pistonheads.com/sales/2658620.htm

PJM speaks sense (if you can wait a while and nearly double your price!)

http://singletrackworld.com/forum/topic/i-think-i-need-to-start-saving-now

Cheers guys i think i might see if i can return them and see if i can either budget for something ‘proper’ (high street ken snow and rock is just down the road from work)

or maybe just rent for another trip 🙁

hummmmm i no nothing of flex, looks like i might not have done as well as id hoped 🙁

I dont have the funds to do a proper fitting/ non- budget boots

In terms of type of skiing a tend to approach each hol as an opportunity to push myself and learn and concentrate on improving. I want to be able to progress to alot of reds this hol and try and start
carving

thats decathalon writing naff decriptions, they are pretty much as simple as boots go.

in terms of my level i can pretty much ski parralel on blues but not tried much steeper stuff yet (only a couple of reds)

having second thoughts about the boots ive bought:
http://www.decathlon.co.uk/mission-id_8188819.html

they are comfy but having done 2 trips should i have waited a few more trips and then got something genuinly good rather than just getting entry level boots.

what do people think? (i could still take them back)

i know of one in Bath if its really worth coming that far! (Cadence)

I would go for in-ear noise blocking rather than cancelling. no batteries to replace and they deal with variablle noises not just background humm type stuff. Ive got Shure 420’s but i think they have changed the range now. (other brands may be better if you are into Bass music)

Hummm must have got my terminology wrong somewhere then. I always saw it as very French the image i have in my head.
80s brightly colored jacket
Skiing with your legs really close together
Very stood up style
Really relaxed and non-plusses by everything
Stopping for a ciggie after each run
And carving everywhere at 1billion miles an hour

I aspire to that 🙂 😉

I’ll join in 🙂

Booked a week in tignes on the 28th Jan over Christmas. My 3rd ever trip, deffo skiing. My ambition is proper euro carve turns by the end of the week and (maybe) a first black run.
staying in the val claret appartments (du pont?) with crystal so should be easy enough.

So far this thread has made me watch chalet girl (funny in a b movie chick flick kind of way) and buy these
http://www.decathlon.co.uk/mission-id_8188819.html

Have I done ok for an intermediate skier boot? They feel comfy 🙂

Anyone got any tignes tips then?

tries not to get really angry that the first thing people say when you mention alfa is reliability……….

Fails ….

GGRRRRRRRR 🙁

Perfect

another wildcard?

the trailaddiction backcountry weeks sound perfect for you, take a look at them. i really enjoyed the two ive been on.

get a pension? tax efficient and far less hassle than managing a rental
(just go see an ifa and take their advice)

I have one (not been ridden for a while as its missing a seatpost, bloody tea leaves, why spec a QR seat on a cheapish commuter Grrrr)

other than that its done everything asked of it, its fairly fast and has required 0 maintainance.

one thing i would say is my (fairly old) one is very short in the top tube compared to other bikes i ride. I should have checked it but i bought off seat tube and probably should have gotten something longer.

If you are an experiance cyclist and looking to do real distances id look for something longer in the TT.

id have a cotic soda but they have stopped making them so i would probly get someone to custom build and exact geomety match with an ebb. Not really sure who though si im not sure im helping

there are stickies when they are warranted (eg bullheart fundraising, emergency services over christmas)

the stuff your after is found in the rules and is unwelcome on the forums (IMO)

nasher, fine choice on the alfa, get in soon the prices are heading up on those. just to let you know if you get one, make sure you join the gulietta register as they are a pretty kool club with lots of great trips!

http://www.giulietta.com/

Thread resurection, i still want 🙂

Yay, i helped 🙂

warton has the answer

SSRS text alingment you are probably after “WritingMode” in the properties window once you have seleted the textbox

Ok so from that, i think what I have written for you is doing what you want to achieve. To go through it a bit more:

You want to start with the inner select ( i have altered this from above as you are going to need the join inside this) :

SELECT
COUNT(filteredcontact,contactid) as contactsCount,
AccountId
FROM FilteredAccount INNER JOIN
FilteredContact ON FilteredAccount.accountid = FilteredContact.accountid
GROUP BY AccountId

That gives you the count of contacts by account id

You then need to wrap that up and count how many accounts have each number of contacts

SELECT
count(accountid) as accounts
,contactsCount
FROM
— Our inner select
(SELECT
COUNT(filteredcontact,contactid) as contactsCount,
AccountId
FROM INNER JOIN
FilteredContact ON FilteredAccount.accountid = FilteredContact.accountid
GROUP BY AccountId)AS InnerSelect

GROUP BY contactsCount

that is a bit cleaner and clearer hopefully. I have made some ‘improvements’ from above so dont try and compare them too much
the a. b. stuff was just me giving the tables an alias to save writing out the name all the time (ie lazyness!)

And contactsCount is the name im giving the column that holds the contacts count per account

ok so if i get this right i would use a subquery joined in so:

SELECT
count(filteredaccount.accountid) as accounts
,contactsCount
FROM
filteredaccount b
LEFT JOIN
(SELECT COUNT(filteredcontact,contactid) as contactsCount,AccountId FROM filteredcontact
GROUP BY AccountId ) a
ON
a.AccountId = B.AccountId

GROUP BY contactsCount

Allthepies I think yours just gives contacts by accountId i think he wants more than that

mrmo, how you finding SSRS, you got 2008?

Don Simon- deffo the majority of criminal guns were never legal in this country they are either (smuggled) imports or crude modifications (and lots has been done to make modification of air weapons much more difficult recently)

TeamHurtmore + 1

TJ there is no way hurtmore was being offensive, that is very unfair. He presented a coherant argument that a gun is not dangerous until there is a gun user. which is perfectly fair

TJ has it crossed your mind that i would not want to live in a country where ‘because i want to’ was not considered a legitimate answer.

The current legislation makes it a sufficent PITA to put off casual louts while still giving people freedom to live their lives as they see fit

So Olympic level sport doesnt count then TJ?

http://en.wikipedia.org/wiki/Shooting_at_the_Summer_Olympics

oh if you can wangle the training budget or fancy coming along to the saturday for free come to :
http://sqlbits.com/

anyone else going?

As per BEB happy to have an email if you need anything

no

Yeah Mogrim makes a good point, dont let them make you design and (less critically) build an enterprise critical DB as a first project.

A bit of reporting off an existing DB or a simple app db build is a more realistic first stab!

(all if unassisted)

When I worked there if you gave your postcode it could be looked up yes.

that was about 5 years ago on an awful blue screen/ F5/ F10 style system which i hope to god they have got ridden of!

have run a Ibis mojo sl for 3 years or so and made a decision right at the begining that i wasnt going to worry about the fact it is a lightweight carbon full sus.

I have therefore treated it like a bike, had a lot of fun and its still there alive and kicking 🙂 its been to alps, peaks, local stuff and all sorts in between inc DH courses and swapping between 140 and 160 forks.

If you feel you can do this get a carbon bike and forget its carbon. If you will constantly be questioning it, then forget it.

SQL is not too difficult, i picked it up from a non- IT background on a week long course and was fairly happy after that. Getting my head properly around group by took at bit longer though!

I would say after 3 years at it now i can do (or find out how to do!) pretty much anything.

dont really know of any on line courses or anything but MSDN will sort you out in most cases. Main thing i would say is to just start writing it. If you can just do a bit of basic training and then get on with it (ideally with someone who you can go to with Q’s) then you will be fine

Do you have anywhere you can install SQL Express and adventure works? that should sort you out for a bit of a learning/ sandpit environment if you cant play with a dev area.

the fisik kurve ones are actually fantastic, i had a demo on one. (however they do cost nearly £200)

the ‘novel’ constuction just doent let any vibration up into the saddle 🙂

I will always advocate choice on the issue.

When I Barclays bike through London and its parks I would hate to be forced to wear a helmet. It would probably just not ride in London. For me it is the fact it is safe (statistically ) and I want that easy continental image of cycling and the simplicity and freedom of a bike.

When I am ‘going for a ride ‘ on either MTV or road bike there is no way I will leave the house without a helmet a I choose to ride with one for those just in case occurrences. On a bike ride it is not going to ruin my hair, be a pain to carry etc so to me there is no downside at that point.

So, wear a helmet but don’t get on your high horse about it and force it on others

Commuting

Love

Engagement

Just a quick note, im sure I’ve seen that litespeed not being reviewed that well. Google it