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

What framework is used for performance testing/load testing?

1903

---

What are properties in c#. Explain with an example?

851

---

Why do we need delegates?

827

---

What are methods in C#?

900

---

What is the difference between finalize() and dispose() methods?

942

---

Is system a class in c#?

873

---

What is the difference between virtual and override in c#?

973

---

What is an array of arrays called?

822

---

Can you have parameters for static constructors?

892

---

What does the parsefloat function do?

870

---

What is msil in c#?

900

---

Define method overloading in c#?

929

---

Why do we use lambda expression in c#?

897

---

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

932

---

What is difference between c and c sharp?

874

---