Thursday, October 23, 2014
Text Size


Total: 51 results found.

Search for:
Search Only:

Page 1 of 3

  1. Category: (XML)

    ... white space (line feeds, tabs, spaces, and carriage returns) is handled Source(s):  ...
    Created on 13 August 2014
  2. Category: (MS Integration Services)

    ... to "Male", "Prof" to "Professor"). Why? Our extract phase in the SSIS package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will ...
    Created on 05 August 2014
  3. Category: (AutoHotkey)

    ... (AutoIt) and is the source code as compiling it wouldn't be much use to anyone else unless they work for the same company and they're leaving on the same date at the same time. Amend the "FinalDate" value ...
    Created on 17 July 2014
  4. Category: (Transact-SQL)

    ...  It might seem trivial but these little aesthetic changes done at the database level can save some time. Why? I have an Excel report which dynamically gets its content from a data source located ...
    Created on 07 July 2014
  5. Category: (MS Integration Services)

    ... connection manager but this is inefficient and not versatile enough to accommodate files that get added later. Why? I am creating an extract SSIS package intended to take a text file as its source ...
    Created on 13 June 2014
  6. Category: (Transact-SQL)

    ... @Ret = REPLACE(@Ret, ' Hr ', UPPER(' HR ')); -- Human Resources SET @Ret = REPLACE(@Ret, ' It ', UPPER(' IT ')); -- Info Tech Services -- specify exceptions to be custom cased: McDonalds, Mc Donalds IF(@Ret ...
    Created on 04 June 2014
  7. Category: (MS Reporting Services)

    ...  Restart the SSRS service Source(s) Microsoft: RSReportServer Configuration File MSSQLTips: Prevent SQL Server Reporting Services Slow Startup  ...
    Created on 11 April 2014
  8. Category: (MS Windows)

    ... have no security tab/setting. Source(s): How to hide drive for specific users in Windows 7? How to Hide or Unhide a Drive in Vista and Windows 7  ...
    Created on 28 March 2014
  9. Category: (Joomla)

    ... PlayThru Source(s): ...
    Created on 20 March 2014
  10. Category: (General Joomla!)

    What? Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which ...
    Created on 28 February 2014
  11. Category: (MS-Dos)

    ... MS-DOS because I'm that old. Robust File Copy: Open a command prompt (Start > Run... > CMD > ok) Type the following: ROBOCOPY c:\Sourcepath c:\Destpath /E /XC /XN /XO -- /E makes Robocopy recursively ...
    Created on 23 February 2014
  12. Category: (Joomla)

    ... that comes with Joomla 2.5 install. How? Source: Joomla! • View topic - Cannot get recaptcha to display on registration form... There are two solutions I have found that fix the problem: ...
    Created on 24 November 2013
  13. Category: (MS Reporting Services)

    ... to other systems holding the images), then please refer to my article on SSRS External Images don't display. The answer to this error is your report needs to use a datasource with the credentials ...
    Created on 22 November 2013
  14. Category: (Static Items)

    ... based on the initial requirements up to and including the User Acceptance Testing (UAT) date (not yet agreed, but about a week prior to release date). JoelLipman.Com will make the source files available ...
    Created on 15 November 2013
  15. Category: (MS Reporting Services)

    ... the data source used in the report. For static data source connections, this is straightforward but in our case, we have a report which points to different servers based on a report parameter. How? ...
    Created on 11 November 2013
  16. Category: (SQL)

    ... only one--occurrence of the preceding character or subexpression. You can think of this operator as specifying an expression that is optional in the source text. For example, to find--'a', optionally ...
    Created on 28 October 2013
  17. Category: (MS Integration Services)

    ... people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if this could be restored to a normal ...
    Created on 04 October 2013
  18. Category: (MS Integration Services)

    What? This is a quick article to remind me on how to skip blank rows when using a Flat file as a data source. I would receive another Microsoft error as clear as mud: Error: The conditional operation ...
    Created on 23 April 2013
  19. Category: (MS Integration Services)

    What? A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then ...
    Created on 04 April 2013
  20. Category: (Web Development)

    Just a pretty picture on how hackers have created an infographic of the internet: Source: BitBucket.Org - Internet Census 2012  ...
    Created on 27 March 2013

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 ...