Search - Joel Lipman .Com

21. SSRS Hide results table if empty: / SQL Server Reporting Services /; Update August 2011 So I don't know how many people were just saying why don't you do the following: Bring up the "Tablix Properties" of the dataset Look for the section "No Rows" Put in a value for ...; Created on 29 March 2011
22. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; ... @GivenDate = '23/03/2011'; --First slot of the day SET @StartTime = @GivenDate + ' 08:00:00'; --Last slot of the day (30 minutes before the end) SET @EndTime = @GivenDate + ' 17:30:00'; ; WITH Times([Time]) ...; Created on 23 March 2011
23. 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
24. MySQL: Find records in one table that are not in another.: / MySQL /; The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) ...; Created on 25 February 2011
25. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... changing table prefixes. 2012-03-21: Added "Update 2012" to explain compatibility with Joomla version 2.5.6. 2011-01-30: First draft of this script Still To Do Add intro script to automaticall ...; Created on 30 January 2011
26. SQL Calendar in Business Intelligence Development Studio: / Transact-SQL /; ... s on this part of the used dataset SQL script: ), Events AS ( --Create some events to place on the calendar SELECT EventDate = CONVERT(VARCHAR(2),DATEADD(MONTH, -1,GETDATE()),101) + '/30/20 ...; Created on 14 January 2011
27. Formatting a date in an MDX query: / Transact-SQL /; ... "Short Date") ... 6/15/2009 =Format(Fields!myDateTime.Value, "Long Date") ... Monday, June 15, 2009 =Format(Fields!myDateTime.Value, "ddd dd/MM/yyyy") ... Mon 04/04/2011 European and Now: The above ...; Created on 11 January 2011
28. Parameters not being used in report processing: / SQL Server Reporting Services /; ... varchar(10), @weekNumber int, @siteId nvarchar(5), @baseDate datetime, @specifiedDate datetime, @specifiedCampus varchar(25) SET DATEFORMAT dmy --SET @GivenDate = '1/7/2011' --SET ...; Created on 07 January 2011
29. The Sandpit: / Graphic Design /; I saw this on BBC News Click and was really impressed. It's an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I ...; Created on 26 September 2010
30. Add Image Mouseover effect in AutoHotkey GUI: / AutoHotkey /; ... script. Update: 07 July 2011: For Jose Luis The images I used in this GUI are: and . These have to be saved in the same folder as the AHK script. Well they don't have to, I've just put A_ScriptDir ...; Created on 25 January 2010
31. Change default order of weblinks: / Joomla /; ... to keep track of. Joomla 1.6.x Responding to a comment by J16 User (9 July 2011): As an update for those of us brave enough to use the upgraded CMS, I have looked into this and it would appear ...; Created on 15 November 2009