SSRS: Performance Improvements: SELECT TOPhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 a count). The dataset for this is the same as for DataSet1 but just the count is extracted: -- DataSet2: SELECT COUNT(*) AS myCount FROM PersonsTable WHERE (Reference = @GivenRef OR @GivenRef ='') AND (Forenames LIKE @GivenForenames + '%' OR...

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

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

26 October 2012 Table of three columns: ** ** - myValue: the distinct values ** ** - myColumn: the column this value was found in. ** ** - myCount: the number of times this value was found in this column. ** ** ** ** Link to other SQL Server collations:...

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

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

05 November 2012 to search) ** ** - myTable: table in which the column occurs ** ** (returned as "database.schema.tablename") ** ** - myCount: the number of records matching the value in this table. ** ** **...

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

T-SQL Conversion failed when converting the varchar to data type inthttp://mail.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 which needs to join the two tables so that we get the "MapOut" value: SELECT r1.MapIn ( SELECT (COUNT(e2.EmpType)-1) AS MyCount FROM DMExtractEmployeeTable e2 LEFT JOIN DMExtractReferenceTable r2 ON e2.CodeType=r2.MapIn -- THIS IS THE LINE CAUSING THE...

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

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

30 January 2011 b ) THEN CONCAT(a.`alias`, ( SELECT DISTINCT CASE WHEN COUNT(b.`alias`)>0 THEN a.`id` ELSE '' END AS myCount FROM `my_new_database`.my_prefix_menu b WHERE b.`alias` LIKE CONCAT(a.`alias`, '%') ) ) ELSE a.`alias` END AS alias, CONCAT( 'Imported from J15....

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

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

24 September 2015 to use it. How? Method #1: Add an alias to the field: -- Note the alias for the field SELECT COUNT( DISTINCT `my_field`) AS myCount FROM my_table; Method #2: Count from results (my preference): -- Note the alias for the table (select results) SELECT...

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