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 is “using” statement in c#?

1063

---

What is the concept of strong names?

988

---

Is string mutable in c#?

878

---

What are the Types of configuration files and their differences

1083

---

What is tryparse?

947

---

Difference between value and reference type. What are value types and reference types?

1000

---

While debugging a C# application can you change the value of a variable?

1046

---

What is meaning of type safety in c#?

861

---

What are primitive types in c#?

983

---

In .NET which is the smallest unit of execution?

1070

---

What is asp net in c#?

955

---

What is anonymous method in c#?

906

---

Difference between directcast and ctype.

1027

---

When can a derived class override a base class member?

899

---

What is the process of delegation?

981

---