Left of Right as the same - they are both OUTER joins.

Left or Right depends on which order you mention your tables.

FROM tableA LEFT JOIN tableB

is the same as

FROM...

Yes, that would maybe do it? If all you need is the overall sum, you can omit the separate workorder id's..?

/Kenneth

Example please?

Show current output and desired output.

/Kenneth

I must confess I've never used bulk insert that much, I still favor bcp for my loads and unloads.

In the simples way, using bcp, the command would look something like:

Have no idea why Visual Studio does that.

The 'proper' way works though... Go into QA and do something like this:

alter table...

Well, I can't reproduce this.

Can you post the DDL for the table, and also provide a sample row that gives you the error..?

As far as I can tell, the proc...

I have no clue about hyperlinks in Access, but... are you positive that the actual value stored in Access is indeed 'j:\Docs\Budget.doc' ..?

I mean, this doens't like like no hyperlink...

The only reason I can think of is when people wants to write queires as 'SELECT * FROM....' which should be avoided in the first place. 

Well, ok, whatever works for you.

However, by resorting to temptables and cursors, there's actually nothing you can't solve. The question (for us SQL dudes anyway) is more if you really...

Ok, I'll just borrow Remi's links for what we need in order to provide any useful help.

Help us help you

Generate insert statements

Must...

Almost there I think...

This first came to mind:

select f.fname, b.bdesc, l.ldesc

from #forms f

join #buttons b

on f.fid = b.fid

join #labels l

on f.fid = l.fid

fname                bdesc                ldesc               ...

The easiest way (without worrying about internal time-storing architecture) to describe when the day ends (say 2005-10-03) is when it's less than the start of the next day...

So, '2005-10-03' starts...

I don't quite understand the question, but if the main thing is the layout of the results, then it looks like that is the kind of formatting best suited for...

Examples, please.

We need a tabledefinition and some sample data and the results you'd like.

/Kenneth

This kind of problems may be easier when SQL Server 2005 arrives. In sqlcmd (the 'replacement' for isql/osql) command utility, you can connect to more than one server within the...