Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming want is required, the following 280 results were found.

  1. SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I want the report to be run with the 3rd and 4th parameter as OPTIONAL. When I leave the 3rd and 4th parameter untouched (=""), the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  2. Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/component/content/article/returning-oracle-stored-procedure-resultset-in-ssrs.html?catid=75&Itemid=165

    student_accounts WHERE student_accounts.student_username = p_STUDENT_ADNAME; -- opening cursor for the select query that I want to display in SSRS OPEN l_CURSOR FOR SELECT INITCAP(b.p_title) || ' ' || INITCAP(b.p_forenames) || ' ' || UPPER(b.p_surname)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  3. SSRS Stop Scrolling Behindhttps://www.joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

    of the dataset. Why? A lot of articles out there on the net are offering solutions that do the exact opposite. Basically, I want the opposite result of "Fixed headers while scrolling". How? Once I figured out why I had a scrolling issue, the reverse was...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB

  4. Remove write-protect from USB pen in Windowshttps://www.joellipman.com/component/content/article/remove-write-protect-from-pen-in-windows.html?catid=80&Itemid=165

    check the space, my 30Gb has returned!!! It’s called Urescue and it’s become my favourite program (despite the fact that I want to need to use it as little as possible, i.e. once)!!! To find it go to http://emea.apacer.com/en/support/downloads.asp then...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: en-GB

  5. Windows 10: Shortcut Apps to Settingshttps://www.joellipman.com/component/content/article/windows-10-shortcut-apps-to-settings.html?catid=80&Itemid=165

    10 Pro v10.0.18362 What? This is a list of apps that if run 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *

  6. Search a database for a string (MySQL, T-SQL)https://www.joellipman.com/articles/else/database/search-a-database-for-a-string-mysql-t-sql.html

    with X %X--- will give data ending with X %X%--- will give data containig X @GenerateSQLOnly -- Provide 1 if you only want to generate the SQL statements without seraching the database. By default it is 0 and it will search. Samples : 1. To search data...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB

  7. DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/else/database/t-sql/data-shuffling-function.html

    but switches their order randomly, so I've renamed it DataJumble as opposed to my article on Data-Scrambling. Why? We want to scramble sensitive data that we send to suppliers for support or analysis. With inspiration from: "Obfuscating your SQL Server...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  8. Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/else/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

    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 following stored procedure (or part of). What? This will copy...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: *

  9. T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    in our default values. Additional Note how this also picked up typos in the 4th value which is good as I didn't want to overcomplicate things using LEVENSHTEIN and DIFFERENCE: SOUNDEX('Data Not Yet Available') = SOUNDEX('Daat oNt EYt Avialable')

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  10. T-SQL: Parse an XML valuehttps://www.joellipman.com/articles/else/database/t-sql/t-sql-parse-an-xml-value.html

    Gender FROM [dbo].[XML_EVENTS] -- Returns column GENDER for every record/row (eg. "Male") Extracting the attribute: Here we want to extract an attribute value SELECT CAST(CAST(Event_XML AS XML).query('data(/STAFF/CURRENT_EMPLOYEE/@financialyear)') AS...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  11. T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/else/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

    = RTRIM(LTRIM(@StringInput)) INSERT INTO @OutputTable ( StringValue ) VALUES ( @StringValue ) END RETURN END Now we want to modify this slightly so that it converts a string of words delimited by pipes to a table: CREATE FUNCTION...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  12. Basic Oracle Function Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-function-structure.html

    overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function in it's simplest form and if I want to torture my successors, I'll complicate the function myself. How? Functions are supposed to return a single value, which...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  13. No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/else/database/oracle-pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

    result set. Furthermore I am using this stored procedure in a SQL Server Reporting Services (SSRS) environment and don't want to return any rows if there are no matches (not a blank row either) as one of my reports uses a row counter to display a "No...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB

  14. Database Error: Unable to connect to the database: Could not connect to MySQLhttps://www.joellipman.com/articles/else/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

    found that even with captcha features, still get hacked with viagra emails and what have you (eg. JoomlaBook). If you don't want to go through the logs, try setting up a test joomla site with a different database and user and see if that behaves the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  15. MySQL: Find records in one table that are not in another.https://www.joellipman.com/articles/else/database/mysql/mysql-find-records-in-one-table-that-are-not-in-another.html

    audit trail of content approvers on the system. Approvers can e-sign an article (approving it) by clicking on a button. We want to bring back the articles that aren't listed in the audit table (articles yet to be approved). So this will be based on the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  16. Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

    faffing! Here's a script I used to generate the SELECT query. If you run it, it should return the additional 52 rows we want add. Note that the table "WeekStructure" could have been any table with more than 52 rows, I'd say specify the table you will...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  17. Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/else/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

    before the first comma. Consider the following, the first query is how MySQL interprets the query and the second is what I want it to do: SELECT value FROM my_table WHERE my_id IN ('1, 2, 3') SELECT value FROM my_table WHERE my_id IN ('1', '2', '3') The...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  18. Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/else/database/mysql/quickly-update-all-content-replacing-a-string.html

    data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch these back. How? For demo purposes, I'm searching a column called introtext in a database table called...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  19. Export/Import Database using MySQL Workbenchhttps://www.joellipman.com/articles/else/database/mysql/export-import-database-using-mysql-workbench.html

    my personal settings in the following screenshot): In this screen, I've opted for Do not use Remote Management as I only want to export/import my database: Connected! Now click on Data Export in the left hand panel: In the screen that appears, select...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB

  20. mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/else/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

    the problem. When you read my workaround, you'll say that I haven't solved anything; but this is a production database I want to export for offline backup. I have to raise and log a formal change request and follow a workflow process in order to make a...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
Results 221 - 240 of 280