-- Define a view to implement INITCAP in SQL Server CREATE VIEW InitCap AS SELECT REPLACE(REPLACE(REPLACE(REPLACE(Lower(s), '‡†', ''), '†‡', ''), '&'), '&', '&') AS s FROM q; -- Select from the view SELECT * FROM InitCap; -- Create a function for custom INITCAP logic (SVF) CREATE FUNCTION [dbo].[svf-Str-Proper] (@S varchar(max)) Returns varchar(max) As Begin Set @S = ' '+ltrim(rtrim(replace(replace(replace(lower(@S),' ','†‡'),'‡†',''),'†‡',' ')))+' ' ;with cte1 as (Select * From (Values(' '),('-'),('/'),('['),('{'),('('),('.'),(','),('&') ) A(P)) ,cte2 as (Select * From (Values('A'),('B'),('C'),('D'),('E'),('F'),('G'),('H'),('I'),('J'),('K'),('L'),('M') ,('N'),('O'),('P'),('Q'),('R'),('S'),('T'),('U'),('V'),('W'),('X'),('Y'),('Z') ,('LLC'),('PhD'),('MD'),('DDS'),('II'),('III'),('IV') ) A(S)) ,cte3 as (Select F = Lower(A.

How to Query Maximum Integer Value from Substring of Varchar Column with Condition Introduction In this article, we’ll explore a common SQL query problem where you need to extract the maximum integer value from a substring of a varchar column while applying conditions. We’ll dive into the technical details and provide examples for both MySQL and MS SQL Server. Understanding the Problem The question presents a scenario where you want to calculate the total maximum number of digits from a specific column (code) in a table, which is defined by the last five digits of another column (mybarcode).

Converting Time Series Dataframe to Input of Univariate LSTM Classifier Introduction The problem of converting a time series dataframe into an input for an univariate LSTM classifier is a common challenge in machine learning and deep learning applications. In this article, we will delve into the details of how to achieve this conversion and provide guidance on overcoming potential obstacles. Understanding the Time Series Dataframe A typical time series dataframe has the shape (n_samples, n_features), where n_samples is the number of data points in each row (i.

ggplot Kernal Density Plot Lines Overlapping Improperly The ggplot2 package in R provides a powerful and flexible way to create data visualizations. One of the most common types of plots is the kernel density estimate (KDE), which is used to visualize the distribution of a dataset. In this article, we will explore why the lines in a ggplot Kernal Density Plot can overlap improperly and provide solutions. Understanding Kernel Density Estimation Kernel Density Estimation is a non-parametric method for estimating the probability density function of a random variable.

Implementing Reordering and Deletion in UITableView Rows In this tutorial, we will explore how to implement reordering and deletion of rows in a UITableView in iOS. This involves using various techniques such as customizing the table view’s delegate methods, implementing a separate data model for each row, and utilizing animations to smoothly reorder rows. Understanding UITableView Delegates A UITableView is a built-in component in iOS that displays a list of items.

Understanding Area Charts and X-Axis Label Display Issues with Matplotlib In this article, we will delve into the world of area charts using matplotlib. We’ll explore how to create an area chart and why the x-axis labels are not displaying. Introduction to Area Charts An area chart is a type of chart that displays the cumulative total or accumulation of data points over a specific period. It’s commonly used in finance, economics, and other fields where trends need to be visualized.

Understanding SMS Sending on iOS: A Deep Dive Introduction Sending SMS programmatically on an iPhone can be a complex task, especially when working with the latest versions of iOS. In this article, we’ll explore the different approaches to achieve this, including using daemons and tweaks. We’ll also delve into the technical aspects of these solutions and provide code examples to illustrate the concepts. Background Before we dive into the details, let’s cover some background information on how SMS is handled on iOS.

Working with NaN Values in Pandas DataFrames ===================================================== When working with pandas DataFrames, it’s not uncommon to encounter missing or null values. In this article, we’ll explore how to count the number of leading NaN values in original columns and non-NaN values in extra columns. Introduction Pandas is a powerful library for data manipulation and analysis in Python. One of its key features is the ability to handle missing or null values.

SELECT DISTINCT to Return at Most One Row Introduction The problem statement is as follows: Given two tables, Regions and Customers, with the following structure: +----+-------+ | id | name | +----+-------+ | 1 | EU | | 2 | US | | 3 | SEA | +----+-------+ +----+-------+--------+ | id | name | region | +----+-------+--------+ | 1 | peter | 1 | | 2 | henry | 1 | | 3 | john | 2 | +----+-------+--------+ We want to write a query that takes two customer IDs, senderCustomerId and receiverCustomerId, as input and returns the region ID of both customers if they are in the same region.

Customizing ggplot2 Scales with a DataFrame Placeholder =========================================================== When working with the popular data visualization library ggplot2 in R, it’s often necessary to customize various aspects of the plot, such as the scales. One common requirement is to include a placeholder for a specific variable in the dataframe when naming a variable in a ggpacket() function. In this article, we’ll explore how to achieve this and provide examples to demonstrate its usage.