SEE MY SCRIPT BELOW,

IM POPULATING A TEMP TABLE

IF EXISTS ( SELECT * FROM tempdb..sysobjects

WHERE id = OBJECT_ID(N'tempdb..#updatecontractdetailtable'))

DROP table #updatecontractdetailtable

SELECT programID,Stationid,Monday,Tuesday,Wednesday,

Thursday,friday,saturday,sunday,StartTime,contractheaderid,DelaySeconds

into #updatecontractdetailtable

from ContractDetail

ORDER BY programid,Stationid

I WANT TO RETURN THESE COLUMNS , PROGRAMID,STATIONID

AND THE FIRST COLUMN FROM (Monday,Tuesday,Wednesday,

Thursday,friday,saturday,sunday) THAT HAS THE VALUE 1 AS "CONTRACTDETAILFIRSTDAY",

THERE ARE ONLY TWO VALUES ALLOWED IN THE DAY FIELDS , 1 OR 0,

AND THESE OTHER COLUMNS : StartTime,contractheaderid,DelaySeconds