banjara15
asked on
Help needed in sql query
Experts, I need you help in sql.
I have written a sql using UNION, I want to eliminate the NULL values from each row (see the attached file which includes all the detail). I am using Microsoft Sql Server 2012.
Please help me how can I do it.
Thanks a lot
Sql_Help_Needed.xlsx
I have written a sql using UNION, I want to eliminate the NULL values from each row (see the attached file which includes all the detail). I am using Microsoft Sql Server 2012.
Please help me how can I do it.
Thanks a lot
Sql_Help_Needed.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks a lot for quick reply. After making a slight change I got the exact result I wanted... :-)
Really appreciate your help..
Really appreciate your help..
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Really appreciate your help
Just an fyi this is the modified sql
Open in new window
And this is the result setOpen in new window