Saturday, July 26, 2014
Text Size


Total: 24 results found.

Search for:
Search Only:

Page 1 of 2

  1. Category: (Transact SQL)

    What? Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts ...
    Created on 07 December 2012
  2. 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
  3. 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
  4. 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
  5. 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
  6. Category: (SQL)

    ... - Sorna Kumar IF OBJECT_ID('usp_SearchDB','P') IS NOT NULL DROP PROCEDURE usp_SearchDB GO CREATE PROCEDURE usp_SearchDB @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60) ,@GenerateSQLOnly ...
    Created on 08 October 2012
  7. Category: (Oracle 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
  8. 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
  9. 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
  10. 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
  11. Category: (Oracle 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
  12. 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
  13. Category: (Oracle 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
  14. Category: (MS Reporting Services)

    ... that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored procedure, then ...
    Created on 04 November 2011
  15. Category: (MS Reporting Services)

    I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on ...
    Created on 11 October 2011
  16. Category: (WordPress)

    ... 3.X AS 'display_name' FROM my_joomla_db.jos_users a ORDER BY; A bit more to do: PHP file So I needed to do a loop and rather than complicate things with stored procedures and ...
    Created on 03 October 2011
  17. Category: (MS Reporting Services)

    ... add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512: at "SYS.DBMS_UTILITY", line ...
    Created on 02 September 2011
  18. Category: (General Web Development)

    ... classes and procedures? Confirmed any ACL/permissions on the files? Ensured all global, posted and session variables are present when they should be and behave properly? Broken down the ...
    Created on 03 June 2011
  19. Category: (General Articles)

    ... second (out of frustration) then that's 100 queries. Other Techniques Stored Procedures (I personally feel these have to include variable validation otherwise these are vulnerable no matter what ...
    Created on 05 April 2011
  20. Category: (General Web Development)

    ... Details on the Development Environment (is there a TEST system and deployment procedure in place?) Known Issues/Bugs (is there an "Issues Log"? Anything that still needs addressing?) System Requirements ...
    Created on 01 March 2011

Latest Posts

  • Joes Quicklist Weblinks (JQW)

    • Thu 17-Jul-14
      Hi, thanks a lot. But I have got a problem with download it. Error: "File could not be found Important!
    • Tue 15-Jul-14
      Hi Artur, I forgot to get back to you sooner. I was going to include a set of instructions to do this ...
    • Mon 14-Jul-14
      Hi Skarosg, Not sure if we took this to e-mail but I noticed your site is displaying the images now.
    • Fri 11-Jul-14
      Hi, How can I put user name and category of weblink in module, near the date? Thanks..
  • Joes Word Cloud (JWC)

    • Tue 17-Jun-14
      I'm using JE 3.1.19 stable.