Steve,

Here is were I got my answer: http://msdn.microsoft.com/en-us/library/ms190677.aspx

SQL Server 2008 Books Online (December 2008)

Creating a Database Snapshot

This topic describes some best...

nikithanaidu,

Since You are exporting to Excel, the "Opening a rowset for "Results" failed"

indicates the receiving Excel File does not exist or does not have a worksheet with name "Results".

Verify...

Sharon,

Look at : http://msdn.microsoft.com/en-us/library/aa155737(office.10).aspx

Using SQL Email to read mail and execute query.

Thanks,

Ben

Changed query to use #input2

When I run the query below, I get 44 rows.

but When I join the 2 tables I only get 14 rows.

Expecting only have 14 rows in...

John,

Here is simplification of the 2 tables.

They are matched on one key item.

#input1 - row 5 has only one match....

The Temp table is for example and does represent a table created from joining 2 other tables.

When the 2 other tables are joined, I get multiple rows for some of...

End result is a report show the type for each row.

tempcheck_idRECORD_IDItemI_descS_descM_descStatus_Flag

1 ...