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

Is nullable type c#?

589

---

What is xor operator in c#?

601

---

How do I stop my console from closing in c#?

550

---

Define using statement in c#?

601

---

what is IFormatable

668

---

---

Can an interface extend a class c#?

605

---

What is xml c#?

569

---

Why ienumerable is used in c#?

535

---

Explain About Iunknown interface Queue

621

---

Explain the steps to create satellite assembly?

572

---

How do I calculate relative time?

587

---

I was trying to use an out int parameter in one of my functions. How should I declare the variable that I am passing to it?

651

---

What is method and function in c#?

577

---

What is the correct way of declaring an xml namespace?

551

---

What is a interface in c#?

548

---