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

11 October 2012 = @myCounter + 1; FETCH NEXT FROM Cursor1 INTO @SqlToExecute END CLOSE Cursor1; DEALLOCATE Cursor1; PRINT ' ) AS t1 GROUP BY column_value ORDER BY MIN(column_source)'; END Step 2 of 2 You now have a big SELECT query which you can copy, paste and run...

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

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

05 November 2012 + ''', COUNT(*) AS Count FROM ' + @TableToProcess + ' WHERE ' + @p_Column + ' = ''' + CAST(@p_Value AS VARCHAR) + ''' GROUP BY ' + @p_Column + ''; INSERT #CountRecordsPerTablePerCol EXEC(@SqlToExecute); FETCH NEXT FROM Cursor1 INTO @TableToProcess END...

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

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 to: - Microsoft Windows 7 Enterprise - User with Local Administrator Privileges (required for setup) Why? Our work has group policies and two of our programs, Visual Studio 2010 Ultimate (VS2010) and Business Intelligence Development Studio (BIDS),...

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

Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 are a variety of solutions that will fix this. However we have certain restrictions in my work environment thanks partly to group policies: Need to run with elevated permissions which requires UAC prompt (despite being already logged in, this is the...

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

T-SQL concatenate an incremental row numberhttps://www.joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 above still produces an error which can only be seen when using more records and more employees. PARTITION BY So a sort of "group" action will allow this if we add "PARTITION BY" to the ROW_NUMBER() statement: SELECT q.Employee AS EmployeeNo,...

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

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 strings: a b The expression does not match the characters: ab c Subexpression You can use the subexpression operator to group characters that you want to find as a string or to create a complex expression. For example, to find the optional string 'abc',...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

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

05 December 2013 on the Thursday. A few things we have to deal with still: We have lost the rows with days that have no events. We need to group by days so that each day only outputs one row (see Thursday). We want the earliest time and the latest time per morning and...

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

MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 BY n ) n WHERE n.n 5 AND TRIM(`value`) NOT IN ('Article','This',' ','content','component','applies','because','doesn''t') GROUP BY `value` ORDER BY `total` DESC LIMIT 0,50; Additional Note(s): I have added a WHERE clause which omits words less than 5...

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

Zoho Analytics: Set Up a Widget Displaying Sales Personhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-set-up-widget-displaying-sales-person.html

24 October 2022 on Widget in the top right Under "Data Column", select any field in your table/query which is not the one to display Under "Group By", select the field that has the value you want to display. Under "Show Value As", select Max Then click on the...

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

Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 "Macedonia"... Source(s): Wikipedia: Category: Compound surnames Diana, Goddess of the Hunt - Every-Name Index to Family Group Sheets: Mac / Mc Wikipedia: List of family name affixes

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

Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 Select Widget"; then under "2. Select Columns", I'm going to set "Data Column" to display the Maximum Date; then I want to "Group By" the image column, here labeled "Status Image": Then on the 2nd tab, I'm going to filter by my dataSource, which I've...

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

Zoho Workdrive: Getting Team Folder IDhttps://www.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 info "Workdrive Member Added: " + v_RecipientEmail; } Source(s): Zoho WorkDrive API Documentation - Share Files/Folders to Group Members

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

Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 to 100k) m_Params = {"select_query":"select Product_Name, COUNT(id) 'Frequency' from Products where Product_Name is not null group by Product_Name limit " + v_PerPage + " offset " + v_Offset}; r_CoqlUniqueProducts = invokeurl [ url...

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

About 5 seconds worth of funhttps://www.joellipman.com/articles/microsoft/sharepoint/about-5-seconds-worth-of-fun.html

21 November 2012 instances of MYDOMAIN, myusername and MY_SHAREPOINT_SITE accordingly). The moon to play with /_layouts/people.aspx?MembershipGroupId=# where # is the ID number of the group (will error on invalid IDs).

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

Joes Chart Generator (JCG) Downloadshttps://www.joellipman.com/component/content/article/joes-chart-generator-jcg-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions1.0+ Group all the data by a specified column + Generate interactive flash charts - Date Uploaded: Wed, 15th Sep 2010 Download

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

MySQL Transactions in PHPhttps://www.joellipman.com/articles/database/mysql/mysql-transactions-in-php.html

14 December 2016 Sometimes it is critical to ensure a group of queries are all executed successfully to maintain the integrity of our data. Let's say we have a banking app where we need to subtract funds from one account and add funds to another: $mysqli->query...

• Type: Article
• Author: Ike Francis
• Category: MySQL
• Language: en-GB