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

why don't you do what I said and install Visual Studio (SSDT) - you can then generate a VS solution/project with all objects on your database, do the global replace...

T-SQL in a Stored Proc would be better than SSIS 🙂

you can't blindly replace all "create" by an "alter".

Replace ((REPLACE(definition,'subscriptonguid','subscriptionguid')),'ALTER','create')

you need to replace the above bit of code with

• find procedure name position - split code in...

yes until you do the REVERT you are not a sysadmin as you are the OTHER user

have a look at the examples I gave here -  it is very clear...

as per my previous examples you need to REVERT the execute once you are finished with the impersonation.

and you never told us that your login was a AD group -...