Yep, it's true, the OUTPUT clause cannot pull from your input sources, only the data that you are already outputting.

When I've been in your situation, I have always...

Oops, that was my mistake in the solution that I posted.

Glad I could help.

Well, you can use Dynamic SQL, but it's a possible security risk.

What's that? Come closer so my light saber can hear you...

😀

This'll do it:

Select PatID, Date_Time, Sodium

From bga

Where PatID IN(Select b2.PatID

From bga b2

Where 135.0 > b2.Sodium

And b2.Date_Time = (Select Min(b3.Date_Time)

From bga b3

Where b3.PatID = b2.PatID))

Order By PatID,...

Hey! That's my birthday!

OK, here's, that:

Select [Year]

, [Month]

, Count(*) as [Monthly Records]

, SUM(Expenditure) as [Monthly Expenditures]

, Count(Distinct Doctor) as [Total Doctors]

From YourTable

Group By [Year], [Month]

OK, like this:

Select [Year], [Month], SUM(Expenditure)/Count(Distinct Doctor)

From YourTable

Group By [Year], [Month]

Ah, well, that's not a moving average, that's just an average, hang on...

There are a lot of different "moving averages", how do you want yours to be defined?

Glad I could help.

In SQL, CASE is a function and not a statement:

Select @myDate = CASE

WHEN @monthInput=1 THEN SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@curDate))-1),DATEADD(mm,1,@curDate)),101)

WHEN @monthInput=2 THEN SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@curDate))-1),DATEADD(mm,2,@curDate)),101)

Else @curDate

END

More like this:

CREATE TRIGGER Insert_ApprovedDate

ON Request FOR INSERT

AS

Update r

Set dateApproved = getdate()

From Request r

Join inserted i ON i.PK...

Yes, how many values can be in this column?