The problem is that #3 does have a matching value in #2. SQL has no problem joining both #1 and #3 to #2. If you can place another...

It sounds like you might be referring to the EXCEPT clause from SQL 2005.

SELECT * FROM customerequipment -- 900 records

EXCEPT

SELECT * FROM customer --461 records

That will return the rows...

This is really easiest done if you have sequential numbering of the rows (i.e. via an IDENTITY column). So if you had:

row date

1 ...

Sorry, I should've been more clear. The whole quote is:

"Indexed view creation is supported in all editions. Indexed view matching by the query processor is supported only in Enterprise...

"Indexed view creation is supported in all editions."

Source:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

There's a number of third-party tools which will do this for you. That's easiest. Either that or just configure yourself as an operator and set the backup job...

Reporting Services is included in your licensing costs for SQL Server.

You can embed the SQL query into the report much in the same way you can define the source data...

You might also look into creating a DTS package and scheduling it. I've found the GUI can be much easier for those who aren't very adept with SQL.

You can...

You might want to consider seperating out these actions into different job steps. In case something goes wrong it might be easier to troubleshoot it down the line.

I'm not 100% sure I'm reading you right, but that looks like it should work fine.

If you use Enterprise Manager to reset the accounts which SQL Server uses for startup...

What is it returning?

I'm assuming that you have a table for people and a table for products... You might want to think about doing your join something like this (pseudocode, as above...

Try this?

IF NOT EXISTS (SELECT 1 FROM dbo.sysobjects WHERE name = @tablename AND xtype = 'U')

BEGIN

SET @var1 = 'CREATE TABLE ' + @tablename

EXEC (@var1)

END

SET @var1 =...

I always do what the poster above did but append on another CONVERT(DATETIME... to it.

Possibly, you might try WHERE LEFT(vendor_name, 1) = 'a'... that might work better.