Unless things have changed with Access, when you attempt to open it and run a macro, Access wants to interact with the desktop, something it can't do when you try...

Curious. The code Iprovided found all the mdf/ldf files in my data directory that had been detached from SQL Server on my desktop system with no problems. Makes...

Gus,

You are correct, the EXCEPT would have been easier, but I was trying to keep it close to SQL Server 2000. Only changes needed would be to the appropriate...

I already added it to my signature block!

Although this is posted in SQL Server 7/2000 forum, I don't have a SQL Server 2000 system available, so the following solution is for SQL Server 2005. With a...

This is a running totals problem and is easily solved. Unfortunately Jeff's article is currently off-line, but there are numerous forum threads here on SSC that discuss it. ...

Yes, Jeff's article is great info, and I'm sure he'll thank you for the feedback. I'm glad we could help you understand what a powerful tool the tally or...

datediff(dd,registerddate, getdate())

darryl (6/11/2009)

---

Thanks for the reminder. Was guilty last time and you reminded me then. Just can't seem to get myself to use my live code/data. Must be...

darryl (6/11/2009)

---

Since I didn't give you the actual names in previous postings, here is what your suggestion looks like modified to fit the actual names:

select

A.empnum,

A.ename,

...

Pretty vague specs from which to write an application. What else can you tell us? Specifics would be really appreciated.

Try this:

select

A.EmployeeID,

A.Name,

sum(B.reg_hrs + B.ot_hrs + B.sick_hrs + B.vac_hrs + B.hol_hrs) TotalHrs

from

employee A

...

I'm pretty sure your requirements are more specific than what you have provided in your original post. If you could be more specific, provide DDL for your table(s), sample...

Sergiy,

Double check for me, but I think the code in the original post is missing a group by. I didn't catch that as I reformatted the code. That...

WayneS (6/10/2009)

---

Lynn Pettis (6/10/2009)

---

WayneS (6/10/2009)

---

Hey gang,

A reader of my article today asked a very good question that I'm not sure what the answer would be. I'm hoping that someone along...