Excellent. I'll give it a shot.

Thanks,

CY

Thanks for the input...it's nice to prepare for disasters

Marty

Our web guy is using an int...and was just wondering if down the line he might encounter problems.

Thanks

If this table ever becomes dynamic....(Like most things some day it probably will).... I will put forth your suggestions.

Thanks,

CY

This would be true, however the date field will never change. This will just be used so that a week number can be used in a query instead of a...

Thanks, I do not know I did not think of it. I used

Update Total_Util set WeekNum = DateDiff("W",'01/1/2007',EDATE)/7 and it worked fine.

CY

Thanks Ian

Works great!

CY

I would just one column of all the values. Example Select EmailAddress from EMP.

Instead of

EmailAddress

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

Name@someplace.com

Name@someplace.com

I need

Name@someplace.com,Name@someplace.com

I have searched but just not have found anything yet...

Thanks,

CY

Thanks for the feedback. I did forget to put the "@" before my variable. I also found out that I could not pass back the return variable during a calculation....

Have your tied using a DTS package to import your DBF tables?? I have something similar running as a scheduled task without any problems. Also you might want to...

I may have mislead a bit. Our Network engineeer who wanted to have his blackberry up and runnning installed his Blackberry management database on a production SQL box. And yes...

It does give them all, however it still inclueds the home department as well.

I'm trying this:

SELECT

c.lref,

b.empname,

SUM(TOTAL_1/60 + TOTAL_2/60) as total

FROM [TOTAL] a

InnerJoin emp b on a.empnum=b.empnum

Inner Join...

Sure.

Empnum,empname Lent1(Dept) lent2(Home Dept)

Emp table - 0001003699Smith,Colleen M 53001011000000 001124

Total table 000100369953001011000000001040 ...

How big is the table you are comparing?

checking row by row would be time consuming....

I would just do it all in the DTS package.

1. Insert tnto the temp tables

2....

Thanks for the input. I found the problem. One of our developers started a tranaction and nerver closed it out. It just kept the lock open...

Thanks

CY