Monday, November 24, 2014
   
Text Size
Login

Search

Total: 59 results found.

Search for:
Search Only:

Page 1 of 3

  1. Category: (Microsoft)

    ... to convert: A B ------------------------------------- ---------------------- Beijing Capital International Airport 40°4′20″N 116°35′51″E Beijing Shahezhen ...
    Created on 06 November 2014
  2. Category: (Application Development)

    ... position, View convertView, ViewGroup parent) { ViewHolder holder; if (convertView == null) { convertView = View.inflate(context, R.layout.rss_item, null); holder ...
    Created on 24 October 2014
  3. Category: (Product Documentation)

    ... 0.9: Last Modified 2014-11-05 12:08:42 ccTLD is assigned from an entry within searched location (db must return at least 1 zone to know what country it is in - future development will be separate: convert ...
    Created on 24 October 2014
  4. 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
  5. 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="http://www.w3.org/1999/XSL/Transform"> <xsl:output ...
    Created on 18 August 2014
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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

Latest Posts

  • Convert to Proper Case in T-SQL

    • Tue 11-Nov-14
      Hi Brandon, An excellent point as I completely forgot about that one. I guess in the UK we don't get ...
      Joel L.  
    • Thu 06-Nov-14
      Thank you for this! One of the cases I'm going to try to adapt it for is addresses. In the US, we ...
      Brandon C.
  • SSIS: How to loop through multiple flat files as data sources

    • Thu 13-Nov-14
      Hey Mario, Looks like for each loop you set up at #5 will take care of that, doesn't matter if you ...
      Ramsey K.  
    • Sat 01-Nov-14
      Hi, thanks, bit not clear on #6, I still have file name from step #1
      Mario17
  • Windows 7: System Clock is constantly going out of sync

    • Sat 01-Nov-14
      Thank you..that solved my issue. Just wondering whether preventing my computer from synchronizing ...
      Ravi G.