the single quote is SQL's delimiter for identifying strings, so you have to escape it by repeating it twice in a row, where you want it to exist inside your...

I'm having some trouble with this running it against a SQL2016 server. just limiting it to one specific issue for now, scripting the definitions for the databases themselves, and not...

LTRIM + RTRIM is your problem.
all those LTRIM + RTRIM force the results to be varchars, regardless of what the original data types are. .
if the values were...

it's true that SELECT INTO will have the datatypes preserved, but it depends on what the source is doing.
CONVERT functions ,ISNULL, or implicit conversions in a query(due to unions?)...

use a case statement and don't parse it when the period does not exist.

SELECT MachineName,
CASE
WHEN CHARINDEX('.', MachineName) > 0
...

First, change all those table variables to temp tables.
The Query engine assumes that a table variable has one row in it, and builds a plan which assumes that one...

also i use this proc to update the job description of SSRS subscriptiosn to have the report name; makes it a LOT easier to track down.
it uses dynamic SQL...

you could also create a subscription in Standard edition, and use a SQL Agent job to call the subscription job if the criteria is met.

so assume you create...

There's more than one way to do that.
in my case, the convert function would work nicely, if you include the optional code:
SELECT CONVERT(varchar(10),getdate,112) , where you replace getdate()...

wrong toolbox.
click in the upper right corner here to get the SSIS toolbox instead.

LPIM = Lock Pages In memory?

i had no idea that was a permissions headache, but i found an image!

we'd need to see your update and select statements, really.

does your update inner join to another table?
a SELECT might return more rows, because the other table has...

great, now go back to your queries for all mail and the query i posted for failed mail;
do you see those messages as sent or failed?
did they...

find your name in the upper right corner and click it.
basically your profile page then has three links down at the bottom of your picture...
Topics = Original...

the code generated the command to run. I also pasted it in my post for convenience; it's not as familiar looking  as a regular SELECT statement, but it will try...