Search - Joel Lipman .Com

1. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... 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? Method #1: Add ...; Created on 24 September 2015
2. Stored Procedure to List Distinct Values and Counts: / Transact-SQL /; What? 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 ...; Created on 26 October 2012
3. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... How? 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 ...; Created on 12 July 2023
4. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Art::4 creative, expressive, detailed, colorful, stylized anatomy, digital art, 3D rendering, unique, award-winning, Adobe Photoshop, 3D Studio Max, V-Ray, professional, well-developed concept, distinct ...; Created on 11 February 2023
5. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... 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."Produc ...; Created on 03 November 2022
6. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... 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 ...; Created on 08 October 2021
7. Search a database for a value and count matching rows: / Databases /; ... WHILE @@FETCH_STATUS = 0 BEGIN SET @SqlToExecute = ' SELECT DISTINCT ' + CAST(@p_Value AS VARCHAR) + ', ...; Created on 05 November 2012
8. Search a database with SOUNDEX: / Databases /; ... ' SELECT DISTINCT t1.column_value COLLATE Latin1_General_CS_AS AS Value, MIN(t1.column_source) AS Source, COUNT(t1.column_value) ...; Created on 11 October 2012
9. T-SQL example of Case-Sensitive Soundex: / Transact-SQL /; ... Daat oNt EYt Avialable D300 This is obviously 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 ...; Created on 10 October 2012
10. Search a database for a string (MySQL, T-SQL): / Databases /; ... 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": /* USING A CURSOR */ DECLARE @SqlToExecute nvarchar(max); DECLARE ...; Created on 08 October 2012
11. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; ... 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 ...; Created on 27 April 2012
12. SSRS Hide results table if empty: / SQL Server Reporting Services /; ... 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 ...; Created on 29 March 2011
13. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... SELECT DISTINCT b.menutype FROM `my_new_database`.my_prefix_menu_types b) ...; Created on 30 January 2011
14. Creating a Top 10 chart with less code: / Personal Home Page /; ... that the most frequent is at the top of 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 ...; Created on 18 February 2010
15. Header (Flex): Created on 30 December 2017
16. Modals: Created on 17 April 2017
17. Tabs: Created on 17 April 2015