Search - Joel Lipman .Com

41. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if this could be restored to a normal ...; Created on 04 October 2013
42. Parse a HTML Table into a ListView: / Hypertext Markup Language /; What? A quick article on if you were given a webpage coded in HTML, what methods in AutoHotkey could you use to separate out the HTML Tables into a ListView. Why? I want a snippet of code that ...; Created on 30 March 2013
43. Country Lookup by IP address CSV: / MySQL /; ... License.txt: Released under GNU/GPL ReadMe.txt What is it? I wanted my own IP lookup script to tell me the country that is allocated a given IP address, this is what I use. The scripts ...; Created on 17 March 2013
44. SSIS Convert a string into a date: / SQL Server Integration Services /; ... column will have a string of 8 characters long in the format DDMMYYYY and on other rows, this is blank with spaces instead, I still get the Error: The conditional operation failed. -- I've been given ...; Created on 14 March 2013
45. Convert Decimal (Person Days) to Time in Excel: / Excel /; ... In other words, 1.0 in decimal, formatted to time is equal to 24 hours; 0.5 would be 12 hours and so forth. My formula: -- Given Cell B5 = 0.14 person days from above example. -- 1 person day = ...; Created on 13 February 2013
46. Delete related records from multiple tables: / MySQL /; ... to use the system you were given. Given a Relational Database Management System (RDBMS) where deleting some erroneous rows in one table will cause errors because the existence of those rows is stored in ...; Created on 11 January 2013
47. Php convert filesizes to bytes kb mb gb: / Personal Home Page /; What? Just a quick note on how to format a given filesize and to reduce the display output to a small string, eg: 196 bytes : displays as => "196 bytes" 12945 bytes : displays ...; Created on 03 January 2013
48. DataScramble - Randomizing data rows: / Transact-SQL /; ... DECLARE @ColumnTypeIsDate int; DECLARE @IntOptions int; DECLARE @CharOptions varchar(max); -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); ...; Created on 07 December 2012
49. DataTumble - Randomize Data Rows: / Transact-SQL /; ... and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and DataScramble). How? CREATE PROCEDURE [Common].[usp_ScrambleMultivalue] ( @TableName ...; Created on 07 December 2012
50. Convert a delimited string to table: / Databases /; What? This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- ...; Created on 26 October 2012
51. Header (Centered): Created on 17 April 2017
52. Header (Adspace): Created on 17 April 2017
53. Flip Box: Created on 30 November -0001
54. Slideshow Addon: Created on 30 November -0001
55. Image Layouts: Created on 30 November -0001