Tuesday, 14 August 2018

SQL Server miracles

I have not used SQL Server for ages, in fact – it’s been spotty throughout my career.

But, I was just doing some hectic Media Object massaging (F00165) – I’m converting them from type 1 (physical files) to type 5 HTML links.

My SQL caused a duplicate for a large insert, but look at what SQL tells me!!!

image

It tells me the bad record!!!

How many group by queries has this just saved me, so awesome.

No comments:

Extending JDE to generative AI