if you are working with SQL 2019 and get R configured and up and running you can write Excel files with it - and probably easier than with SSIS

There was...

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

did you try cleaning the query and using exists instead of not in ?

Assuming that the query is exactly as you supplied the following could be changed - may or...

Adding to the sql from Chris above.

you wanna search for any module that has

• bulk insert
• openrowset
• openquery
• xp_cmdshell
• oa_*** extended sp's ( OLE Automation)

you also need to look for...

if only the where is generated but remaining query remains the same maybe changing it slightly could influence QE to choose a different path.

note that for the following the index...

Something that seems a bit obvious to me but hasn't actually been posted in this thread is that you really need to simplify your proc. Anything that is 3300...

link is to allow you to give permissions to start a job - it has nothing to do with what the job does afterwards.

so separating the 2 things - did...

only changes to "character size" was done on 2012 with the inclusion of new _SC collations to allow for UTF-16 and the expansion done by 2019 to allow for char...

not needed any more

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

you are missing the commas separating the columns

thanks for the clarification.

this should then do the trick - as before replace the "base" table with your own table

select b1.EMID
     , b1.visit_date_01
...

did you look at the instructions link I supplied? that would allow you to do it without granting permissions directly to the user

free subs are limited to particular zones so you may need to try a different one.

that code isn't setting the variables - but rather concatenating the contents of the variables with the remaining of the SQL statement

following should do the trick

ALTER PROCEDURE...

one of the good features of 2019 vs 2017 - R is available to install on a Cluster on 2019 - not so on 2017.

that is clearer but still could you explain why

01/07/2017 had an increment when difference between previous date is only 30 days

01/08/2017 did not have an increment when difference between previous...