Wednesday, October 22, 2014
Text Size


Total: 59 results found.

Search for:
Search Only:

Page 1 of 3

  1. Category: (Transact-SQL)

    ... start with a function that just converts a string of words delimited by spaces to a table: CREATE FUNCTION dbo.[ufn_StringToTable] ( @StringInput VARCHAR(MAX) ) RETURNS @OutputTable TABLE ...
    Created on 20 August 2014
  2. Category: (XSLT)

    ... and strings but what if the value is blank and I try to convert that date of birth from SQL format (yyyy-mm-dd) to European format (dd/mm/yyyy)? See the following: <xsl:stylesheet version="1.0" xmlns:xsl=""> <xsl:output ...
    Created on 18 August 2014
  3. Category: (SITS:Vision)

    ... code and then the inner SRL text which should be <<field_code.entity>>|<<field_name.entity>>, if you try to apply you should be prompted to convert to use gold characters: Test ...
    Created on 12 August 2014
  4. Category: (MS Integration Services)

    ... convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around 12 lookups to do, so you could ...
    Created on 05 August 2014
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. Category: (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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  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 07 December 2012
  20. 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

Latest Posts

  • Convert to Proper Case in T-SQL

    • Tue 07-Oct-14
      Really comprehensive function. Nice work! Dave.
  • Joes Quicklist Weblinks (JQW)

    • Wed 08-Oct-14
      Thanks jazzmang! This module is due for an update so I'll review this issue in the next version.
    • Tue 07-Oct-14
      I've set "Display Images" under Module Settings but the modules continues to display a hard coded CSS ...
  • Joes Word Cloud (JWC)

    • Thu 16-Oct-14
      hello i use your tag cloud component in my joomla 2.5 website. i'm french and there is probleme with ...
    • Tue 07-Oct-14
      Hello, i have Joomla 2.5.27 and Module JWC v3.2.2 installed. In Configuration i fill in how many Word ...