dbo.WorkOrder [CREATEDBYID]

Hi, I forgot to mention that I also need a way to convert the integer found in [CREATEDBYID] into the associated user name. You guys have given me the following SQL Statement to convert the dates:

SELECT [WORKORDERID] , [CREATEDBYID] , dateadd(s,CREATEDTIME/1000,'01-01-1970') , dateadd(s,DUEBYTIME/1000,'01-01-1970') , dateadd(s,COMPLETEDTIME/1000,'01-01-1970') , [TITLE] FROM [WorkOrder] WHERE [REQUESTERID] = 606 AND [COMPLETEDTIME] = 0

This works perfectly for the date conversion, but like I said I had forgot to mention that we also need to convert the user id's to name.

Please advise!

Thanks,

Scott Hasler
Total IP, LLC
Web / Application Dev.

http://www.totalip.net

email: scott.hasler@totalip.net