Thanks. Understand the concept now when to use Left Join and Not Exist.

Hi, thanks Brian. Edit 1 is the one im looking for to sum by quarter. But the ordering are not in order. How can I order it without applying Order...

After applying indexes, it seems faster now.

Hi, i am using this method. but it takes longer time. i believe the columns are not index.

More than 20 columns and more than 50k rows. It takes me more...

it has multiple line, i am just creating it myself before applying to real data. there's logic to update certain scenarios, that is why I apply max in it. Just...

Currently this is my code as below. As i would to create as a view, not sure on how to apply together with the update and temp table replacement.

            
May 10, 2019 at 6:57 am
            
#3639668

            
            
                                                
        

How can I select all columns after updating the case condition?

 

WITH y AS (

SELECT

testing1

, testing2

, testing3

, amount

FROM (VALUES(

'testing1'

, 'testing2'

, 'testing3'

, 700)

) z(testing1,testing2,testing3,amount)

)

select testing1,testing2

,MAX(NULLIF(updatecolumn, null)) OVER(PARTITION BY testing1) updatecolumn_New

from(

SELECT *

--CASE CONDITION...