Hai
I am Shiva from TN, SSE.I have an query problem.
My Table : Door Field :
ID,DoorID,ZoneID,Date,Time,Status.
Problem was : Status.We got two values, one is 00
(OUTTIME) , Another is 01(INTIME)
Like this
Status
---------
00
01
00
01
00
01
00
01
How to Set as Status 00 and 01 , of separate column ,
Status as Intime,Status as Outtime
Like this
-----------
InTime OutTime
---------- -----------
01 00
01 00
01 00
01 00
01 00
01 00
Regards
KS kumar
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
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a system lock?
What is private static in c#?
Is a valid int value?
what is difference between is and as operators in c#?
How do you prevent a method from being overridden in c#?
What is thread and explain states of a thread in c#?
What is concrete class in c# with example?
How do I get deterministic finalization in c#?
Explain manifest in c#.
Difference between direct type casting and using "as" keyword?
What is lazy loading entity framework?
What is cli in c#?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)