Answer Posted / shahid

Make your Record like below:

With CTE AS(RowId, Status)
(
SELECT ROW_NUMBER() AS RowId, Status
FROM MyTable
)
INSERT INTO #Temp
Now In your New Table CTE. Record Will be like that:
RowId Status
1 00
2 01
3 00
4 00

Now Apply the While loop with Condition
DECLARE @RowID INT = 1
DECLARE @Count INT
SELECT @COUNT = COUNT(RowId) FROM #Temp
WHILE @COUNT > 0
BEGIN
DECLARE @Status INT
SELECT @Status = Status
FROM # Temp
WHERE RowId = @RowId
IF(@Status = '01')
BEGIN
INSERT INTO MyNewTable(InTime) VALUES(@Status)
BEGIN
ELSE
BEGIN
INSERT INTO MyNewTable(OutTime) VALUES(@Status)
END
SET @RowId = @RowId + 1
SET @Count = @Count - 1
END
DROP TABLE #Temp

This query will seperate the value..
You can change it as your condition required.

Regards,
Shahid Ansari

Explain the differences between static, void and public in c#?

536

---

What are the advantages of using c#?

513

---

What are constructors in c#?

546

---

What is the usage of OLE?

590

---

What is void in c#?

542

---

---

Differentiate between dataset and datareader?

532

---

explain the three services model commonly know as a three-tier application.

556

---

what is an event? Define delegate?

536

---

What is difference between yielding and sleeping?

462

---

How do you type a null character?

508

---

Is list passed by reference c#?

484

---

how dot net compiled code will become platform independent?

531

---

What operators can be used to cast from one reference type to another without the risk of throwing an exception?

524

---

What are the types of operator?

461

---

What is #region in c#?

510

---