Room Availability Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 @GivenDate + ' 08:00:00'; --Last slot of the day (30 minutes before the end) SET @EndTime = @GivenDate + ' 17:30:00'; ; WITH Times([Time]) AS ( --Select First hour in range SELECT CONVERT(DATETIME,@StartTime) AS [Time] UNION ALL --Add a record for every...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 services. There are websites that do this for me? Yay! for free as well, as long as my page isn't loaded more than 100,000 times a month. I don't understand, one website visitor can generate 1000 hits, so thereafter I have to pay every time someone sees...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 an exact number of occurrences of the preceding character or subexpression. For example, to find where 'a' occurs exactly 5 times, you specify the regular expression: a{5} This expression matches: aaaaa The expression does not match: aaaa Interval...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Creating a Top 10 chart with less codehttps://joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 chart of your data (eg. movies, music, etc). My aim is to do the following: retrieve data from a table, count the number of times each data exists, sort it in reverse order so that the most frequent is at the top of the list print out each row with the...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 /XO -- /E makes Robocopy recursively copy subdirectories, including empty ones. -- /XC excludes existing files with the same timestamp, but different file sizes. -- /XN excludes existing files newer than the copy in the source directory. -- /XO excludes...

• Type: Article
• Author: Joel Lipman
• Category: MS-DOS
• Language: en-GB

Forum Ruleshttps://joellipman.com/static-items/forum-rules.html

31 May 2009 of this rule. No Double Posting or Spamming - You may not post more than once in a row in the same thread. Posting lots of times in a row reduces the quality of the board, is a waste of the board's memory, and provides the culprit with ill earned post...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 description => sort by description date => sort by date added (most recent or oldest first) hits => sort by hits (number of times clicked on) published => obviously by whether they're published or not... no idea why u would checked_out => sort by...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Project Plan for Freelance Websitehttps://joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 is spent faffing around with design and functionality. We use the ProjectFork extension to manage projects, it helps during times when we can't see face-to-face with colleagues or clients. Startup Meeting For you to discuss: Aims / Objectives Deadlines...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 report (looks like a hexadecimal SSID). It's the unique ID of the report but not unique in the table (can be referenced many times). UserName nvarchar(260) NULL Windows authenticated username and domain of the person running the report (eg....

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

The Mermaidhttps://joellipman.com/articles/_other-misc/the-mermaid.html

24 July 2012 skipping up aloft, And the land lubbers lying down below, below, below, And the land lubbers lying down below. Then three times 'round spun our gallant ship, And three times 'round spun she. And the third time 'round they all went down, As she sank to...

• Type: Article
• Author: Joel Lipman
• Category: Hobbies
• Language: *

Database Error: Unable to connect to the database: Could not connect to MySQLhttps://joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 block me thinking I was trying to hack into their servers because of the number of queries Joomla does and the number of times I refresh the page and upload files. Why they think that developers should not be able to send a 1000 queries a minute or why...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Formatting a date in an MDX queryhttps://joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 "ddd dd/MM/yyyy")... Mon 04/04/2011 European and Now: The above is about formatting dates and times but if you want a NOW timestamp in a specific format, try... =Format(now(), "ddd, dd MMMM yyyy HH:mm:ss") =Format(now(), "dd/MM/yyyy") The reserved...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 FROM Dates d LEFT JOIN Events e ON CAST(CONVERT(VARCHAR(10),e.EventDate,101) AS DATETIME) = d.[Date] --Set the maximum times the Dates cte can recurse OPTION (MAXRECURSION 100) I'd appreciate if you bear with me as I add captions to the below...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Difference between two dates - the midnight hourhttps://joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other side of the midnight hour... Now bear in mind the below is in...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 by sinkfaze) Basic Webpage Controls COM Object Reference Last edited by jethrow on Wed Jun 22, 2011 10:18 pm; edited 22 times in total Source: Jethrow @ Autohotkey Forums

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Before and After, Highs and Lowshttps://joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 using the ReportServer database in SSRS 2008 R2: SELECT Catalog.Name AS ReportName, DATEPART(dayofyear, ExecutionLogStorage.TimeStart) AS DayOfYearRun, DATEPART(week, ExecutionLogStorage.TimeStart) AS WeekRun, DATEPART(year,...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

SSRS External Images don't displayhttps://joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 Reporting Manager Problem #2: Alternative image if file does not exist We don't have photos for all ~20000 students at all times and these get updated/uploaded/added to about once a week. In cases where there are no photos, SSRS displays a mini ugly red...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Performance Report - Background colors based on dataset valueshttps://joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times taken for "data retrieval", "processing", "rendering", and then the totals of these. I haven't Googled this at the time of...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SSRS Dropdown parameter cannot be blank!https://joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 $w_value = $number_of_weeks_from_now; // usually 0 for this week, 1 for the week before, 2 for the week before that... $timesheet_query_per_user=" SELECT DISTINCT s.StaffUserID AS 'UserID', ( SELECT...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB