and I expect in any given installation 50K of them are empty 🙂

and the moral of this story is to indent your code properly 🙂  If you had done that you would have quickly spotted the missing END

Nikos,

Welcome to the boards and the world of SQL.  You will find the folks on this forum super-helpful but they are all busy people.  I would recommend looking...

Personally I find XML (with an XML parser to properly do the indentation) much easier to read than JSON and it is a shame that JSON seems to be the...

and be thankful you are on 2016/2017.  JSON was not supported in earlier versions 🙂
Alternatively, tell your boss it can't be done in SQL and get him to pay...

+1 for SQL prompt.  Also T-sql Cop which picks up a whole bunch of other code rules apart from just formatting.

Look at SQL Tool belt by Red Gate, the sponsors of this site.  some great documentation tooling, source code control and migration scripting functions.  Apex and Pragmatic Works (now part...

getting OT now, but the business domain should drive both the EF model and the database schema.  EF and the fluent API is one way to build the database schema...

As an SQL developer I...

looks like a gaps and islands problem to me.
You might find it easier with a Date Tally Table too.

You could RANK() the data and then take the...

This is really a question of semantics, if it is necessary to have a properly conformed name or address for legal purposes, I would argue that that is not a...

Its been a while since I connected to Oracle.  Have you looked at the ODBC drivers from Attunity - I found them to be serveral orders of magnitude faster than...

I would suggest the following two scenarios are appropriate for cursors:

1) When you need to do something outside of CRUDing data in one or more table. (e.g. scripts...