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 table is required, the following 120 results were found.

  1. The ReportServer Databasehttps://www.joellipman.com/articles/else/database/the-reportserver-database.html

    NULL The ID of the report (looks like a hexadecimal SSID). It's the unique ID of the report but not unique in the table (can be referenced many times). UserName nvarchar(260) NULL Windows authenticated username and domain of the person running the...

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

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

    a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table "XML_EVENTS": 123456 Mr J JOEL LIPMAN MALE 1990-01-01 SUPER SUPPORT TEAM GENERAL DOGSBODY 2014-03-01 Y INSERT 2014-03-27...

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

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

    REPLACE] FUNCTION function_name [ (parameter [,parameter]) ] RETURN return_datatype IS | AS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [function_name]; Example: My example accepts an Active Directory (AD) username...

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

  4. SQL Queries for Statisticshttps://www.joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

    5 columns: MediaWiki: number of unique guests, students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT CONCAT(MONTHNAME(t2.Date), ' ', YEAR(t2.Date)) Month, SUM(IF(t2.VisitorType='Staff', 1, 0))...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

  5. 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

    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 MYTABLE_content. First let me find all the articles that need this change: SET @stringtoFind=' '; SET...

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

  6. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    11:50:00 -- 2013-12-05 Thursday 10:00:00 11:30:00 -- 2013-12-06 Friday 07:00:00 09:00:00 This example is using a small table with very little sample data so do not expect it to reconcile with the requirement example. Note that we have two events on the...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

  7. CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/cms/website-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

    Item 1d 2. Item 2 How? I've been refining this based on several examples and the following solution seems to be the most stable: ol { list-style-type: none; counter-reset: myCounter; display: table; margin: 0; padding: 5px 0 5px 15px; } ol > li {...

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

  8. UTF8 Unicode PHP MySQL for International Charactershttps://www.joellipman.com/articles/cms/website-development/php/utf8-unicode-php-mysql-for-international-characters.html

    extension using the mysql Joomla! classes, here's how I've used in this script pulling IDs and titles from the a sample table: $db =& JFactory::getDBO(); $sql_utf8 = "set names 'utf8'"; $db->setQuery( $sql_utf8 ); $temp_result = $db->query(); $sql =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB

  9. Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=105&Itemid=165

    Order by Weblink ID - Date Uploaded: Thu, 2nd May 2013 2.1.2 - Moved "More Links" text to Joomla language file (translatable) - Date Uploaded: Sun, 10th Mar 2013 2.1.1 - Corrected alias reference to all columns irrespective of order settings. - Link for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *

  10. MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

    This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first column) and the days of the week along the top. Why? The...

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

  11. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    store prompts for the MidJourney AI text-2-image discord tool. Why? The results from the MidJourney bot are beyond unpredictable however with the correct prompts you can direct it to focus on the elements you want from a brief. How? A "prompt" is a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *

  12. Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

    reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected item and filtering the options available for selection. Why?...

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

  13. Forgotten Super User Password in Joomla 2.5.x - 3.xhttps://www.joellipman.com/articles/cms/joomla/forgotten-super-user-password-in-joomla.html

    known to you (create a new joomla user if necessary). The gist: Login to your Joomla database Go to the #__users database table (where #_ is the prefix to your joomla tables) Find the column password and the row of your known user and Copy the text...

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

  14. Trim in T-SQL and SSIShttps://www.joellipman.com/component/content/article/trim-in-t-sql-and-ssis.html?catid=74&Itemid=165

    Using it to compare to a value? There are cases in T-SQL where the trim is unecessary and a similar equation can be written: Table: DMExtractEmployeeTable ID ForeName SurName --------------------------------- 1 Joel Lipman 2 JOE THE GREATEST DECLARE...

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

  15. Regular Expressions in SQLhttps://www.joellipman.com/articles/else/database/regular-expressions-in-sql.html

    how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`. Oracle PL/SQL Looking for abnormal data, note the circumflex to exclude the clean alphanumeric rows:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *

  16. Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/else/database/oracle-pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

    A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: *

  17. Increment a column in MySQL using the UPDATE queryhttps://www.joellipman.com/articles/else/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

    Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1...

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

  18. Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/else/database/mysql/search-and-replace-in-a-mysql-database.html

    well that's usually me. Found it a bit boring but here's a short bit of code to speed it up which I now use: update table_name set field_name=REPLACE(field_name,'string_to_find','string_to_replace'); Source:...

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

  19. Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/component/content/article/convert-decimal-person-days-to-time-in-excel.html?catid=110&Itemid=165

    which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of person days in the...

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

  20. Prices get rounded up in Virtuemarthttps://www.joellipman.com/articles/else/e-commerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

    to convert any number to a currency or two decimal places. Another suggestion was to alter the main virtuemart database table (jos_vm_prodcut_price)... Don't do any of these things! After modifying tax rates and ensuring these were all the same, we also...

    • Type: Article
    • Author: Joel Lipman
    • Category: Virtuemart
    • Language: *
Results 101 - 120 of 120