May 30, 2011 at 1:24 am
Hi,
My database server was in US.
I have a database called TimeEntry. Employees from different countries will enter their timings.
Now my problem is I have to send emails to the superiors based on the employee, country saying that particular employee does not enter time entry. Here I have to timezones because we have different countries.
Please suggest.
Thanks in advanse.
May 31, 2011 at 8:32 am
With over 70 views and not a single response it should be pretty clear that what you posted isn't even close to enough information for anybody to understand what you are trying to do. Try posting clear definition of what you are trying to accomplish. Also please read the link in my signature about best practices for posting questions in such a way that is most likely to get a valuable response.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply