Search
-
Category: (Joomla! Tutorials)
... Insert this between the if ($sContent && $limit > 0){ and before the from part of the query $query->from('#__content AS a'); // Add "Relevance" column // + 1000 pts if in title x1 (eg. if word is twice ...Created on 07 May 2013 -
Category: (MS 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 -
Category: (MS Windows)
What? This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first ...Created on 12 April 2013 -
Category: (MS Integration Services)
... the options in the connection manager will let you skip rows and specify column datatypes. You don't get that with Excel but you can still control the data range. How? My example is that I have ...Created on 04 April 2013 -
Category: (AutoHotkey)
... columns StringReplace,ReturnedHTMLTableColString,ReturnedHTMLTableColString,</td>,|,A IfInString,ReturnedHTMLTableColString,</th> StringReplace,ReturnedHTMLTableColString,ReturnedHTMLTableColString,</th>,|,A ...Created on 30 March 2013 -
Category: (MS 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 -
Category: (MySQL)
... that would replace my HTML tags <PRE> with <PRE CLASS="brush:php">. Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table ...Created on 03 February 2013 -
Category: (SQL)
... number, date) DATESUB(datepart, number, date) Other If-then-else IF( expression,value_if_true,value_if_false ) IIF( expression,value_if_true,value_if_false ) If Null IFNULL(column_name,value_if_null) ...Created on 31 January 2013 -
Category: (Transact SQL)
... have a string such as the following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the ...Created on 28 January 2013 -
Category: (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 -
Category: (Transact SQL)
... VARCHAR(MAX), @ColumnName VARCHAR(MAX), @WhereClause VARCHAR(MAX) = NULL ) AS /***************************************************************************************************************** ** ...Created on 07 December 2012 -
Category: (Transact SQL)
What? We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called ...Created on 05 November 2012 -
Category: (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 -
Category: (Transact SQL)
... 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and just leaves VALUE. Why? Do we need a reason? How? For SQL Server 2005 or later, using ...Created on 26 October 2012 -
Category: (Transact SQL)
... values (so not just case), and in this example, find typos as well, eg. "Daat ont Ety Aviable". How? Mine's a bit of a copout as it is a two-step process. I wanted a query that searched every column ...Created on 11 October 2012 -
Category: (Transact SQL)
... column we have setup default values, let's use the example "Data Not Yet Available". Unfortunately the end-user reported these default values sometimes list twice, especially when the case is different, ...Created on 10 October 2012 -
Category: (SQL)
... nvarchar(max); DECLARE @mySearchString varchar(50); SET @mySearchString = 'dnya'; DECLARE MyCursor CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE Latin1_General_CS_AS AS column1 FROM ' ...Created on 08 October 2012 -
Category: (Oracle SQL)
... Usage SELECT -- UFN_DATASCRAMBLE(DATE_CREATED, 'DATE') scramble_column, -- testing inputted column UFN_DATASCRAMBLE(0123456789012345, 'INT') random_integer, -- testing ...Created on 22 August 2012 -
Category: (Transact SQL)
... column names and data types into one string SELECT CASE WHEN CHARACTER_MAXIMUM_LENGTH IS NULL THEN ',' + COLUMN_NAME + ' ' + DATA_TYPE ELSE ',' + COLUMN_NAME + ' ' + DATA_TYPE + '(' + CAST(CHARACTER_MAXIMUM_LENGTH ...Created on 03 August 2012 -
Category: (Transact SQL)
... DECLARE @DateMatch int; DECLARE @TimeMatch int; DECLARE @ColumnTypeIsDate int; -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); ...Created on 01 August 2012