Just missing one thing, the expected results. Based on the sample data provided, what SHOULD the output look like. You should be able to put that together manually,...

Provide us with the t-sql scripts you used to restore the database. Based solely on your description, we really can't tell you what you did wrong, if anything.

Actually, I can see why they may need two years of data online. Previous employer required that we maintain that much history in OLTP system (COBOL/ISAM databases). We...

How about the DDL for the tables, some sample data (as insert statements that can be cut, paste, and executed in SSMS) to load into the tables, and the expected...

What version of SQL Server are you running?

Also, post the SQL Code you used and got the error with, please.

Not really sure, but do you have indexes like these on the table in the query? The names used for the indexes are mine.

create nonclustered index IX_vgh_ProductsQry1

on dbo.GICSPFVendorCategoryHeader (

...

The best alternative you have, you've been told you can't use. This is a perfect place to use SQL Server Service Broker. A trigger sends a message to...

Here is a code sample for dropping records from a table in batches:

declare @backupcnt int;

declare @backupfile varchar(128);

set @backupcnt = 0;

-- Delete records that are more than 5 years old from...

All I can say, is maybe. When I found out that NS would not be a part of SQL Server 2008, I stopped even looking at it for anything....

You are aware that SQL Server Notification Services (if that is what you are refering to in your posts regarding notification services) goes away with SQL Server 2008.

Using my example tables, do you really want notes for records from on Employees, Vendors, And Customers in the same table? From a design point of view, it isn't...

I thought so. I just attacked the obvious BOOLEAN error in the original code and didn't really...

No issue. What you see in...

Let us approach it from a different direction. Three tables Customer, Vendor, Employee. Each table has a related Notes Table, CustomerNotes, VendorNotes, EmployeeNotes. Do you REALLY want...

Andrew Peterson (11/5/2008)

---

an index works as well, but try to keep it narrow and put some of the lesser values in an include. you want to keep it as narrow...