How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/component/content/article/how-to-display-report-execution-time-in-ssrs.html?catid=75&Itemid=165

17 November 2011 would need delete your current datasets then add them in the order you want them to load) to get the timestamp of when the queries started. IIF your result row count, if it's zero, just display blank, else, do the rest of the query. Blank out the...

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

Connection Strings for SQL Serverhttps://www.joellipman.com/component/content/article/connection-strings-for-sql-server.html?catid=78&Itemid=165

05 January 2011 "memory" to use MySQL shared memory. Specifying character set Use this one to specify which character set to use to encode queries sent to the server. Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; CharSet=UTF8; Note that...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

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

08 August 2011 recorded ByteCount bigint NOT NULL Size of rendered reports in bytes. RowCount bigint NOT NULL Number of rows returned from queries. Conversions Needed: I want to convert a start and end date to a single time value (hours minutes seconds mseconds) I...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/else/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 -- used to get the time of the event e.EventDate, --event details to display e.Note --CTEs defined above are used as the queries for the results FROM Dates d LEFT JOIN Events e ON CAST(CONVERT(VARCHAR(10),e.EventDate,101) AS DATETIME) = d.[Date] --Set...

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

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

15 January 2012 Directory (AD) username and receive a student ID number instead, all with the aim to improve performance on some SSRS queries which accept either an ID number or an AD name as user parameters. Syntax: CREATE [OR REPLACE] FUNCTION function_name [...

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

Joes Word Cloud (JWC) Downloadhttps://www.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=105&Itemid=165

07 September 2015 compatibility. - Functions for stripping keywords merged into one. - Date Uploaded: Mon, 14th Mar 2011 1.5.0 - Merged all queries for checking 3rd-party content into one SQL query. - Added Joomla! Admin Option: Display SQL query sent to Database. -...

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

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

24 September 2015 DISTINCT my_field FROM my_table) T1; Ones that didn't work for me: Method #3: By grouping (NOT recommended for more complex queries): SELECT COUNT(my_field) FROM my_table GROUP BY my_field; Additional: Not sure why method 3 is an accepted answer over...

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

Comparing two mediawiki siteshttps://www.joellipman.com/articles/cms/mediawiki/comparing-two-mediawiki-sites.html

17 September 2010 In this particular case, I'm comparing my Live and Dev versions of the same MediaWiki site. I want to add the SQL queries I used to this article but I'm in the middle of carrying out this process and it's due in two hours. Checking both MediaWiki have...

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

MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/else/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 3 I -- to be returned as RowID my_field_name --------- -------------------------- 1 Me,Myself,I Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table then using data...

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

Code Troubleshooting Checklisthttps://www.joellipman.com/articles/cms/website-development/code-troubleshooting-checklist.html

03 June 2011 In a database/web environment, have you? Commented out lines that you suspect might be the problem? Able to run the SQL queries directly against the database? Matched the datatypes received/returned by functions, classes and procedures? Confirmed any...

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