Saturday, November 01, 2014
   
Text Size
Login

Search

Total: 50 results found.

Search for:
Search Only:

Page 1 of 3

  1. Category: (MySQL)

    What? A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they ...
    Created on 22 October 2014
  2. Category: (Transact-SQL)

    Applies To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). ...
    Created on 07 July 2014
  3. Category: (MS Integration Services)

    ... and to populate a database table with this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column widths match. How? ...
    Created on 13 June 2014
  4. Category: (MS Reporting Services)

    Applies to: Microsoft SQL Server Reporting Services 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. ...
    Created on 15 April 2014
  5. Category: (MS Reporting Services)

    ... first column to display an image based on the status result. If I simply insert an image, the report would use the background color of the report. How? The issue exists if your image has transparent ...
    Created on 08 April 2014
  6. Category: (MS Reporting Services)

    ... column groups). The headers do not stay fixed at the top of the page anymore but then this isn't the show-stopper; being unable to see the bottom of the report was.  ...
    Created on 08 April 2014
  7. Category: (Transact-SQL)

    ... in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": <?xml version="1.0" ...
    Created on 27 March 2014
  8. Category: (Microsoft)

    What? A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...
    Created on 06 March 2014
  9. Category: (General Joomla!)

    ... and order the data (clicking on the heading of the column) by their parent_id. If you see more than one record with a value of 0, then change it to 1. If it's name is "root..." and title is "Root Asset" ...
    Created on 26 February 2014
  10. Category: (Uncategorised)

    ...  We have the first two columns of what we want to do. Now we need the same again but this time we want the morning slots SELECT DATE( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) DAY ) ) ...
    Created on 05 December 2013
  11. 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
  12. Category: (MS Integration Services)

    ... (do they ever?). The script must be able to be copied into other SSIS packages. Need the option to merely tick input column names rather than hardcode these. "It " should be an acronym for IT, so ...
    Created on 04 October 2013
  13. Category: (Transact-SQL)

    ... here and then just built on this. Method #1 I got this first query from the awesome site that is StackOverflow: SELECT * FROM INFORMATION_SCHEMA.COLUMNS Run this command against both databases ...
    Created on 24 September 2013
  14. Category: (MySQL)

    ...  -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; -- return all records that are non-alphanumeric but ignore underscores SELECT ...
    Created on 09 September 2013
  15. Category: (Transact-SQL)

    Applies to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that ...
    Created on 23 August 2013
  16. Category: (MySQL)

    What? So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be ...
    Created on 03 August 2013
  17. Category: (SQL)

    What? This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools). ...
    Created on 24 July 2013
  18. Category: (MySQL)

    What? Just a quick note to myself on how to reorder columns as I was having difficulty using a phpMyAdmin interface to do this. How? Taken from the best forum for programming Qs&As: http://stackoverflow.com/questions/4095481/easy-way-to-re-order-columns ...
    Created on 22 July 2013
  19. Category: (Transact-SQL)

    What? This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist: TABLE: Employee -------------------------------------------------- ID ...
    Created on 24 May 2013
  20. 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

Latest Posts

  • Basic Android App using Google Maps and Current Location

    • Thu 30-Oct-14
      Yes! finally a simple and working explanation. Thank you!
      l3000
  • Joes Quicklist Weblinks (JQW)

    • Mon 27-Oct-14
      Hi. I was able to download today with my laptop in a different location. Both computers using Ubuntu ...
      Webcrawler  
    • Sun 26-Oct-14
      Hmm... thanks Webcrawler! I can't replicate the error as all the links work for both my superuser ...
      Webmaster  
    • Sun 26-Oct-14
      Can't download new version. I get the same error message as Kat a few post's up.... CTRL+F5 does not ...
      Webcrawler
  • SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase

    • Tue 28-Oct-14
      This post was immensely helpful, thank you. I used the code for the script component and made some ...
      Dave L .