Search - Joel Lipman .Com

41. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... column "DC_MyDate" (7349)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about ...; Created on 23 April 2013
42. SSIS Convert a string into a date: / SQL Server Integration Services /; ... error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. All this blab actually means is that there ...; Created on 14 March 2013
43. Convert Decimal (Person Days) to Time in Excel: / Excel /; ... going to be a convoluted formula just to convert it into minutes and then format the resulting value into a custom format of [h]:mm:ss -- Aim / Objective: ColumnA ColumnB ColumnC ---------- ...; Created on 13 February 2013
44. JDatabase: using the Joomla database with examples: / Joomla /; ... a new query object. $query = $db->getQuery(true); // build the SQL query $query->select($db->quoteName(array('p.user_id', 'u.username', 'u.real_name'))); $query->from($db->quoteName('#__user_profiles ...; Created on 27 January 2013
45. DataScramble - Randomizing data rows: / Transact-SQL /; ... 1964-08-08 How? Precursor You will need to be able to create the following view to generate random numbers on SQL Server. -- Drop the view if it already exists IF OBJECT_ID ('vwRandom', ...; Created on 07 December 2012
46. Search a database for a value and count matching rows: / Databases /; ... after the BEGIN and extract the script from BEGIN to END (excluding the words BEGIN and END - avoids the need to create a stored procedure and saving it on a database): IF OBJECT_ID('usp_CountRecordsPerTablePerColumn', ...; Created on 05 November 2012
47. 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
48. Search a database for a string (MySQL, T-SQL): / Databases /; ... - Sorna Kumar IF OBJECT_ID('usp_SearchDB','P') IS NOT NULL DROP PROCEDURE usp_SearchDB GO CREATE PROCEDURE usp_SearchDB @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60) ,@GenerateSQLOnly ...; Created on 08 October 2012
49. Slideshow div layer through a window: / MooTools Framework /; ... (that's the aim at least). Other objects (mostly text over image) will need to be free flowing and slide in emulating a dynamic showcase slideshow. Using MooTools it's also proven to be responsive and ...; Created on 11 September 2012
50. 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
51. Header (Transparent): Created on 01 January 2018
52. Header (Flex): Created on 30 December 2017
53. Header (Centered): Created on 17 April 2017
54. Header (Adspace): Created on 17 April 2017
55. Modals: Created on 17 April 2017
56. Progress Bar: Created on 17 April 2017
57. Testimonials: Created on 17 April 2017
58. Header (Background Video): Created on 10 January 2016
59. Feature Box: Created on 08 October 2015
60. Text Block: Created on 08 October 2015