I would like to update Table2 with Table select statement results .But somehow it is not working.

update Tabl2 set Value1,Date1

SELECT Object_Id, Schema_Name, Table_Name, SUM(cast(Value1 as bigint)) AS Value1, MAX(Date1) AS...

• This reply was modified 2 years, 4 months ago by  adisql.

All the objects are resides in same database.

Thank you

• This reply was modified 2 years, 4 months ago by  adisql.

NO,

All the tables resides in same database.

Attached result.

Attached result for above query.

Please find attached.

I could see as attached.

TableB is utilized in the view below, but HasViewDep for that table displays 0.

CREATE VIEW [xxx].[xxxxxxxxxxx]

AS

SELECT xxxxxx,xxxxxx,xxxxx,xxx

FROM TableA(NOLOCK) co

WHERE EXISTS ( SELECT 1

FROM TableB AS a

WHERE ( xxxx = 'P'...

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 joins),...

Thank you.

Is it possible to add ROW_COUNT and HasTrigger   to above select statement.?

• This reply was modified 2 years, 4 months ago by  adisql.
• This reply was modified 2 years, 4 months ago by  adisql.

Thank you !

Thank you.

Thank you.

Everything Working Fine now.

• This reply was modified 2 years, 5 months ago by  adisql.
• This reply was modified 2 years, 5 months ago by  adisql.

Thank you.