I'm  actually not entirely sure what you want as a result set here. What expected result set are you looking for? To show that the event runs from 20170803 -...

If your string is only going to contain the characters A-Z, a-z, or a space, then you can use this:
PATINDEX('%[^A-z ]%', [Your String])
That will return the position of...

Because it was bugging me about text/ntext columns, a slight amendment:
USE [YourDatabase];
GO

DECLARE @TableName varchar(250), @SchemaName varchar(250);
CREATE TABLE #NullColumns (SchemaAndTable varchar(250),
         ColumnName varchar(250),
         NonNullCount...

How are you executing the task, in SSMS? The PRINT statements appear in the Messages Pane, which appears below the Query Pane when you run your statement(s). If you have...

Although more complex, a much faster set-based Cursor that checks each table's columns all in one go, rather than each one individually (took 4 seconds to do 165 tables, instead...

This one is clearly a homework questions: https://www.sqlservercentral.com/Forums/FindPost1890108.aspx

What is truly "amusing" though, is they posted their homework question in Jeff's Forum Etiquette article on how to post...

A quick look at your first line, and [HX1Line] has a value of NULL. What should that contain, as there are no previously rows.

On the other hand, HXRLine...

I'm not entirely sure what your goal is here. Why can you not filter your result set when doing your JOIN? If, for whatever reason, you don't want to filter...

To create a Stored procedure is as simple as:
CREATE PROC dbo.HelloWorld AS
    SELECT 'Hello World' AS HelloWorld;
GO

So to return a dataset from a table uses...