Friday, August 01, 2014
   
Text Size
Login

Search

Total: 59 results found.

Search for:
Search Only:

Page 1 of 3

  1. Category: (Transact SQL)

    What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...
    Created on 04 June 2014
  2. Category: (MS Reporting Services)

    ... referring to converting strings to dates and incorrect data types. How? The fix is to simply get the field and both results to be of the same data type: =IIF(CStr(Fields!MyCompletionTime.Value)"", ...
    Created on 15 April 2014
  3. Category: (PHP)

    What? A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- ...
    Created on 27 March 2014
  4. Category: (MS Reporting Services)

    ... = @GivenRef OR @GivenRef ='') AND (Forenames LIKE @GivenForenames + '%' OR @GivenForenames = '') AND (Surname LIKE @GivenSurname OR @GivenSurname = '') AND (CONVERT(VARCHAR(10),DOB, 103) = @GivenDOB ...
    Created on 07 March 2014
  5. Category: (MS Windows)

    What? This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values ...
    Created on 15 November 2013
  6. Category: (MS Integration Services)

    ... the full process of packaging the script into a reusable component. Example #1: As an SSIS Script Task My solution so far: The following script will convert to lowercase and then capitalize ...
    Created on 04 October 2013
  7. Category: (General Web Development)

    ... Code Injection Do NOT allow the use of apostrophe or double-quotes, convert these to a numerical representation only if you need to convert them back later (eg. 034, 039). Do NOT allow any punctuation ...
    Created on 05 September 2013
  8. Category: (Transact SQL)

    ... n ON n.type = 'P' AND n.number < CONVERT(int, LEFT(CAST( DaysOffSick AS INT ),3)) -- yields EmployeeNo DaysOffSick DateOfSickness Items -------------- ...
    Created on 23 August 2013
  9. Category: (Transact SQL)

    What? A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read ...
    Created on 14 May 2013
  10. Category: (MS Integration Services)

    ... conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two ...
    Created on 14 March 2013
  11. Category: (MS Windows)

    ... 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
  12. Category: (PHP)

    ... comment if they do not: Surround string (apostrophes) with red styling Convert: this='a string'  »  this='a string' $string_formatted = preg_replace ( '/\'([^\']+)\'/', '<span ...
    Created on 07 February 2013
  13. Category: (SQL)

    ... '%d/%m/%Y') CONVERT(varchar, getdate(), 103) Time to Seconds TIME_TO_SEC(now()) (DATEPART(hour, getdate()) * 3600) + (DATEPART(minute, getdate()) * 60) + (DATEPART(second, getdate())) Seconds to ...
    Created on 31 January 2013
  14. Category: (PHP)

    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
  15. Category: (Transact SQL)

    ... 1, 0, REPLICATE('0', 3 - LEN(@RandMSeconds))); SET @TimeVal = CONVERT(time, @TimeVal, 14); END -- DETERMINE WHICH DATE PARTS WERE SUBMITTED  ...
    Created on 07 December 2012
  16. Category: (Transact SQL)

    ... = 0 BEGIN -- OPEN RandomID SET @random = CEILING(RAND()* CONVERT(VARCHAR(MAX),@NumberLeft) ) SELECT @ChosenID = MAX(ID ) FROM (SELECT TOP ...
    Created on 07 December 2012
  17. Category: (Transact SQL)

    ... @myXml = CONVERT(xml,'<root><s>' + REPLACE(@p_SearchColumns,',','</s><s>') + '</s></root>'); DECLARE Cursor1 CURSOR FOR SELECT [Value] = T.c.value('.','varchar(max)') ...
    Created on 26 October 2012
  18. Category: (Transact SQL)

    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
  19. Category: (Transact SQL)

    ... 1, 0, REPLICATE('0', 3 - LEN(@RandMSeconds))); SET @TimeVal = CONVERT(time, @TimeVal, 14); END -- DETERMINE WHICH DATE PARTS WERE SUBMITTED  ...
    Created on 01 August 2012
  20. Category: (MySQL)

    ...  ...do some more here ???... } } Yields -- Note this data matches the brief as we've converted the seconds to time. -- Using MySQL to convert rather than PHP so as not to ...
    Created on 27 April 2012

Latest Posts