Albert

There are several different settings that can very depending on which user runs the query, or what provider you use to connect to the database and hence what's...

WITH NowandNext AS (
    SELECT
        H_SystemCustomer_Seq_ID
    ,   RateDate
    ,   Grade
    ,   LAG(RateDate) OVER (ORDER BY RateDate) AS OldDate
    ,   LAG(Grade) OVER (ORDER BY RateDate)...

Just because, really.  You can't restore master unless you're in single user mode.  That's how the product works.  Probably is something to do with master always being in use, though.

Vivek

Restoring the master database is one.

John

It's not the user that's running the job in whose context the commands run.  If the user is a sysadmin, it'll run in the context of the SQL Server Agent...

No DDL, sample data or expected results, so this is just a guess.

WITH ActiveInactive AS (
    SELECT
        CASE E.active
            WHEN 'no' THEN 'inv'
            WHEN 'yes' THEN...

WITH DateDiffs AS (
   SELECT *, DENSE_RANK() OVER ORDER BY(ABS(DATEDIFF(day,TargetDate,CompletedDate))) AS RowNo
    FROM Mytable
    )
SELECT * FROM DateDiffs
WHERE RowNo =...

From, memory, this, so look up the syntax yourself if it's not quite correct.  Change n for the length of your string, and remove the NOT if your column is...

Vivek

The main problem is that the Local System account is an admin on the server, which means that SQL Server will, in effect, have access to the whole...

Jason

Yes, with AND constraints, the task will only execute if all precedents were successful.  But do test it for yourself by engineering one of them to fail!

Redundancy is indeed not ideal.  Not only does it take up more space on disk, but it also doesn't stop someone from adding a row to the ParentWarehouse table with...

WarehouseStock is the wrong place for it, since it breaks one of the rules of normalisation by introducing redundancy.  If you know that WH01 is the parent of SC02, you...

Yikes!  Now we're into hierarchies, which makes things a whole lot more complicated.  Let me have a think.  There may not be an easy way to do this.  I think...

I'm not sure I understand the business logic behind that requirement.  Would the 50 pears be stashed in somebody's spare room?  Possibly the best way to model this is to...