T-SQL Code Help

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 1

Quick solution using aggregation to remove the null values

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(Advert,Network,Program) AS

( SELECT 'Acorn',NULL,NULL UNION ALL

SELECT NULL,'AC',NULL UNION ALL

SELECT NULL,NULL,'Adult'

)

SELECT

MAX(SD.Advert ) AS Advert

,MAX(SD.Network ) AS Network

,MAX(SD.Program ) AS Program

FROM SAMPLE_DATA SD;

Results

Advert Network Program

------ ------- -------

Acorn AC Adult

rocky_498 SSCertifiable Points: 6532 More actions · Answer 2

Thank You so much for your reply and help.

It was just a sample data here is in detail sample file

Advert,Network,Program

Acorn,NULL,NULL

NULL,AC,NULL

NULL,NULL,Adult

Jame,Null,Null

Null,IC,Null

Null,Null,Young

Null,Null,Adult

Fix,Null,Null

Null,GM,Null

Null,Null,Kid

The first three rows are set of Advert = Acorn

Second four rows are set of Advert = Jame

and last three rows are set of Advert = Fix

Please advise.

Thank You.

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 3

Have a look at this post for a more complete answer

😎

rocky_498 SSCertifiable Points: 6532 More actions · Answer 4

I really appreciate your time/hard work and awesome code.

Thank You!