Monday, April 21, 2014
Text Size


Total: 50 results found.

Search for:
Search Only:

Page 1 of 3

  1. 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
  2. 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
  3. 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
  4. 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": <STAFF xmlns:xsi="">  ...
    Created on 27 March 2014
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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: ...
    Created on 22 July 2013
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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

Latest Posts

  • 301 Redirect using htaccess file

    • Tue 15-Apr-14
      Further suggestion:
      RewriteRule ^(.*/)?assets/s 2dmain.html\?/( .*/)? $2 [R=301,L]
    • Thu 10-Apr-14
      Playing with some RegEx testers
      RewriteRule ^(.*\?/)?(?:$|( .+?)(?:(\.[^.]$ )|$)) $2 [R=301,L] ...
    • Wed 09-Apr-14
      I tried to redirect links from my old site to my new site, based on what I read in this thread. The old ...
  • Joes Revolver Map (JRM)

    • Sun 20-Apr-14
      Hello, is it possible to use this module also in joomla 3.2? Thanks Manfred
      Manfred V.
  • K2 Items disappear

    • Thu 03-Apr-14
      The fix works great, but the problem is occurring a couple of times a day. Any idea how to fix ...
      Larry C.