Can you elaborate it a bit more? What is meant with "generates a output of adding 1 every second month"

0 = beginning of month?

1= end of month

float, secondes passed since...

Do you work with the "Join" function in SSRS for passing multiple values?

https://devinknightsql.com/2010/10/08/ssrs-join-function/

Not sure why it displays double ??

Wikipedia contains an overview of western codepages https://en.wikipedia.org/wiki/Western_Latin_character_sets_(computing)

https://en.wikipedia.org/wiki/Code_page_850

Looks like is is due memory limitations in the earlier days of MS-DOS

Thanks for the story glhohman

What do you mean exactly with but how do I format this for SSRS?

SSRS has date functions http://venkateswarlu.net/MSBI/ssrs/SSRS_Common_Functions_Date_Time.aspx

Dataminds Belgium 10/11 oktober was great

I can't really help but can you give some more sideinformation

Any change in used Oracle drivers? 12c to 19?

Any change in Oracle executions plans ( 12c to 19)

Does SSIS or...

If you're working with the preview version I would contact MS about it SSMS 18.12.1 is the latest general availability (GA) version

You could use a T-SQL cursor to loop through the months and return a dataset per month

You could retrieve the data all at once

select id,count(*),mymonth.id

from dataset

join mymonths on dataset.date between...

Our developers are not trained in writing stored procedures but they are getting better in taming the ORM. Mostly inline SQL

Teams is really catching on in our organization. Recent features made it easier to exchange with external persons. The ability to link to a chat in CRM sped up the...

Have a look at dbatools Start-DbaXESmartTarget https://docs.dbatools.io/Start-DbaXESmartTarget

Sounds something for the last_value function https://www.sqltutorial.org/sql-window-functions/sql-last_value/

You may get a quicker response if you paste the TSQL-scripts to reproduce the testcase

so we can run it in a "test" database without...

I guess the table scan is seqid from db2. Strange that is isn't an index scan. Is that the table or is that the one of the top-clusterindex scan

The not-in...

As Ken said, stall's are usually an infrastructure thing. (network, san, ...)

Could also be due a new query plan generating a heavier load

The server is cpu-bound -> find the most...