Ha ha ha Lehman brothers secured everyone at my organisation in the uk a 0.1% pay rise and our funding body (governement run) advised a 0% rise for all staff.

I agree this question has too many assumtions making it impossible to get the answer right unless you use probability to decide which is the most likely set of assumptions.

I...

Hi Jacek0,

I might be being a cabbage but i have never seen :: used as a prefix to a join or anywhere else in sql actually. I had a quick...

Yeah thought so...I got it wrong because like a lot of you i chose varchar

Its variable length data so and will need trimming before it can be used if you...

I work in a large education organisation and my teams sole job is to develop BI reports across many platforms. For reporting Services we always aim to write a single...

For me i think it has to be The Turk, the moody chess playing computer from Sarah Connar Chronicles

skjoldtc (12/5/2008)

---

It is the excesses that make life interesting and enjoyable. It is also what makes life potentially shorter. I would rather enjoy an excess of something now even if...

I agree entirely, my employer sees it as unfair for only smokers to get a fag break so non smokers may have as many 'fresh air' breaks as smokers have.

I...

I would really like to stop smoking but if ind myself getting quite irritable after just 2 hours if i don't have a cigarette

Hi,

Eliminating Jobs from the query worked. It seems to be working quite well now. Do you know why the Jobs section caused it to fail? i am using sqlsvr2000.

I will...

Thanks for the quick response.

I have run it through the T-sql debugger in query analyser and it errors right at the FOR statement below when it tries to populate the...

Hi

Have you any idea why i would be getting a String or Binary data would be Truncated error? I have poured over the script for quite a while and not...