Saturday, November 01, 2014
   
Text Size
Login

Search

Total: 39 results found.

Search for:
Search Only:

Page 1 of 2

  1. Category: (SITS:Vision)

    ...  In our example, our Type is "SQL db connector" and we use a stored procedure that the supplier helped setup along with the XML that will be sent to our database table. Be sure to use the same XET ...
    Created on 21 August 2014
  2. Category: (Product Documentation)

    ... on-the-fly without sending or receiving data to a server. The page used to be a part of a Password Security System I wrote back in 2008 and I missed the analysis capability so I have restored it on my ...
    Created on 03 January 2014
  3. Category: (MS Reporting Services)

    ... because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How? I'd like to say that the solution is far more complicated then this, but ...
    Created on 22 November 2013
  4. Category: (General Joomla!)

    ... to updating the core Joomla CMS. Ticking both options and then updating re-created the error. I restored the files (using a backup to overwrite the existing PHP files), leaving the database and images ...
    Created on 17 November 2013
  5. Category: (MS Reporting Services)

    ... webpage Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. Why? The problem happens because of ...
    Created on 11 November 2013
  6. Category: (MS Windows)

    ... article. In that, it restored all my photos and the default Apple apps, but missed out all my other apps (and audio). How? Note that the restore can be done when the new phone prompts you to set ...
    Created on 03 November 2013
  7. 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
  8. Category: (MySQL)

    ... to use the system you were given. Given a Relational Database Management System (RDBMS) where deleting some erroneous rows in one table will cause errors because the existence of those rows is stored in ...
    Created on 11 January 2013
  9. Category: (Transact-SQL)

    What? This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ...
    Created on 07 December 2012
  10. Category: (Transact-SQL)

    ... "WarehouseLoadKey" and the value we want to search on is "3" (the 3rd incremental load). How? The below stored procedure can be reduced to just a script as long as you declare and set the parameters ...
    Created on 05 November 2012
  11. Category: (Transact-SQL)

    What? Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the ...
    Created on 26 October 2012
  12. Category: (Transact-SQL)

    ... example which outputs a huge SQL query which you then copy & paste and run against your database. Step 1 of 2 The following stored procedure will generate the full query to your output panel: CREATE ...
    Created on 11 October 2012
  13. Category: (Oracle PL/SQL)

    What? How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing ...
    Created on 21 August 2012
  14. Category: (Transact-SQL)

    Why? Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the ...
    Created on 03 August 2012
  15. Category: (Transact-SQL)

    ... bottom of this page. Go go go Note that in the following examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it ...
    Created on 03 August 2012
  16. Category: (Transact-SQL)

    This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...
    Created on 01 August 2012
  17. Category: (MS Windows)

    ...  This file will be stored in the folder that you asked to list. Instead of C:\windows\system32\cmd.exe, I could have used %Comspec% or even %windir%\system32\cmd.exe but with some group policies, you ...
    Created on 19 July 2012
  18. Category: (Oracle PL/SQL)

    Why? We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return ...
    Created on 24 January 2012
  19. Category: (MS Reporting Services)

    What? So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting ...
    Created on 19 January 2012
  20. Category: (Oracle PL/SQL)

    Previously For a basic Oracle function, visit my article Basic Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in ...
    Created on 16 January 2012

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 .