I didn't see it on the day it opened in the UK, but certainly within the first week. I took my kid brother along one time (his first, my fourth...

My personal favourite is "Corporate Responsibility", as if we should all believe that the CEO will always put the needs of one above the needs of the shareholders.

Stobbadino

The best approach IMO is to set up some dummy tables with data, and ask the candidates to write SProcs and functions to return results. These need to be reasonably...

The SQL equivalent of an Access memo field is I think VARCHAR(MAX).

Chris

For the benefit of anyone else reading this who is experiencing similar problems, it looks like the problem may well have been related to the fact that my datasource was...

This gives the same result unfortunately - nothing!

Sorry, my fault - I do mean dataset every time.

I have no problems with stored procedures that select from an existing table (using the example above there would be no...

Thanks Michael

I reckon the simplest solution is to educate the one other person within the organisation who has the ability to modify the Lotus Notes structure - and make sure...

I'll take a look.

Thanks Tom

Chris

Thanks Tom, I probably should have said that the source isn't SQL, but a Lotus Notes database being accessed via ODBC, so I'm not sure that your idea will work.

Chris

Shivali

It is possible to extract data from a Lotus Notes database view - this gets treated like a table and you can select which columns you want.

In order to do...