Sean Lange (8/25/2016)

---

Please turn off caps lock. It is considered yelling and is might difficult to read. Also, there is no reason to post a separate question. You already have...

CREATE TABLE DELAYSECONDS(

ProgramID INT, ID INT, ContractHeaderID INT, ContractStartTime TIME, ProgramStartTime TIME ,ContractDetailFirstDay INT ,ProgramFirstDay INT, DelaySeconds INT)

INSERT INTO DELAYSECONDS

VALUES (625, 625, 115278, '18:00:00', '18:00:00', 2, 2, 0),

...

Thanks Guys for your imputs, see attached sample data in excel below, this data is is populated in the Temp tables

#updateprogramtables

#updatecontractdetailtable

My purpose is to get the difference in...

Luis Cazares (8/23/2016)

---

If you want to create the table with a column named as the first occurrence, you need to use dynamic sql. That's just wanting problems, IMHO.

Otherwise, you could...

SEE MY SCRIPT BELOW,

IM POPULATING A TEMP TABLE

IF EXISTS ( SELECT * FROM tempdb..sysobjects

WHERE id...

Luis Cazares (8/23/2016)

---

You can use a CASE expression for this:

SELECT CASE WHEN Monday = 1 THEN 'Monday'

WHEN Tuesday = 1...

Luis Cazares (8/23/2016)

---

JALLYKAMOZE (8/23/2016)

---

I HAVE A TABLE RANGING FROM MONDAY, TUESDAY,WEDNESDAY,THURSDAY,FRIDAY,SATURDAY,SUNDAY

THESE TABLES HAVE VALUES BETWEEN 0 AND 1 EG,

MONDAY : 0, TUESDAY :1,WEDNESDAY : 0,THURSDAY:1,FRIDAY:1. SATURDAY:1 SUNDAY:1

HOW CAN I...

the days are columns