JOEL LIPMAN Systems / Automation / AI

Knowledge base / Since 1999

Scripts, systems & field notes.

Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.

192 entries / matching Images

Clear filters
T-SQL Record Separator
Transact-SQL 66348

T-SQL Record Separator

I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on my computer" and me replying "why would you want to do that?". Anyway, I was looking for something like the record separat...

Read note
Alternative method of displaying Unicode in Autohotkey GUI
AutoHotkey 42648

Alternative method of displaying Unicode in Autohotkey GUI

Well yes you could just use the Unicode version of Autohotkey. If you're looking for some up and down arrows which is all I wanted, then you don't have to use Unicode and you can use the Chr() function: msgbox % Chr(24) ; upwards arrow msgbox % Chr(25) ; downwards arrow, unstable

Read note
SSRS External Images don't display
SQL Server Reporting Services 112202

SSRS External Images don't display

The Situation We want some photos taken from another website of ours to display in our report. These are not stored locally on the Reporting Server because other services use these photos on our Intranet and we only want one location to upload the photos. These images are provided via a website address (http) or networ...

Read note
Excel PivotTable Filter List Ordering
Excel 49531

Excel PivotTable Filter List Ordering

So I googled this for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the rep...

Read note
SSRS Parameters in Oracle Stored Procedure
SQL Server Reporting Services 67836

SSRS Parameters in Oracle Stored Procedure

I'm storing a note here because it took a while to figure out and googling other solutions did not answer our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error...

Read note
Before and After, Highs and Lows
SQL Server Reporting Services 35011

Before and After, Highs and Lows

So I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in PHP. Now let's say I have one RDL or SSRS Solution. I could do...

Read note
SSRS Querying on either of 2 Parameters
SQL Server Reporting Services 71249

SSRS Querying on either of 2 Parameters

The situation is that we are replacing a website-application with a single SQL Server Reporting Services (SSRS 2008 R2) report. We're using Business Intelligence Development Studio (BIDS VS2008) with Team Foundation Server (TFS VS2010) and connecting to an Oracle database (ie. "seamless integration because our setup is...

Read note
Win32 Constants
AutoHotkey 84954

Win32 Constants

Apologies for copying this from another source but with lots of OpenSource developers disappearing and reappearing, the content is what I don't want to lose.

Read note
CSS keeping the footer at the bottom
Cascading Stylesheets 33030

CSS keeping the footer at the bottom

Spent enough time trying different methods across the web but only 1 article worked for me using the "push" div layer. Loosely based on Ryanfait: Make a Footer Stick to the Bottom of the Page Aim: Header LeftRight Footer <div id="container"> <div id="header"></div> <div id="content"> <div id="left"></div> <div id="righ...

Read note

Working principle

Our Purpose

This site exists as a practical knowledge base built from real-world experience across systems, platforms, and technologies since 1999. Much of the content documents solutions, edge cases, and working patterns that were learned through investigation where documentation was incomplete or absent, and is shared to reduce the same friction for others.

27 Years in IT
1021 CRM clients
810 Site articles
29.7m+ Reads / hits