Search - Joel Lipman .Com

21. Joes Quicklist Weblinks (JQW) Downloads: / Downloads /; ... 10th Mar 2013 2.1.1 - Corrected alias reference to all columns irrespective of order settings. - Link for text only links title and not description. - Restored module parameter: Display Rank or ID.- ...; Created on 07 September 2015
22. List of Font Awesome: / Web-Development /; ...  fa-cog []  fa-cogs []  fa-columns [] ...; Created on 04 September 2015
23. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... and to populate a database table with this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column widths match. How? ...; Created on 13 June 2014
24. Excel: Find values in one column that are not in another: / Excel /; What? A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...; Created on 06 March 2014
25. Generate a Timesheet in MySQL: / MySQL /; ... We have the first two columns of what we want to do. Now we need the same again but this time we want the morning slots SELECT DATE( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) DAY ) ) ...; Created on 05 December 2013
26. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... and ", "la", "le", " van ", " de ", " of " and similar should remain lowercase. How? The SSIS Script component task has to be generic, it should only apply this to columns we specifically tick i ...; Created on 04 October 2013
27. Compare two databases using T-SQL: / Transact-SQL /; ... here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases ...; Created on 24 September 2013
28. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... failed. Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "MyDerivedColumns" (4228)" failed because error code 0xC0049063 occurred, and the error row disposition on "output ...; Created on 23 April 2013
29. MS Excel - Sort pivottable column headings by date: / Excel /; ... with one more zero so that "008" is before "010": Great! The columns are displayed in the correct order but who's ever seen a date written as the 008th of April? What if we didn't use parentheses? ...; Created on 12 April 2013
30. SSIS Skip Rows in Excel Source file: / SQL Server Integration Services /; ... an excel sheet where the first 10 rows are descriptions to the column, and then I have 38 columns ("A" to "AL"): In the data flow, click on the Excel datasource component so that it's selected. View the ...; Created on 04 April 2013
31. Parse a HTML Table into a ListView: / Hypertext Markup Language /; ... RowIndex++ ReturnedHTMLTableColString:=ReturnedHTMLTableRows%RowIndex% ; split the row into columns StringReplace,ReturnedHTMLTableColString,ReturnedHTMLTableColString, ...; Created on 30 March 2013
32. SSIS Convert a string into a date: / SQL Server Integration Services /; ... dates one which was imported as a string (DT_WSTR) and another as a integer (DT_R8). Why? It took me a long time to figure this and it was only by trawling through columns that someone mentioned ...; Created on 14 March 2013
33. JDatabase: using the Joomla database with examples: / Joomla /; ... ->columns(array('name', 'username')) ->values(implode(',', array($db->quote('Joe'), $db->quote('jlipman')) )); $db->setQuery($query); $result = $db->query(); -- retrieve last inserted ID $last_inserted_id ...; Created on 27 January 2013
34. Search a database for a value and count matching rows: / Databases /; ... ** ** Return Values : Table of three columns: ** ** - myValue: value specified in parameter 1 (matched in database to search) ...; Created on 05 November 2012
35. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; ... columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL DROP PROCEDURE [usp_ListDistinctValuesAndCounts]; GO CREATE PROCEDURE [usp_ListDistinctValuesAndCounts] ( ...; Created on 26 October 2012
36. Search a database with SOUNDEX: / Databases /; ... 'dbo'; ** ** ** ** Return Values : Table of two columns: ...; Created on 11 October 2012
37. Search a database for a string (MySQL, T-SQL): / Databases /; ... + ' WHERE SOUNDEX(' + COLUMN_NAME + ')=SOUNDEX('''+ @mySearchString +''')' + CHAR(10) FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE IN ('char', 'nchar', 'varchar', 'nvarchar', 'text', 'ntext') AND ...; Created on 08 October 2012
38. Copy a table with structure and data into a temporary table: / Transact-SQL /; ... AS VARCHAR(10)) + ')' END FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TableName ORDER BY ORDINAL_POSITION FOR XML PATH ('') ),1,1,'' ) + ';'; EXEC(@TableDeclaration); -- ...; Created on 03 August 2012
39. DataJumble - Shuffling characters in a data value: / Transact-SQL /; This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...; Created on 01 August 2012
40. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... the second query which is the one that will return my columns. Two output fields are expected to be returned: "p_STUDENT_DETAILS" and "p_STUDENT_REF". 2. Add a datasource Nothing different to ...; Created on 19 January 2012