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 I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours only as well......

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

T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 expression: --Create CTE WITH tblDifference AS ( SELECT t1.*, ROW_NUMBER() OVER (ORDER BY t1.Date ASC, t1.Start ASC, t1.Room ASC, t1.Finish ASC) as 'RowNumber' FROM ( -- start your original SQL query and save results as table t1 SELECT -- perform...

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

Room with a view E.M. Forsterhttps://joellipman.com/articles/_other-misc/room-with-a-view-em-forster.html

04 February 2011 Taking a break from website migrations. Thought I'd share some thoughts I was reminiscing of: "We cast a shadow on something wherever we stand, and it is no good moving from place to place to save things; because the shadow always follows. Choose a...

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

Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 script: -- =============================================================================== -- Description: Gets the room bookings for a week based on a given date and campus --...

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

SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 Situation: I have a report which I've already completed and pretty chuffed with. It shows the details on a user-specified room taken from a room bookings system. Below the details, we've connected it to the assets database and want to list the equipment...

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

SSRS Use T-SQL Like with a Parameterhttps://joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and Microsoft's SQL...

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

Sun-Dried Tomato Basil Couscous Recipehttps://joellipman.com/articles/_other-misc/sun-dried-tomato-basil-couscous-recipe.html

03 September 2009 Simple and quick couscous is flavored with sun-dried tomatoes, green onions, and basil. This dish may be served hot or at room temperature. Use store-bought vinaigrette or make your own. Prep Time: 10 minutes Cook Time: 5 minutes Ingredients: 1/4...

• Type: Article
• Author: Joel Lipman
• Category: Hobbies
• 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 "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar which will display any room bookings for that month. This is "Reinventing" because we used to use MS Outlook to store these kind of things until the...

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

Getting the mysql where in delimited string to workhttps://joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room. The Problem? When I select specifying the statement "WHERE IN (c.RoomImages)", this is interpreted as a string and when converted to...

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

Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 using the MidJourney Bot Signup to Discord.com Visit Midjourney.com Go to the Midjourney's discord channel Join a community room (named "Newbie"...) // or if you subscribe you can have a private conversation with the MidJourney Bot Type the word...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Reminder on SSRS row separatorhttps://joellipman.com/articles/microsoft/ssrs/reminder-on-ssrs-row-seperator.html

26 October 2011 Development Studio 2008 (BIDS) SQL Server Reporting Services 2008 R2 (SSRS) What do I want? I have a report displaying room bookings. Each row lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row...

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

SSRS Expand specific drilldown by defaulthttps://joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 report in Business Intelligence Development Studio (BIDS) or MS Report Builder. Scenario I have a report that specifies some room bookings for a particular week. When I open the report, each drilldown row is collapsed (as opposed to expanded). The user...

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

What's the problem? Amusing computer issueshttps://joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 Ok could you please follow the cable from the computer to the printer and tell me.". "Hang on its on the other side of the room.". This was a remote support job over the phone. The discussion above was after installing drivers and setting up the...

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

T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 an error: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone] + ', ' + rm.[Capacity] + ', ' + rm.[Type] + ', ' + rm.[DeptId])) AS RoomDetails // yields Conversion failed when converting the varchar value ', ' to data type int My issue was silly T-SQL concatenation...

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

AutoHotkey: Get Media Information and Displayhttps://joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

07 August 2020 _File, _Drv If ( p[p.length()] = "xInfo" ) ; Last parameter is xInfo { p.Pop() ; Delete parameter fex.SetCapacity(11) ; Make room for Extra info fex["_Attrib"] := A_LoopFileAttrib fex["_Dir"] := _Dir fex["_Drv"] := _Drv fex["_Ext"] := _Ext fex["_File"]...

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

Live WebCam feed of Bournemouthhttps://joellipman.com/articles/web-development/live-webcam-feed-of-bournemouth.html

30 January 2013 So having moved desk from one side of the room to another, I have lost my view of the sea. Oh well, this is where technology has come to the rescue and returned my calming view... Note: I think this is running in British Summer Time (BST) rather than...

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