Only when it is NOT the server that has payroll data for the entire staff.

This is an Excel problem not a SQL problem.

Search Technet for excel 2000 2007 differences and you will find about 2,400 articles ... explaining the different formats / how formulas...

Looked today at 6:16 PM USA East Coast Daylight Savnings Time

2005 Devloper - new 43.63 used CD 38.47

2008 Developer - new 43.63 used CD - none listed

Lynn Pettis Posted Today @ 10:36 AM

I'll give you one right now as i have already seen it posted in other threads: Wait a day, the next days email newsletter...

May I point out that the SSC community includes members from countries world wide,...

Good question .... learned something from it ...

Thanks

When running the sp_helprotect @username = 'public' take careful note of all those commands that can be EXECUTED by the public role... be sure you want to allow...

Use and IF ELSE statement (From Books On Line)

IF Boolean_expression

{...

Sorry about that ... just assumed (and you know what that means...

When a DB is backed up ... tables are backed up in their entirety. Not just changed/added rows.

Would examining the logfile violate the ERP's support?

Can you run a Trace...

Jonathan Turlington

Not knowing your actual table structure / indexes etc., etc. My temp table did not have an index, so my code would run using a table scan...

rhfishman

To receive assistance ... please read the first link in my signature box so that those who want to assist you can do so with a tested solution.

How does the CSR add/change an address i.e., through...

Is this what you are looking for

CREATE TABLE #Installers(id INT,daysWorked INT)

INSERT INTO #Installers

SELECT 1,5 UNION ALL

SELECT 2,4 UNION ALL

SELECT 3,3 UNION ALL

SELECT 4,0

SELECT id, CASE

WHEN (daysWorked...

Might I suggest that your read:

How to convert an Access database to SQL Server

http://support.microsoft.com/kb/237980

and/or

SQL Server Migration Assistant 2008 for Access V4.0

http://www.microsoft.com/downloads/details.aspx?FamilyID=133b59c2-c89c-4641-bebb-6d04476ec1ba&DisplayLang=en