Assuming lots is required, the following 18 results were found.
-
T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html
16/10/2011 A009 08:00 17:00 NULL NULL NULL NULL NULL */ YAY!!! Note that in this final stage, you can replace NULL with lots of hyphens (if you want lots of dashes/hyphens as separators) or replace with whatever character. I just put NULL because I...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html
violation 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...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
instructions say that you should "Purge the cache" so click on the "Run Now" button which I found myself doing at lots of stages in this installation process. So note where it is and come back to it when things aren't responding properly....so in...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
system to display your Camtasia Studio SWF files in it's articles. Why Camtasia when there are other free options? We tried lots of FLV players that were usually branded or not free. These were awkward to configure a full screen button on the controls...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
of your screen to get a preview of your desktop, click and you will be brought to your desktop Aero Shake: If you have lots of windows open on your desktop and you only want to look at one, click and hold its window and shake it! All the other windows...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
between the two for the rest of the report. [The second example is what I use most frequently]. Additional: Suppose you have lots of columns, you don't want to have to click on each cell to specify this so just do it to the first column then bring up...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
least open a line of communication. If anyone has any cool ideas, I'd love to hear them. Why do I have to sign up? I develop lots of weird monstrosities that I release on to the web. But to gauge the usefulness of a program, I need to monitor how many...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html
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. ;// ;// Win32 Constants ;// ;#region Peek Message Flags Const PM_NOREMOVE = 0 Const PM_REMOVE = 1 Const...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
think I'm looking in the wrong place. Using Aggregate Functions? What follows is the T-SQL Query I finally went with. Lots of numbers but I think this pretty much answered my question: SELECT Catalog.Name AS ReportName ,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
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...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Joomla 1.5 as the move from Joomla 1.6 or greater is a lot easier since it uses nested categories like Wordpress. There are lots of commercial migrators out there and they all seem to have this problem. I'm really keen not to ask all my users to have to...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
Studio (BIDS) Visual Studio 2008 Microsoft Windows 7 Microsoft .NET Framework 3.5 Microsoft Visual C# 2008 What? So like lots of people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
{ // Some stuff to do when cancel got clicked } }) .show(); Additional: Pre-populating default value and returning input Lots of confusing answers out there on the web but here's an all-in-one where I Open an AlertDialog designed with a custom XML...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
will allow you to change name and photo) Tap on the Manufacturer or Model name under "Specification" to change the details (lots of numbers!). Tap on Quick Reference image to change image. (if you have a different led, you can take a picture or use a...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
to calculate the time between two timestamps and break it down into days, hours, minutes and seconds. Why? I've done this in lots of other systems but here's one in Zoho Deluge. How? We're going to make use of the .toLong() function applied to a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
working so I thought this article could help others. It's also a chance to show off my build. Although not high budget like lots of YouTubers I drew inspiration and advice from, it's my first build in a long time. It's always been a dream of mine (see...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
Books along with their IDs. Why? I often need to send through an automatic payment term on the creation of an invoice but lots of my clients set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
thought I'd put something here as there are lots of posts like this on forums (a lot of which seem to be copied & pasted from other sites) but they refer to SQL Server 2000 or SQL Server 2005. This is how to do it in SQL Server 2008 and creating a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF