I had a problem a few days ago where using TRY_CAST gave no nulls in the result, but using just CAST caused an error. It turned out that either my...

I was expecting the LEAD solution to need the UNBOUNDED FOLLOWING frame, so I discounted that one.

I have confirmed that the error was caused by a value that was being filtered out later by the joins or the where clause. That's why I never saw nulls...

I tried to script out the values (see below). Selecting from the resulting temporary table works whether I use CAST or TRY_CAST, ie. the value has somehow been fixed by...

• This reply was modified 4 years, 11 months ago by  Chris Wooding. Reason: Estimated plan added in case it helps

Phil,

I'll try to reproduce with sample data tomorrow (and post it if I succeed).

Thom,

didn't your large value came through as null when using TRY_CAST? It did when I tried in...

Unfortunately, when I scripted out the inserts, the select worked on the result, ie. just rendering the result into a grid was sufficient to "fix" the underlying error.

Thanks. The highest value I get for LocationOfDP is 7. If there were too many decimal places, I'd have expected the ROUND to fix it.

It seems to me that you could have all the certificates under the sun and be next to useless or none at all and be really good. The only useable...

• The 1st car I drove any significant amount was an Alfa Romeo Giulietta (round about 1980, so not the current one) that was my Dad's company car. That had...

We have a datacentre in London with many users in Glasgow. The Glasgow users frequently experience dire application performance while London users of the same applications have no problems. Our...

What is the error message you receive? It would help us help you, if we knew.

There is a very good article on this subject (including a discussion of the execution plans) on the link below.

https://www.sqlservercentral.com/blogs/left-outer-join-vs-not-exists

“As our circle of knowledge expands, so does the circumference of darkness surrounding it.” - Albert Einstein

I like the idea of paying for CPU/Disk/Memory as needed, but I wonder how it would work if we all did it. Where I work currently, there is a background...

I may be wrong, but if you're doing SELECT * FROM A EXCEPT SELECT * FROM B, I wouldn't expect indexes to be used as all rows in both tables...