No problem. Glad that I could help.

Steve Jones - Editor (8/30/2010)

---

Probably a separate thread, but what's the menial workload? What do you do on a regular basis? I'd post that elsewhere, and perhaps see if there's...

tsmith-960032 (8/30/2010)

---

WayneS (8/27/2010)

---

Are you rendering this in a browser? Because on the child report all you have to do is click the browser's back button... or press backspace.

If you are...

The reasons that you've stated are all good reasons for leaving. Your concerns about leaving are also valid.

Have you talked with your supervisor about the rut you're in?

Check out this link

jesuslives01 (8/30/2010)

---

I'm getting an error pointing to the last ')'; however, that may not be the real problem. Anyone know what is wrong?

I tried it with and without the ';User...

If coded properly as a set-based operation, just fine.

Remove your where clause completely - this is filtering the result set.

Make your from clause:

FROM

@Timecards TC LEFT JOIN @ProtectionFactors PF

...

Excellent start.

One question: Based on the sample data provided, what should the result set look like?

Oh - one other thing.

Run DBCC CHECKCATALOG while you are in SQL 2000 (you should run DBCC CHECKDB also).

This will detect if any system tables have orphaned records, from where...

Thanks Jason, I should have put...

CirquedeSQLeil (8/30/2010)

---

I will.

Wayne, call me when you...

You will not be able to do an in-place upgrade, where the existing server is upgraded, since you are going from 32-bit to 64-bit.

1. script logins/custom messages/jobs/operators from existing server....

Does this get you the data that you're looking for?

SELECT [IndexName] = so.name,

[IndexPos] = sik.keyno,

...

Anyone here going to the SQL Server Connections in Las Vegas Nov 1-4?