Nice one. I got it right - yay! - though I had to spend 20 minutes reading up (sorry work) first, as I was determined to get it right.

I think...

I am definitely lucky to have a job I enjoy, and one that pays top end of the payscale - and when I start to not enjoy it then I...

I think there are more complex cases where you need to do the kind of thing discussed in the question - using a subquery - but I did immediately think...

Probably about 5 on 2000 and a similar number on 2005, a couple set up on 2008, although we have not got many real projects running on 2008 yet, mainly...

Some of my colleagues have preferred a widescreen - no, I do not get that. Dual anyday, but each to their own.

@EricGray

I am a general application programmer (admittedly of some experience) and I certainly believe I have the skills to write SQL. Even unsupervised, and without a lot of training. I...

A very nice question - this is why I continue to do the QOTD. I had honestly never heard of INTERSECT or EXCEPT until today - unbelievable! The precedence totally...

I'm with IceDread, I don't see this. Our Client Services Manager who is the interface between project team and client will find out what went wrong. In general we do...

Virender Sihag (10/3/2011)

I have create a view in a database (assume a_db)

now this view fetching records from other database(assume b_db) like (select col1,col2 from b_db..tab1)

Now i have create a...

Interesting point. My actual line manager actually rarely gives me any direct instruction. I would say our team has no hierarchy of 'command' as such and really does not need...

I think it is fairly well established (Spolsky etc) that you are either the type of person that gets programming or not. In general I believe I could look at...

I thought this was ansi padding too, so got a wrong answer slightly unfairly 🙁 as I thought as only one would be possible I did not need to consider...

I think because early in life I read 'Great Answers to Tough Interview Questions' by Martin John Yate - highly recommended - very little people could ask at interview would...

I have 45 minutes by cycle (3 times a week on average), or 30 minutes by car each way (12 miles). I'll be honest, I would not like any longer,...

@tom.Thomson

Thanks for your first post - this was very helpful to clarify my thinking.