Btw, you don't seem to realize that you are not including the last day of the month in the Calendar table.

CREATE OR ALTER VIEW Test
AS
SELECT * FROM...

That join will work fine too.

Try an ORDER BY C1.RowNum so that you can see the matches between rows, if any, in order.

SELECT C1.Id
...
   ON...

Best practice is to use a tally table in preference to a loop, so I added that to the code.  No test data provided so I couldn't test the code.

Afaik this actually produces the desired output.  Should work with SQL 2014.  It uses the ordinal splitter DelimitedSplit8K_Lead.  The query: splits the input string on '_' underscore, finds the...

If you've got the time to wait for it to run 🙂

It really makes no sense to send every db file thru the...

Here's a stand-alone version of the proc I created for work.  Naturally adjust is as needed to match your requirements.  The proc goes into the master db (and is marked...

I thought later of one possible correction to removing the file extension, just in case two or more periods (.) appear in the value.

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER...

(tbd)

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[fn_GetAlphabetsAndUnderscoresOnly]
(
    @string VARCHAR(8000)
)
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @invalidCharLocation SMALLINT
SET @string = LEFT(@string, CHARINDEX('.', @string + '.') - 1)
SET @invalidCharLocation = PATINDEX('%[^A-Za-z_]%',...

The missing index suggestions are not connected to specific queries in versions prior to SQL Server 2019. SQL Server 2019 added the sys.dm_db_missing_index_group_stats_query DMV. This DMV tells...

The missing index suggestions are not connected to specific queries in versions prior to SQL Server 2019. SQL Server 2019 added the sys.dm_db_missing_index_group_stats_query DMV. This DMV tells you which...

Sorry for the confusion. Yes, as the data stands right now the entire column should be populated with an *. If the department column included 0001 and 0002, then...

I'm not really sure what you're trying to do, but it sounds like something like this:

UPDATE tn
SET tn.[Export Deparment] = CASE WHEN Distinct_Department_Count = 1 THEN '*'...

Also, since the table you are INSERTing to already exists, you need to INSERT to it, not SELECT ... INTO it:

Truncate TABLE Planning

Insert Into Planning
Select *

from (select...

(2) Here's my answer:

CREATE TABLE dbo.emp_training ( id int IDENTITY(1, 1) NOT NULL, emp_id int NOT NULL, training_id int NOT NULL, status char(1) NULL CHECK(status IN ('F',...