We are converting our Database from ORACLE to SQL Server and I was to verify how it should be done in SQL server for best practices. I appreciate all...

Thanks:-)

Thank you very much for all of your help. 🙂

I am working with 2 payrolls that end on Saturday and Sundays. I need to report the hours for the first weekending date of the previous month. For...

YES, MANY THANKS!!!!!:-)

Sorry, I meant first Monday of previous month - 6 days. Would I just change the 53684 to 53685?

I really apppreciate your help!

Thank you for your post. It works great. I also need the first Monday of the month - 6 days. How would I modify this script to get...

Thank you Grasshopper. I just figured out a different way after finding an old post on this site 🙂 but I appreciated your reply

(CAST(SHIFTLABEL AS CHAR(6))) + ' ...

Did you get a solution for your problem? I have a similar issue.

Thanks

I was able to get the second script converted but I still need help with the first script.

Second Script SQL Server code

SELECT T.employeeid,

...

Thank you but I have done that and I still cannot get the code correct. Can anyone help me with the coding?

More info. We are using SSRS though a SQL Server 2005 Standard edition and linking to a KRONOS Oracle 10R2 database

SQL Server 2005 Standard Edition. Thanks for any help that you can give me.

Thank you very much for your help. I did not know there was a problem with hyperthreading. Can you point me to a document concerning hyperthreading and SQL...

Yes, I am signed on the server when I open EM and when I run the query.  I run the query from EM.