Ok, how do i merch these 2 Queries into 1 so i can use it as a column in a dimension as a filter?

This is 50% of it:

            
November 4, 2019 at 12:25 pm
            
#3694283

            
            
                                                
        

It is possible to increase the number of rows available in the Editor Window, but as Thom suggests, the Update Command is the way to go

This reminds me of the following video. The original video this is cut out from esports, but most of the talk is about doing the hard practice and how to...

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

Without knowing that the data looks like this would work, depending on what you need you must change the sum to max

SELECT  Model_id,4DoorCount=SUM(4DoorCount),2DoorCount=SUM(2DoorCount)
FROM (
Select distinct Model_id,

COUNT(CASE...

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

it doesn't sound like the join is incorrect, it seems like the problem is the data, and that you have a many-to-many relationship. Seems like you need to fix...

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

Since an IN gets converted to ... OR ... OR ..., I suppose it might make a difference, in which case you'd want to put the most common values...

Ok, i found a to rewrite the query producing the same result:

--previously:
               ...

That WHERE makes it look like your query is suffering from poor alias choices. Bad habits to kick : using table aliases like (a, b, c) or (t1,...

are you looking for this?

update #a
set a = case
when a = 0 then NULL
else a 
end,
    b = case
when b = 0 then NULL
else...

• This reply was modified 5 years, 4 months ago by  ktflash. Reason: reformatting SQL

Not perfect, but after alot trial and error i found the solution:

I seperated the necessary and not necessary tasks in the first package which is called.

The ones not necessary are...

Anyone any idea?

• i created an sql execution task with a wrong query to provoke an error which just says "SEL"
• Task name is "Fehler beabsichtig" and i added an...

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

It is not only about security dont forget about:

- possibly tracking who does what

- more problematic: isnt the user blocked when someone else is already logged in? so it might...

The package will fail automatically if the Data Flow Task fails. If you want to not not propagate the error for the Data Flow Task, then you need to...

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

Ahoi,

have you tried:

Query 1: only grouping by Article and the max values for the integer columns.

Query2: get Article and the non integer columns where is not NULL

Join Query 1 with...

Too much Edit in quick time caused to delete my comment, sorry for that

What kind of design question is it, sorry not sure?

It's 2 attributes of 2 seperate Dimensions, the...