Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GaneshRamanan
Starting Member
40 Posts |
 Posted - 2011-06-16 : 07:07:32
|
Hi,
I have the Data in Table
RowId,EmpNo,Status,Time
1,245,B,'2009-10-21 12:15:32.960'
2,245,C,'2009-10-21 12:15:32.960'
I wants the output like this,can anyone help me...
rowid,empno,btime,ctime
1,245,'2009-10-21 12:15:32.960','2009-10-21 12:15:32.960'
can any one give me some ideas...to do this...
Thanks in Advance,
Ganesh Ramanan |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
|
|
|
|
|
Need Help!!!