Already thought of that one Brandie - however I would...

If only I could Gail - I would take Mr Shinai to them. Sadly they left before I started here.

Thanks for all the replies. Glad to see that there is ageement

They say the devil is in the detail, now here is the situation with all the information. I have...

Deleted - re-read the question and I was wrong

Nice and easy today - thanks

Knew the answer to this through bitter experience 🙂

I come across this one from time to time with different third party applications.

Somewhere in your procedure, on a comparison field (i.e. tablea.col1 = tableb.col1)

you need to add

collate...

ChrisM@Work (9/11/2013)

---

Hany Helmy (9/11/2013)

---

I am really amazed of the 16 people (as of now) who got it right! :w00t:

Hope one of them will post a reply explaining how he got...

I agree whole heartedly with you on this one Steve. I’ve had some bizarre interviews questions -What kind of animal would you be and why?“ technical ones “What is the...

Haven't seen an editorial create so many responses so quickly for a while.

Amit Pandey DeBugSQL (8/30/2013)

---

Lol, Looks like the person who gave these comments doesnot follow the forums. How can...

Hi,

Have you got any sample data we can have a look at - also how far have you got?

Could you please post what you have so far? - You might...

What version of VS are you using?

Have you looked at the Microsoft Assessment and Planning Toolkit - it scans your network and produces a load of reports about what SQL instances etc are running.

And the table script and inserts for the other two tables involved in the query are . . .?

This might sound harsh but this is not the first time...

To help us to help you, can you please read through the "Posting Data Etiquette - Jeff Moden " link below and then post the info again.

Trying to use the...

Koen Verbeeck (8/16/2013)

---

Richard Warr (8/16/2013)

---

So, the people who based their answer on the documentation got it wrong, whilst those who used "real data" got it right.

Perhaps there's a lesson to...