What did you try? Something like an update against Plan using the related max from the Plan_review table?

17K points and you ask questions with no data???

I can get Python to read my database tables / run my stored stored procedures using pyodbc from Python (outside SQL Server)... I guess Python is just super flexible -...

I've only just started Python, but trying to use Python inside SQL Server is mindboggling to me. Seems a lot cleaner and clearer if you do it from outside... connect to...

That reminds me of a precon I went to by @SqlLocks (Jonathan Stewart). One of his cousins is color blind, so he has been interested in it for a long...

When I click on the picture, I can't copy it into SSMS. So it won't run. So I can't help. Sorry!

You really need to read this article:

Forum Etiquette: How...

• This reply was modified 5 years, 7 months ago by pietlinden.

If you really want help, help us help you.

Post TEXT, not pictures. And if you're stuck on something, post what you tried. We're not here to do your homework. Ideally,...

I don't see any way to group these so that you can use ROW_NUMBER() with a PARTITION clause. Can you explain how these are supposed to group? If you can't...

I created this measure using the allselected function.

Could you post the code for it? Something like

DIVIDE ( [Total Sales], CALCULATE([Total Sales], ALLSELECTED('Calendar'[Month]))

https://www.mssqltips.com/sqlservertip/6338/sql-server-backup-size-vs-database-size-script/

Thanks for the data setup... this matches your expected output...

SELECT *
FROM dbo.Sales s
INNER JOIN dbo.FiscalPeriods fp
ON s.DOCDATE>=fp.FirstDate AND s.DocDate<=fp.LastDate;

You may create a staging table, populate it with the data from a trigger and use a job to output the data to a file.

I guess use the Inserted virtual...

Unless I'm reading it wrong, sounds like you could use Service Broker for that...

"Here are some examples of reasons you might use Service Broker:

Asynchronous triggers. You can construct asynchronous triggers either...

Created a User DSN, and it worked a champ.

Then for fun I created a trivial stored procedure just to see if I could call it.

CREATE SCHEMA junk;

CREATE...

• This reply was modified 5 years, 8 months ago by pietlinden.

something like this?

SELECT DISTINCT ID
FROM Response r
WHERE EXISTS (SELECT 1 FROM Response r2 WHERE r2.ID = r.ID AND r2.result = 'Y')
AND EXISTS (SELECT 1 FROM Response r2...

=IIf(Round(Fields!Qty1.Value,3) = Round(Fields!Qty2.Value,3),"Red","Black")