SQL Join Same Table and create single row result to complete NULL values
Clash Royale CLAN TAG #URR8PPP SQL Join Same Table and create single row result to complete NULL values I have only one source table in SQL. I am trying to join it to itself so that i can fill up NULL values and retain the priority values into single row. There are million of records. FROM THIS: ID1 Source1ID Source2ID Owner Source1Date Source1Desc Source2Date Source2Desc 8 123 567 Source1 1/1/1900 Active NULL NULL 9 123 555 Source2 NULL NULL 12/1/2000 Ongoing TO THIS (expected result): ID1 Source1ID Source2ID Owner Source1Date Source1Desc Source2Date Source2Desc 8 123 555 Source1 1/1/1900 Active 12/1/2000 Ongoing So how can i join the table to itself to attain that single row result? I have tried using the query below and made it as a VIEW but it takes forever to execute just to retrieve 1 row. --CREATE VIEW dbo.vw_JOIN AS WITH MyTABLE AS ( SEL...