Search - Joel Lipman .Com

21. SSIS Convert a string into a date: / SQL Server Integration Services /; ... failure. -- often when processing a datasource, the function is being applied to a NULL date timestamp. Dealing with Date NULLs: Fix: Put conditional statements to account for NULLs. -- Standard TRIM(This_Date) ...; Created on 14 March 2013
22. Quickly update all content in mySQL database replacing a string: / MySQL /; ... One I use this reluctantly but often necessarily. SET @stringtoFind=''; SET @stringtoReplaceWith=''; UPDATE `MYTABLE_content` SET `introtext` = REPLACE(`introtext`, @stringtoFind, @stringtoReplaceWith), `fulltext` ...; Created on 03 February 2013
23. Delete related records from multiple tables: / MySQL /; ... statement but I've added it here as I use it quite often: SELECT s.sessionId, ssf.sessionId, sst.sessionId FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON ssf.sessionId=s.sessionId LEFT ...; Created on 11 January 2013
24. Error 1065: Query was Empty: / MySQL /; What? In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. ...; Created on 13 December 2012
25. Vertically align an asterisk on a line: / Cascading Stylesheets /; ... size of the asterisk, this often increases the line-height and causes the overall line height to change for other objects in the same row. The problem afterwards was that the asterisk character would ...; Created on 02 September 2012
26. Prefix Line Numbers in a Text File: / MS-DOS /; ... of people showing off their MS-DOS batch skills have proposed stupid extensive solutions when all you need is one command-line. Why? Working with programming languages, I often need to write ...; Created on 18 July 2012
27. MySQL Group_concat equivalent in T-SQL and Oracle: / Databases /; ... version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string) ...; Created on 28 November 2011
28. The ReportServer Database: / Databases /; ... milliseconds between start and end times instead of summing the remaining columns? Correction, sum will only give me the total time but what if a report has been run twice more often then another, then ...; Created on 08 August 2011
29. Basic Webpage Controls with JavaScript / COM: / AutoHotkey /; ... this object quite often. To access the Webpage, you will need to navigate through the HTML DOM. Here are some simple ways to do this:Object Name & Index Say you want to get the value of the 1st ...; Created on 05 July 2011
30. SSRS - Lost window with datasets: / SQL Server Reporting Services /; Re: Business Intelligence Development Studio 2008 Often happens to me and not sure why. You open the project and the window panel for the Report Data containing the parameters and datasets isn't there. ...; Created on 25 March 2011
31. Alternate row background colour in Reporting Services: / SQL Server Reporting Services /; ... properties row... Done! Borders: I'm putting this here because often enough, if I'm going to make the report pretty with alternating rows, I'm probably going to look at the cell borders as well. I ...; Created on 04 February 2011
32. Is it a scam? Gumtree.com's warning sign: / IT Support /; ... often may look official, but are actually run by fraudsters. They’ll take your money and never send you the product. Payment for brokerage/importing. A seller claims that there are brokerage fees, ...; Created on 12 October 2010
33. Calculating Percentage: / eCommerce Systems /; I need to often be reminded of how to calculate a percentage. The context here is that I want a progress bar in one of my programs. To determine what percent a number is of a total number: (Progress ...; Created on 20 May 2010
34. Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparison: / Joomla /; ... sites, "the picture that came with the picture frame you bought can often be nicer than the picture you put in". i.e. it's a showroom and you've got to complement the template with your own visuals. ...; Created on 08 April 2010
35. Creating a Top 10 chart with less code: / Personal Home Page /; I've decided to put something in here as it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ...; Created on 18 February 2010
36. Windows 7: System Clock is constantly going out of sync: / Windows OS /; ... clock problem. A workaround in this instance is to change the NTP client to update more often. Note: The following process requires administrator (installation) rights on your computer. Open regedit.exe ...; Created on 28 January 2010