Could just be?:

SELECT a.artigo,
       a.descricao,
       Artigo_2.unidadebase,
       b.[vendas ultimo semestre],
...

SELECT d1.*
FROM #DETAIL d1
WHERE d1.IDR < (SELECT MIN(d2.IDR) FROM #DETAIL d2 WHERE d2.ID = d1.ID AND d2.BALANCE < 0)

What is the definition of table1?

Hi Experts,

Below query is scanning index on column 'created' where I was expecting it to scan on CID which is the 'where' clause and PK?

Can you help me understand...

Ok, fair enough

SELECT 
    dtstamp, equipment_id, temperature
FROM (
    SELECT *, 
        ROW_NUMBER() OVER(PARTITION BY...

You stated nothing about equipment_id in your original post.  How am I supposed to include logic for your equipment_ids when you tell us nothing about them?!

Maybe?

SELECT 
    dtstamp, equipment_id, temperature
FROM (
    SELECT *, 
        ROW_NUMBER() OVER(PARTITION BY DATEDIFF(HOUR, 0,...

Gen script should be able to do that, just specify the correct scripting options in SSMS before you gen the script.

My question would be, why are you using two tables to do one thing?  It looks to me like it should be a single table because there appears to...

Btw, you don't seem to realize that you are not including the last day of the month in the Calendar table.

CREATE OR ALTER VIEW Test
AS
SELECT * FROM...

That join will work fine too.

Try an ORDER BY C1.RowNum so that you can see the matches between rows, if any, in order.

SELECT C1.Id
...
   ON...

Best practice is to use a tally table in preference to a loop, so I added that to the code.  No test data provided so I couldn't test the code.

Afaik this actually produces the desired output.  Should work with SQL 2014.  It uses the ordinal splitter DelimitedSplit8K_Lead.  The query: splits the input string on '_' underscore, finds the...

If you've got the time to wait for it to run 🙂

It really makes no sense to send every db file thru the...

Here's a stand-alone version of the proc I created for work.  Naturally adjust is as needed to match your requirements.  The proc goes into the master db (and is marked...