What I understand if there is value in each column then return true if not then return false.

select Col1, case when coalesce(COl1,'')='' then false else true as Status from...

This is complex case:

To resolve this issue you can try the following way--

1. First identify the duplicate based on your requirement (may not duplicate)

2. Find the number of records associated...

You can use the PIVOT operator to produce this output. To use the PIVOT operator, perform the following steps:

1. Select the data you need by using a special type of...