You'll need to add the value of the variable first as a column, using a Derived Column Transformation (Like I showed in your other topic). Then, instead of the...

Wouldn't this logic be easier to implement into the application, rather than SQL Server? Otherwise you're going to need to (likely) rely on triggers, which shouldn't be used to send...

I agree with Phil, I don't believe you can either. This sounds like an XY problem here. If all these tasks are reliant on others, then the control flow should...

Use a CTE then:

WITH CTE AS
    (SELECT D.MStockCode AS StockCode,
     ...

• This reply was modified 6 years, 5 months ago by Thom A.

Maybe, at a total guess, have an ORDER BY of:

ORDER BY CASE DueDate WHEN 'PAST' THEN 1
          ...

What do you mean it didn't work? At a guess, if you defined the column as timestamp(which by the way is deprecated, you should be using rowversion instead), you should...

• This reply was modified 6 years, 5 months ago by Thom A.

Do you mean you're generating Dynamic SQL? Where is this variable you are wanting to "store" the dynamic SQL in, SSIS or SQL Server (if the latter, then surely you...

2019 - 1 = 2018, so what wrong with WHERE sportyear = @year - 1; here?

"From the configuration manager I can still see SQL server and Agent is showing online" SSMS doesn't appear in the configuration manager; it's a completely different tool. SSMS will never...

She might be claiming Pension Credits though; she'll continue to get...

Okay, this is really really weird. When I submit a reply (from the open form at the end of the page), the thread bounces me back to the...

As @Taps said, you'll find the packages under Integration Services Catalogs when you connect to the Data Engine. Like you see in the below where I can a few packages...

 ...

• This reply was modified 6 years, 5 months ago by Thom A. Reason: Does Plain look better?

So does this mean the system I use at the office is exempt as it was designed (and is still running)...

Blargh, has something been feeding the Troll again? I really wish they wouldn't degrade the users so much when they've made such a well formatted post.