The real take away is everyone makes mistakes, even sometimes when checking the work. Check, double check, take a break (and then triple check <if it is important>) and...

For some one with decent computer language experience, the problem isn't learning new syntax or or even getting a good sense of how a language flows. It is learning all...

Without a good 'reason' for the table, the id column by itself is not enough to say that there are 2 different "Brian" employees. the id might be refering...

5th Option - Use a RAM Centric Model in a JVM

Build your database in RAM on your system in a JVM. Store all leave objects changes (edit/insert/deletions) immediately to...

I think the comments above, regarding the sleep command is required, and so is the file check logic after the loop.

Suggestion 3.

The script putting the file onto the server should...

This function in the textbox worked. & n b s p did not work in the place of

chr(160).

=Replace(Fields!str_len5.Value, " ", Chr(160))

Thanks this solved the problem, put me on...

I don't wish to denigrate vbscript in any way, I probably should use it more, the results are certainly easier to read than some of the stuff I do. ...

Interesting Question, 2 comments:

Syntax appears to be wrong to me, missing '2' and one bracket: ')'

**I could be wrong but I think the sql should be**:

MERGE Address as NewAddress

Using (select...