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 5 years, 6 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

your expected output does not match the code you supplied - so please be very very clear on exactly what are the rules for what you intend in getting as...

add these 2 lines to your code so you can see what you are doing wrong - and then you should know how to fix it

,LAG(visit_date_01, 1, visit_date_01) OVER (PARTITION...

based on your expected I would suggest you change the default value from getdate() to visit_date_01

and add visit_date_01 to the order by (instead of EMID as that is already on...

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

what exactly are you trying to do?

Is it a one time conversion or a view that will be available for querying on the fly going forward?

and do you have sample...

you out of luck really. For SQL the tools that do "code analysis" are basically looking to see if it uses constructs that should be replaced with something else, and...