Search
-
Category: (MySQL)
... a Server Instance, I'm going to specify the Take Parameters from Existing Database Connection option (note that I have obscured my personal settings in the following screenshot): In this screen, ...Created on 05 February 2013 -
Category: (Product Documentation)
... admin panel Install this module as per usual (will auto-install) Go to Extensions > Module Manager Paste the ID code you got from revolvermaps.com into the module parameter. Important Note: ...Created on 07 December 2012 -
Category: (General Joomla!)
... even when you have Search-engine-friendly website addresses enabled. How? Basically you have to include &view=article as opposed to Joomla v1.5.x when the option and id parameters would suffice: - ...Created on 04 December 2012 -
Category: (RokDownloads)
Admin Parameters include: + module class suffix + module width + text alignment + underline override + background to each word + background text color + background color + background border ...Created on 03 December 2012 -
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 -
Category: (SQL)
... Bit = 0 AS /* Parameters and usage @Tablenames -- Provide a single table name or multiple table name with comma seperated. If left blank , it will ...Created on 08 October 2012 -
Category: (Joomla! Tutorials)
... modal is a much easier way for the end-users to select a Joomla! article in the component parameters/options. The "clear" button is essential as some article_modal fields may not be required and are difficult ...Created on 27 August 2012 -
Category: (Oracle SQL)
... as you may know, Oracle has a funny way of working with dates which made this need to be changed. The following function now requires a second parameter where you specify the data type: CREATE OR REPLACE ...Created on 22 August 2012 -
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 -
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 -
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 -
Category: (MS Reporting Services)
... stored procedure in Oracle (and grant execute for your SSRS user) Add a data source to your SSRS report Add an SSRS input parameter Add a dataset Query type: Stored Procedure Refresh fields button ...Created on 19 January 2012 -
Category: (Oracle SQL)
... in a second query which we're hoping will be quicker than a straightforward table join. Syntax CREATE [OR REPLACE] PROCEDURE stored_procedure_name [ (parameter [,parameter]) ] IS | AS ...Created on 16 January 2012 -
Category: (Oracle SQL)
... AD name as user parameters. Syntax: CREATE [OR REPLACE] FUNCTION function_name [ (parameter [,parameter]) ] RETURN return_datatype IS | AS [declaration_section] BEGIN ...Created on 15 January 2012 -
Category: (MS Reporting Services)
What? I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a ...Created on 14 December 2011 -
Category: (MS Reporting Services)
... e.[Parameters] AS [Parameters] , e.[ByteCount] AS [Size] , e.[TimeDataRetrieval] AS [Data Retrieval] , e.[TimeProcessing] AS [Process Time] , e.[TimeRendering] AS [Render Time] , DATEDIFF(MILLISECOND, ...Created on 02 December 2011 -
Category: (MS Reporting Services)
... report (which searches for results matching the submitted parameter) to run. Lifted from Dattatray Sindol's blog Other sites have this solution as well so who copied off who is not my concern as ...Created on 17 November 2011 -
Category: (MS Reporting Services)
Intro If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and ...Created on 07 November 2011 -
Category: (MS Reporting Services)
... an account specifically created to run the stored procedure. This requires using 2 data sources in SSRS. A user will specify the student reference in the parameters of the first report (the one with ...Created on 04 November 2011 -
Category: (MySQL)
Why? I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count ...Created on 31 October 2011