By "reflexive", do you mean a self-join? If so, I agree with Phill Cart's response - just add the table again and Access will create an alias for it.

There is - use the SQL pane and write the query yourself.  Is that what you mean?

It is possible to restore without the log file - SQL Server should create a new log for you.  Are you working in EM or QA and exactly what is...

So you want to display the campaign count for the partner on the same row?  This is untested, but along the right lines - you will see that I have...

Try this:

SELECT MAX(LEN(isnull(COLUMN1,''))+LEN(isnull(COLUMN2,''))+LEN(isnull(COLUMN3,''))) FROM TABLE1

It's a simple enough matter to put triggers on tables that you want to be able to do this for - to record 'date last updated' and 'updated by' for...

Suggest you import the spreadsheet into SQL Server "as is" and then normalise.  Your general approach should work though:

insert into tblNormalised(date, offer, receipt)

select date1, offer1, receipt1 from imported union

select date2,...

Surely the time difference here is due to the fact that SELECT INTO is writing to disk and SELECT is not?  How much data are we talking about?

You need to switch context as part of the sp_executesql statement.  Try this:

declare @strSQL nvarchar(1000)

set @strSQL = N'use tempdb '

set @strSQL = @strSQL + N'select top 10 * from information_schema.columns'

exec...

Noticed that col_Fname is ambiguous, so you need to qualify it:

SELECT DISTINCT r.col_Fname

FROM tbl_Reports r left join tbl_Employees e

ON r.col_Fname = e.col_Fname

WHERE e.col_Fname is null

If that doesn't work, there's something you're...

Or this way:

SELECT DISTINCT col_Fname

FROM tbl_Reports r left join tbl_Employees e

ON r.col_Fname = e.col_Fname

WHERE e.col_Fname is null

Using != in a join is an advanced technique that will rarely be required.  I...

Hi Thomas - as I was writing my last post, I noticed that Remi had already written almost exactly what I was typing - so he "beat me to it" ie...

Which fields need to be compared?  Just an ID field, or several?

Beat me to it Remi!

Check out SET TRANSACTION ISOLATION LEVEL in BOL and see whether that gives you what you want.