- 41. Inserting incremental weeks in MySQL
- / MySQL /
- Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different ...
- Created on 15 April 2011
- 42. T-SQL DateTimestamps
- / Transact-SQL /
- My setup Windows XP SP3 MS SQL Server Management Studio 2008 SQL Server 2008 R2 Regional Setting: London BST (British Summer Time) Tuesday the 11th of October 2011 at 06:00am: CONVERT(CHAR(19), ...
- Created on 23 March 2011
- 43. Alternate row background colour in Reporting Services
- / SQL Server Reporting Services /
- ... Mod 2, "#ffffff", "#eeeeee") or =IIF(RowNumber(Nothing) Mod 2, "WhiteSmoke", "Garamond") This is telling the report to be white (=#ffffff) in row 1 (odd row numbers) and a very light grey (=#eeeeee) ...
- Created on 04 February 2011
- 44. Animated Numbers
- Created on 17 April 2017