WordPress: Fatal error after upgrading User online (wp-useronline) plugin

When I upgraded the User Online plugin (wp-useronline) a short while ago, I got a Fatal Error: Fatal error: Call to undefined method scbOptions::get_key() in …/wp-content/plugins/wp-useronline/admin.php on line 56 I looked on Google and found the WordPress Support page http://wordpress.org/support/topic/396809 and renamed the plugin folder “wp-useronline” to “xwp-useronline”. I then went to the Plugins page […]

SQL: Red Gate’s SQL Search

Hi. I have just downloaded Red Gate’s FREE SQL Search tool from http://www.red-gate.com/products/SQL_Search/index.htm Features: Find fragments of SQL text within stored procedures, functions, views and more Quickly navigate to objects wherever they happen to be on your servers Find all references to an object Integrates with SSMS Why use SQL Search? Impact Analysis You want […]

SQL: Median function for SQL Server

I have been using a Transact-SQL query (see Method 1 – Update entire table below) to get the Median “Order Value” for an entire list of Customers. However, due to the quantity of data, it was taking for ever.

Therefore, this morning I decided to write a SQL Server User Defined Function (see Method 2 – Function below) [1. Please ensure you test any script taken from my website on a test/development machine, before running on a production server.] to update the Median Order Value for a single Customer. I then used a UPDATE query to update all of the customers. This took a lot less time to process 🙂

SQL: REPLACE Multiple Spaces with One

I have just found a very useful article from SQLServerCentral.com, that goes through the process of replacing multiple spaces with one. “Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here’s a set based method for replacing multiple spaces from MVP Jeff Moden” http://www.sqlservercentral.com/articles/T-SQL/68378/

CJayMead's SQL Server, Endeca, MS Office Help © 2018