Easy now! 🙂

He did...

• This reply was modified 3 years, 7 months ago by kaj. Reason: typo: you --> your
• This reply was modified 3 years, 7 months ago by kaj.

I'm no expert on Powershell scripts by a long shot, but I think you should try to do an explicit cast to NVARCHAR(MAX) or XML on your insert command.

As I...

(deleted)

• This reply was modified 3 years, 7 months ago by kaj. Reason: wrong question answered!!!

Should be a very basic query. Try

SELECT Object_Id, Schema_Name, Table_Name, SUM(Value1) AS Value1, MAX(Date1) AS Date1
FROM Table
GROUP BY Object_Id, Schema_Name, Table_Name
ORDER BY Object_Id, Schema_Name, Table_Name

Okay, that did shed more light on the issue.

It seems the view and tableB reside in different databases. This is a problems, since the sys.xxx files do not span databases...

Ahh, okay. I think you'll have to comment on that image, because there isn't much to see after you have redacted most of the information....

Also, if you run this:

SELECT 
    o1.Name as ReferencingObject, 
    o1.type_desc AS ReferencingObjectType, 
    d.referenced_server_name, 
  ...

• This reply was modified 3 years, 7 months ago by kaj.

Stange! My tests don't show this behavior. What do you see in SSMS when you look at the dependencies? Do the view show as a reference from TableB?

Please note that if the the view references a table through a synonym the direct reference from the table will not be there. Maybe this is your use case?

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 3 years, 7 months ago by kaj.
• This reply was modified 3 years, 7 months ago by kaj. Reason: clarification