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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Cecass
-
Trouble with DATE
I did not mean to cause trouble! But thanks for the info.- Cecass
- Post #16
- Forum: Microsoft SQL Server: Programming
-
Trouble with DATE
My MSQL query returns the number of days between two dates How can I convert this into Years,Months,Days format? Help please.- Cecass
- Thread
- Replies: 21
- Forum: Microsoft SQL Server: Programming
-
How do I find Today
I want to put a age query in an MSSQL database I know the birthday but can not find a way to enter today's date for a DATEDIFF statement. Can anyone help?- Cecass
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Update Trigger
Can anyone help? I want to create a trigger to replace the following update: UPDATE SERVICES.dbo.SICKNESS SET HOURS = ((CONTRACTUALHOURS/5)*DAYS), COST = (((CONTRACTUALHOURS/5)*DAYS) * HOURLYRATE), TOTALCOST = (((((CONTRACTUALHOURS/5)*DAYS) * HOURLYRATE)+ ONCOST)+ ADDITIONALCOST) FROM...- Cecass
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
