How about this?

CALCULATETABLE
(
    'Table'
,   FILTER
    (
        'Table'
    ,...

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

I am currently going through "o'reilly data science from scratch python".

During the Naive Bayes explanation and implemention they mention exactly this.

In the book its called "smoothening" to prevent such things...

what on earth is contains, ive never seen that used before

mom pick me up im scared

Funny, i started to get into python but havent looked at how to use it in sql server.

Thanks for the question, actually allowed me to learn something and take a...

You have some values that have leading zeros.  Must the leading zeros be preserved?  If so, then not all of the columns are actually INTs as you...

You have some values that have leading zeros.  Must the leading zeros be preserved?  If so, then not all of the columns are actually INTs as you said.  Let...

Sorry for the late answer

Ahoi,

i have a set of 7 int columns in a table.

My goal is im trying to create a unique key/integer for each possible combination...

These extreme systems are so extremly fascinating to me.

The company im working at is still working with Cubes. We have Dimensions with sometimes like around a million entries and alot...

atleast post ur solution and not only "solved it", someoen might stumble upon this post and be like..

yeah thanks for nothing

post full query that leads to the error and use "insert/editcode sample" function plz

What solution did you go for?

Not sure from description what you are trying to accomplish.

Do you want all IDS from the Main table that are in Table 1 AND in Table2?

--> Filter from Main if...

These might be abominations not sure, first one is an if which is the easiest version if u can use it.

The 2nd version just uses a Dummyvalue if the values...

is there a reason why u are not doing it in one go? unless i might be overlooking something obvious here

select name
     ...

• This reply was modified 5 years, 7 months ago by ktflash.

The query already drops tables in the query at the top.

It fetches each table name 1 by 1 out of the query and executes a drop table + table name