Not a solution since am at work, but for the future, if you have TSQL Questions, rather than what u did, its much more helpful and easier for you and...

Maybe take a look into this:

https://www.brentozar.com/blitz/max-memory/

Maybe the environment variables in the job?

For those are too lazy to copy paste for testing, added 2nd Colum for True False:

create table #temp (
	Date1 datetime2
   ,Wanted bit)


insert into #temp
values (cast('2020-08-26...

I never got into reading no-technical books.

I am now 27 and i havent read a single non-technical book outside of those i had to read for schools.

On the other hand...

• This reply was modified 5 months ago by  ktflash.

Most likely DMV (Dynamic Managent Views) is what you are looking for.

By creating a linked server to SSAS you can query SSAS Metadata via SQL

I might be wrong but is there a...

• This reply was modified 5 months, 1 week ago by  ktflash.

I only recently started working with python in my freetime but as someone who only used SQL/TSQL i am struggling quiet a bit to get used to working with data...

Always feels weird to guess about stuff you never heard about, because to get the answer you have to submit one.

But something learned is something learned.

OK, are these date ranges included in your cube? If so, why are you doing that, rather than allowing the end user to perform the aggregation in a pivot...

• This reply was modified 5 months, 4 weeks ago by  ktflash.

Its not calculated its just a number and the 2 date ranges (+ other dimension references)

Kinda offtopic, but since i am getting into python and therefore numpy,scipy and pandas.

It might be because i am just starting, but what are these basic features like pandas for...

Join the tables, group the result, pivot the result

create table #employee (
employeeNo nvarchar(20),
lastName nvarchar(20),
firstName nvarchar(20),
gender nvarchar(20),
departmentID nvarchar(20))

create table #department (
departmentID nvarchar(20),
"name" nvarchar(20))

insert into #employee(employeeNo,firstName,lastName,gender,departmentID) 
values('1','Tom','Smith','M','2')
  ...

Theres so many python books out there for data analysis.

After i fortified my basics of python im planning to continue with a handbook/introduction book to numpy und scipy.

Can anyone suggest...

So something like this?

This gets the value from the previous week, if you want the Date you would have to replace the LAG(DATE)

select Date,Value,Previous=LAG(VALUE)OVER (ORDER BY DATE)
	from...

• This reply was modified 7 months ago by  ktflash.