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, 5 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, 5 months ago by frederico_fonseca.
• This reply was modified 5 years, 5 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...

OP using SQL 2014 - m0st likely syntax used won't work

Frederico,

on the other post you suggested my code would actually FAIL "if you are one of those that puts comments BEFORE the create procedure command"

So now you are...

yes... but....

DO NOT restore directly from prod to any other environment. where you do need to have production data always setup a process on another server (restricted, to be treated...

it is a matter of opinion.

on my own opinion I enforce them to be after the create.

one of the reasons is that if I ever need to do a automated...

It's not like I can just install Visual Studio on the server that is hosting the databases without discussing with higher ups.  Additionally I believe this requires a coding...