Assuming open is required, the following 113 results were found.
-
were putting different values in both fields and getting twice as many rows back. I modified the report leaving only one open parameter, the OR clause just compares against the same parameter. So for example: Instead of......
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
with our detailed report page which lists all the details of a student. There is a textbox linked to an action which will open another report (the confirmation page) and pass through 2 parameters (the Student ID and the Job ID [for audit purposes]). The...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
of "Fixed headers while scrolling". How? Once I figured out why I had a scrolling issue, the reverse was easier to work out: Open the Report in Design mode. Check that advanced mode is switched on as per the following image: Cycle through each static...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
"Yes". How? The gist is that we're going to create a scheduled task (that won't be scheduled) and a shortcut to that task: Open the Task Scheduler (Start > Run... > Type taskschd.msc > OK) - You will need administrator rights for this step. Click on...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
via the run command, or used in a desktop shortcut, or that you want to include in automation software such as AutoHotkey, opens any specific Windows OS settings page. This does not make the change to the setting itself, just displays it to the user for...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
AS Value, MIN(t1.column_source) AS Source, COUNT(t1.column_value) AS Count FROM ( '; -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @SqlToExecute WHILE @@FETCH_STATUS = 0 BEGIN IF @myCounter=0 PRINT @SqlToExecute; ELSE PRINT '...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
CREATE TABLE #CountRecordsPerTablePerCol (myValue int, myTable varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @TableToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' +...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
click the Options page. From the Restrict Access option, select Single. If other users are connected to the database, an Open Connections message will appear. To change the property and close all other connections, click Yes. Restoring in SSMS,...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
'DefaultString' COMMENT 'A Comment' AFTER other_column; Alternatively Export the file as a SQL file (data & structure), Open it using a text editor Modify the order of the columns, for example: -- From CREATE TABLE IF NOT EXISTS `Table1` ( `Column1`...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
TABLE #ListDistinctValuesAndCounts (myValue varchar(max), myColumn varchar(max), myCount int); -- Iterate through cursor1 OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @ColToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' +...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
cursor c1 is select student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if; close c1; RETURN student_no; EXCEPTION WHEN...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
OR REPLACE PROCEDURE sp_get_studentdetails_from_ad ( c_test out sys_refcursor, p_STUDENT_ADNAME in varchar2 ) IS BEGIN OPEN c_test FOR SELECT * FROM student_accounts WHERE student_username = p_STUDENT_ADNAME; END; View the results? Oracle PL/SQL is a...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
or move the JAR file (at time of print: mysql-connector-java-5.1.22-bin.jar) to the folder of your SQL Developer program Open SQL Developer, go Tools > Preferences > Database > Third Party JDBC Drivers and click on Add Entry... Select the JAR file you...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
how to do it. Personally, even a web-based app such as PhpMyAdmin would fare better. How? So this is the HOME tab when you open MySQL Workbench. We're going to go on the basis that you already setup a connection to your database under the SQL...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
and Errors List Issues List Create an excel spreadsheet that all involved can modify date entered description owner status (open, in progress, closed)? solution date resolved Errors List Clear error logs Refer to list of all pages and run each one...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
embed a specific video manually. Will update this if ever a free method for embedding the page comes up. Go to Instagram and open the video/picture to embed Click the 3 dots (ellipsis) at the bottom right of the description. Click Embed From the box...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
' ', $str); // replace any asterisk signs with a single-space $str = str_replace("(", ' ', $str); // replace any open parenthesis with a single-space $str = str_replace(")", ' ', $str); // replace any closing parenthesis with a single-space $str =...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
the field back into "Report Filter" Done! The filter dropdown should retain the order. Alternatively Similar to the above, open a Microsoft product Bang "Head" against wall. Bang "Head" against wall. Bang "Head" against wall. Alternatively Change the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Kunena forum This is what the official Kunena documentation says: Installing another Template Download the Template package. Open your FTP Connection and go to \components\com_kunena\template\ Extract the folder "Template Name" into this directory ^ If...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *