Answer / 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 the difference between protected and internal in c#?

0 Answers  

---

What is the property of class?

0 Answers   Wipro,

---

What is short circuit logical evaluation?

1 Answers   TCS,

---

what is diffrence between protected ,internal and protected internal?? whether protected field available in derived class which is outside the assembly. if not ..this is possible by which access modifiers??

2 Answers  

---

What is hiding in CSharp ?

1 Answers  

---

---

How?s the DLL Hell problem solved in .NET?

1 Answers   Visual Soft,

---

Explain About web methods and its various attributes

0 Answers   Digital GlobalSoft,

---

What is public, private, protected, internal and internal protected?

0 Answers   QuestPond,

---

What does void do in unity?

0 Answers  

---

What is the difference while using directive vs using statement ?

0 Answers  

---

can a structure used in a class if yes then how.

2 Answers   Synechron,

---

Which property of the textbox cannot be changed at runtime?

0 Answers  

---