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

  1. Stored Procedure to List Distinct Values and Countshttps://joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

    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 columns. How? IF...

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

  2. SELECT COUNT(DISTINCT name) FROM tablehttps://joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

    but within the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How?...

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

  3. Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

    INSERT INTO `my_new_database`.my_prefix_menu_types (menutype, title, description) SELECT CASE WHEN a.menutype IN ( SELECT DISTINCT b.menutype FROM `my_new_database`.my_prefix_menu_types b) THEN CONCAT(a.menutype, ( SELECT DISTINCT (COUNT(b.menutype) +...

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

  4. Zoho CRM: Get Unique Values of a Text Fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

    and ZohoCRM.modules.ALL Build up a SQL query, or more specifically, a COQL - CRM Object Query Language Try using distinct on a single-line text field Adapt the query for unique values in a lookup field I won't demonstrate how to set up a connector as...

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

  5. Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

    refer to it later for shipping charges and other discrepancies. I'm calling this dataset "My Purchase Order Items" SELECT DISTINCT po."Purchase Order Date" AS "PO Date", po."Purchase Order Number" AS "PO Ref", poi."Product ID" AS "PO Product ID",...

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

  6. Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

    My team of developers actually helped me solve this one as I was slowly dispairing... The Plan Get a list of all unique/distinct Customers Get a list of all Customers Remove the list of unique ones from the "all" list to be left with just the...

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

  7. Select unique values in Microsoft Excel columnhttps://joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

    Thought I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range...

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

  8. Creating a Top 10 chart with less codehttps://joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

    the list print out each row with the number of times that particular data appeared in a row My old method was to: Select distinct column1.table1 FROM table1 PHP script would loop through all rows of the above mysql query Count for each row how many...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *

  9. SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

    expression. T-SQL Expression: Consider the following expression as the one we use to get the equipment information: SELECT DISTINCT re.[RoomId] ,re.[SiteId] ,re.[EquipId] ,eq.[Description] FROM [ROOMEQUIPMENT] re INNER JOIN [EQUIPMENT] eq ON...

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

  10. MySQL: Display Users and Duration in Matrix Timesheethttps://joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

    to let PHP do a bit more of the work: User Query $t_value = $the_team_id_that_i_want_to_look_at; $user_list_query=" SELECT DISTINCT u.UserID, CONCAT(u.FirstName, ' ', u.LastName) AS 'Fullname' FROM Users u WHERE u.StatusType NOT IN...

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

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

    a simplified table as it doesn't tell us much but it is just for demo purposes. Consider the following query: SELECT DISTINCT StudentDetail FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data Not Yet Available') -- yields StudentDetail...

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

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

    Note that the below only prints out the SQL query to copy and paste into your SQL administration software. You can put a distinct on it (not forgetting the collate). This example is expanded in a further article called "Search a database with soundex":...

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

  13. Search a database with SOUNDEXhttps://joellipman.com/articles/database/search-a-database-with-soundex.html

    'text', 'ntext') AND TABLE_SCHEMA=@p_TableSchema ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME; PRINT ' SELECT DISTINCT t1.column_value COLLATE Latin1_General_CS_AS AS Value, MIN(t1.column_source) AS Source, COUNT(t1.column_value) AS Count FROM ( '; --...

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

  14. Search a database for a value and count matching rowshttps://joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

    OPEN Cursor1 FETCH NEXT FROM Cursor1 INTO @TableToProcess WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + CAST(@p_Value AS VARCHAR) + ', ''' + @TableToProcess + ''', COUNT(*) AS Count FROM ' + @TableToProcess + ' WHERE ' +...

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

  15. Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

    art, 3D rendering, unique, award-winning, Adobe Photoshop, 3D Studio Max, V-Ray, professional, well-developed concept, distinct personality, consistent style::3 deformed, simple, undeveloped concept, generic personality, inconsistent style::-2...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
Results 1 - 15 of 15

Joes Word Cloud

Please publish modules in offcanvas position.