the select statement should be:

SELECT

[COMPANYNAME]

,[DISTRICTNAME]

,[STORENBR]

...

DDL/DML

Using SQL Server 2005 on VISTA

IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_NAME='MYSALES')

DROP TABLE MYSALES

GO...

---============ INSERTS INCLUDING 2008 DATA

--

DELETE * FROM MYBKFTDETAIL

--------------------------------------------------------------------------------------------------

INSERT INTO MYBKFTDETAIL

(Store , BusinessDate, BKFTtotal)

SELECT '2074','Sep 3...

Yes. SQL Server 2000.

1 more note:

as you see by my Stored Procedure, The YTD field, and YTD Last Year use different dates from those in the...

--========SQLSERVER2000 ON WINDOWS 2000

---==== CONTAINS INFO ABOUT STORES

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MYStore]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[MYStore]

GO

CREATE TABLE [dbo].[MYStore]...

Thanks, Lynn. This is such a textbook business problem and i'm really only asking for best way to approach something, those things mentioned in your first link to get...

Update: We have moved to SQL Server 2008. should I be saying "Yeah!" or "Oh crap".

Also, your trigger is so generic, how can I make it a global...

OK, just verified by my manager that the 2000 database was auto installed from previous software that we have. It just has a SQL 2005 interface. Crap! From your...

I got

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT...

Tried to change Compat level manually in DB properties but level 90 was not listed. So I ran

sage: sp_dbcmptlevel [dbname [, compatibilitylevel]]

Valid values of database compatibility level are...

I was reluctant to post this because it was simple oversight on my part, but the script ran on 2 of my SQL Server 2005 machines(1 WinXP and 1 Vista)...

The update is executed only when human resources changes data about an employee via a web form. (They can't change the employee id). The system is not designed for...

Cancel that. It did work. Thanks again. How do I give you points.

I ran the query below and also went into employee table and changed SSN4 to 985 and in neither case, there was nothing placed in Audit table. However, yours did...

Wow! Now that is some fancy script. I ran it as is but did no records were inserted into Audit table. I did receive the 1 row(s) was affected...