CTE's would work, as well as subqueries(same thing,really , just different format.

here's my version of your post as CTE's:

DECLARE @personID INT = 123999;

WITH ELDASummary

AS (SELECT...

there's no upgrade path for Express to non express versions; instead you need to backup all the databases, script out your logins, as well as anything server related...certificates, linked servers,...

a trigger has a COLUMNS_UPDATED integer value which represents a bitmask for the columns that were mentioned in the update, but it does not tell you if the value changed...

is this on a cluster, where it might be failing over or toggling to the other node?

is it possible someone is downing the server for maintenance?

did you check the...

i think it's integer division. SQL maintains the datatype, and the avg is truncated to a integer.

change the datatype of the column from int to decimal(19,4) and you get 2.5

Declare...

if the table has an implicit or explicit ordering, like an identity() column, or a CREATEDDATE datetime column, you can compare old to new in a set based operation, by...

SQL Server Import and Export Wizard

https://msdn.microsoft.com/en-us/library/ms141209.aspx

well i dug a little deeper in my old parser utility.

i expected the tables to be identified as TOKEN_TABLE, but they end up being TOKEN_ID instead; i guess with a...

INNER JOIN (

SELECT Top 1

that will return one , single row, not one row per policy number, right?

so the other table is limited to match one row as...

from a string representing a query, it's difficult, just as Grant said; you have to tokenize it in a SQL parser. It's quite a bit of work, i did it...

It's really, really easy to script out a backup and restore,and with just a bit of tweaking and testing, make it fully automated.

For example, I have a job that restores...

i use something like this to generate models of both an insert and an update statement, assuming a staging table of the same name;

does this get you started?

you would...

duplicate post.

original discussion is here, lets keep it all together to prevent fragmentation of replies:

http://www.sqlservercentral.com/Forums/Topic1779526-338-1.aspx

the real question is what is your budget;

the top tools cost money, typically ~1000 per server, with discounts against more and more servers.

is your job going to shell out 100K...

backup and restore would be my first choice too, unless you can come up with a decent reason to avoid it.

if you are really going to script it out,

there's...