It is as animated as tertiary period fossils

😎

The only time I see this type of errors is when I have many result sets open, never seen it when I've had many query windows open. Most of the...

I've noticed the "translation" issue of the single quote (char(39)) where it's converted into opening-closing single quotes, in my mind, a definite no-no when it comes to SQL scripts!

😎

Same thing...

Something is missing here, post the DDLs for the tables and do remember to include the constraints!

😎

Certainly any sensitive "vault" service would require the subject's consent before passing the information to a third party! More importantly, the T&E for the receiving party must include a "best...

Sorry, my bad! Can you post the DDLs with the constraints, the temp tables / your example does not have any constraints, hence no error.

😎

The single biggest issue you're going to hit on the database side of things is the new cardinality estimation engine that was introduced with SQL Server 2014. The new...

He he, a "standard" is these days a "temporal" thing, changes quicker than my girls mind in a shoe shop 😉

😎

IIRC, TRIM was in ANSII SQL 2003, maybe earlier but...

This is a bit odd, when I run the code, I don't get any errors!

😎

Here is the code I ran (slightly modified to use temp tables)

USE TEEST;
GO
SET...

Have you looked at this document?

😎

The newly introduced T-SQL TRIM() function is almost compatible with other vendor's flavors of SQL such as Oracle, PostgeSQL, Netezza etc.

😎

Of course it's not perfect as it is lacking the...

If you Notice the image you will find that the 201807 , 201810, 201812 as Zero's. The Rolling 12 Months should calculate as below respectively 201807 --- 16272.19 201810...

Sue with the following code

SELECT LEN(LTRIM('.' FROM '.....SSMS.....'))

I was attempting to TRIM/remove all the  '.'  to the left of the letters SSMS, which would return:  SSMS........

Lamb

Can you please provide more information, preferably a sample pbix sample file?

😎