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, 9 months 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, 9 months 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, 9 months 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...

on the calling proc instead of doing an insert into define a temp table manually.

on the called proc detect and see if the temp table created on the outer proc...

its 10k partitions according to the OP

try "/ 12.0"

and 112 is wrong format for that date representation.

112 = YYYYMMDD

121 = YYYY-MM-DD HH:MI:SS.mmm

that is an Oracle feature - not available on SQL Server although parts of the equivalent features (SSAS) exist on SQL Server and can be controlled from T-SQL.

reading the documentation does help.

Link posted before on this thread

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15

Not only this contains instructions for 2019 but it also has, quite visible, a link to previous versions.

if you output onto a file or to text it should give you the desired result

if you are querying on SSMS to the grid it will remove those.

do you have or can you create a calendar table that contains the weekday for each date?

that would make giving you an easier example rather than having to build it...

you need to provide a lot more detail - as you aren't doing any explicit conversion I assume that either A1.Entry is a date/datetime or test3.bref is - and the...

• This reply was modified 5 years, 10 months ago by frederico_fonseca.

nope - even if you don't upgrade yourself, the engine will do that on the fly - and will fail for same reason.

you need to figure out a way to...