Not being good at SQL Server != Not being good at your job

Not everyone that uses SQL Server is an SQL Server professional. Do they need to be? Not necessarily....

Doesn't sp_executesql work for you? https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-executesql-transact-sql?view=sql-server-2017

Completely agree with everything you say here.
I have lots of pet hates and one of them is the use of dbo schema for everything. One culprit I have encountered...

Hi,
IMO, tone does matter, we are all people ... All people deserve respect and dignity. It is true that some are more sensitive than others. I include myself in that....

Before I started work in IT I was a postman, what Americans call a mailman (Yes, they were virtually all men then). Originally we were officially called Postal Delivery Officers...

Fully agree with these sentiments. Omnipotence on its own is not enough to become a "god", you need omniscience and foreknowledge also.

Great thanks

Hi

By special request then, can the crossword be supplied as HTML instead of an image and have text boxes for each letter! All you need is a table...

Hi
What's the easiest way of filling the crosswords in short of printing it out?

Thanks

Hi,
Yes lets take full advantage of meaningful extension names; EXCEPT when there are long established conventions, e.g. txt, csv etc. I certainly would not want to see comma-separated-values as...

The primary key is fine.
An index on LastUpdated is appropriate as suggested. But wouldn't a RANK WITH TIES be more accurate that a TOP 1?

Would this work?
WHERE YEAR(Invoice_Date) = YEAR(GETDATE()) - 1 AND MONTH(Invoice_Date) = MONTH(GETDATE())

I bin robbed!:crying: