I'm attempting to utilize this query, but I've discovered that HasViewDep is not producing accurate results. Some of the tables are used in inner view select statements (subqueries or...

Hmmm... That's a strange way to join two tables, but you'll probably have your reasons. It doesn't make sense to me - it seems very arbitrary. Anyway the only thing...

Okay, maybe I'm a bit daft, but couldn't you simply use this:

CREATE OR ALTER VIEW Test
AS
SELECT * 
FROM Calendar C
LEFT JOIN Events E ON C.CalendarDate BETWEEN E.EventStartDate...

Even though the MS documentation states that literals longer than 4000 characters are cast as NVARCHAR(MAX) this doesn't seem to be the case.

Constants (Transact-SQL) - SQL Server | Microsoft...

A slightly different approach

SELECT
      CONCAT(SCHEMA_NAME(t.schema_id), '.', t.name) AS TableName
    , t.create_date AS CreatedDate
    , t.modify_date AS...

I'd say its purpuse is to strip leading zeros from (I'm guessing) a numeric string in the col column, i.e. '000001200' becomes '1200'. This is useful for example when processing...

• This reply was modified 1 year, 9 months ago by  kaj.
• This reply was modified 1 year, 9 months ago by  kaj. Reason: clarification

With the understanding that I've not done any deep analysis on any of the code posted and going only on what I've seen in the past, the nested REPLACEs...

Just to be sure. You want to?

1. Locate the first numeric character
2. Strip everything from the first numeric character up to the next underscore
3. Repeat from step 1 using the...

Since SQL Server 2016 you can use the STRING_SPLIT() function, which  means that you can do something like this:

SELECT * FROM View_Session WHERE BookID IN(SELECT CAST(value AS...

A more primitive alternative to the above replies. 🙂

declare @table table (
    Number int,
    Date1 date,
    Date2 date,
...

A simple typo I think. If you have just used copy/paste from Ed B's suggested code, the CAST needs a starting paranteses, i.e. CAST(NULL AS VARCHAR(100))

This is just a feeling, but I have had the same problem a time or two. Turned out that different default settings of ARITHABORT between SSMS and the application resulted...

Or maybe a combination of the proposed queries? Something like

WITH LowestHighest AS (

SELECT MAX (vacationhours) as 'Max_VacationHours', MIN (vacationhours) as 'Min_VacationHours'

From [HumanResources].[Employee]

)

SELECT 'Lowest' AS VacationHoursLeft, e.*, lh.Min_VacationHours AS VacationHours

FROM [HumanResources].[Employee]...

Was the WHERE clause allowed when the COLUMNSTORE index was first introduced with SQL Server 2012? I think not, but I haven't been able to find the official MS documentation...

• This reply was modified 1 year, 10 months ago by  kaj.

Alternatively you'll need to use a window function instead of a conventional group by.