how are you executing this? syntax is ok if executing on a command prompt but depending on how you are doing it you will require additional quotes.

for example if doing...

That's great news Lynn - and awesome timing 🙂

have...

That's why I put the note: my EXISTS example does NOT reference an outer table.  A rare situation perhaps, but not impossible, more likely:

WHERE EXISTS(SELECT 1 FROM sys.tables WHERE...

Wouldn't that count every reference as a "join", including a select from a single table?  And any other single select from a table.

SELECT ...

FROM dbo.table1

SELECT ...

FROM dbo.table1

WHERE EXISTS(SELECT 1...

will you please stop creating new threads with same content just because you didn't understand the replies you got (or you didn't explain what you wanted correctly)

this has already been...

neither of the options above will capture cases where the "joins" are old style.

and why not use the system dependency tables for it?

SELECT schema_name(o.schema_id) as  referencing_schema_name
...

this has already been discussed on https://www.sqlservercentral.com/forums/topic/case-statement-46 - if you need more/different info do follow it up there

question is incorrect and as such answer is also incorrect - both settings are used for SQL 2019 - one for first 32 cpu's, second for the ones above.

2 answers...

and look at not using cursors at all - in majority of cases where developers think they need cursors that is not the case

and what was the result when you tried it?

Wizard might be able to sort it out for you - but YOU need to put some effort on testing it yourself...

I think you misunderstood what I explained or you didn't implement it correctly.

doing it the way I mentioned the temp table created on proc B will have the contents inserted...

• This reply was modified 5 years ago by frederico_fonseca.

not quite - it needs to be a temp table, not a table variable.

----THIS IS AN EXAMPLE OF PROC 2:
CREATE PROC dbo.Service_Data_Summary
AS

create table #MoreData 
(COLUMN1 INT
,COLUMN2 INT
...

• This reply was modified 5 years ago by frederico_fonseca.

temp tables can be defined on proc A and referenced by any proc called by it

proc A calls proc B

proc B can then use the temp tables defined by A...

• This reply was modified 5 years ago by frederico_fonseca.

you would keep the same functionality.

pseudo code - without seeing the proc this may be incorrect but should give you an idea

original code

OldProc

insert into original table from openquery...

select * from...