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 6 years, 2 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...

you could answer my question without using your data as I supplied sample data on the CTE (you need to learn about these)

to use your real table you use the...

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

could be Windows version - or even AV misbehaving.

have a look at https://support.microsoft.com/en-ie/help/2919863/you-receive-time-out-error-messages-when-you-connect-to-a-sql-server-2

Would not fall on a big project - small web page, 1 or 2 "pages" so it is something that even a junior Web dev can do.

for starting the job...

there are other documents but have a look at this one

and you can google for "azure failover cluster shared storage" to find others

yes