Is the table design the documents associated with a person and are you then trying to determine if the requirements are met through a SELECT statement?

OR

Is the table...

Can you restore from backup?

Can you keep your status table local? Or additionally keep a local status table? How can you write to your remote status table if you are having network problems? TRY/CATCH...

Having multiple tables (COACH_TABLE, GM_TABLE,ect.) for contacts indicates a problem.

Preferably you have one table to track all your humanoid data points.

Contacts:

[Period] [datetime] NOT NULL

[LNAME] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[FNAME]...

Depends on the version of excel you intend to open the file in.

http://msdn.microsoft.com/en-us/library/aa730921(office.12).aspx#Office2007excelPerf_BigGridIncreasedLimitsExcel

I don't see anything wrong with the code. Switch the cc recipients and see what happens. Also check the sysmail tables in msdb.

http://msdn.microsoft.com/en-us/library/ms187747.aspx

SQL is generally for data retrieval not display. Formatting should...

Yes linked servers existed in 2000.

http://www.extremeexperts.com/sql/yukon/ArchivingData.aspx

http://www.mssqltips.com/tip.asp?tip=1121

http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx

You would use linked servers.

http://msdn.microsoft.com/en-us/library/ms188279(SQL.90).aspx

Browsers can't access a database directly to the best of my knowledge. Browsers access webservers which can be configured/developed to interact with databases.

Scenario:

I have data from the past 10 years. Performance is slow. I want to "archive" data up until the past 6 months. I have a stored proc that generates data...

Can you use a subquery?

SELECT

Field1, Field2 FROM

(

Your query here with your groupings

) AS MyAlias

ORDER BY whatever you want

This is of course air code and not guaranteed to work...

scott.pletcher (7/23/2010)

---

Check each query separately for EXISTS, and put the most likely to be true first.

This should allow you to get rid of the UNION (which should be...

Using TOP 1 also resolves my issue. Thanks again.

I ended up inserting my 'exists' query into a temporary table. I then perform my actual existence check on this temporary table. Execution is 2-3 seconds. This works...not sure about...