If the SQL instance is stopped, this will effect Agent as well. If you stop the SQL instance, you'll need to start Agent for that instance up again too. Are...

You can't use SET to set the values of several variables. You would either need to use SELECT, or SET the value of each one individually.

Pants, just noticed i was on the 2008 forum, not 2012 ilke I thought i was. I'll edit my solution. Lag won't work

How's this?
CREATE FUNCTION tvf_HighestIncreased (@Refno int)
RETURNS TABLE AS RETURN (
    WITH Increases AS(
        SELECT *,
               Total - LAG(Total) OVER (PARTITION BY...

Licence terms can be found here: https://docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools-license-terms

A quick scan doesn't say anything, but it would be worth reading and checking yourself. for your own benefit.

Back up to a different media. For example an external storage device or a network device. Otherwise create more space on the location you are trying to back up to.

Personally,I'd probably go with a solution like this:
SELECT T.ProcessDate, T.ProcessDateShort,
       T.AccountNumber, T.AccountStatus,
       T2.SumOpenShareBalance
FROM #Temp T
    CROSS APPLY (SELECT TOP...

I'm pretty sure that SSDT does work on Express. In fact, I'm confident we have a package that connects to a third party Express database at the office. Yes, the...

Sample data as SQl statement attached as a txt file (far too large to paste, and .sql files are not allowed...?).

Is this not a simple GROUP BY? If...

The BigInt datatype can store a value of up to 2^63-1, That equates to 9,223,372,036,854,775,807, which is far larger than your number.

What is the rest of the...

You don't. You attach the database and access the data on your SQL Server.

I have to wonder why you have a database by client. This screams poor design on so many levels.

@john-2, the only reason I can imagine that the OP...