Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Running Total Issue
Hi Everyone - I am struck with one of script where i have to find the running totals from it. I am using SQL Server 2005. SELECT @UserID ID ,Event Event ,(CASE WHEN ShipDate < DATEADD(wk,-2,StDt)+1 THEN '2Weeks' WHEN ShipDate < DATEADD(wk,-1,StDt)+1 THEN '1Week' WHEN ShipDate <...- webidev
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
TimeZone Conversion
Hi All, My problem is converting the Timezone. My server is in Eastern Time Zone, but users can be anywhere in world. So I wanted them to see the time of their records in their local time. I'm trying to write a formula as shiftdatetime(currentdatetime, "EST,300,EDT", "GMT,0,GMT")...- webidev
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
