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.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Need Help!!!

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

Posted - 2011-06-16 : 07:11:45
see
http://www.nigelrivett.net/SQLTsql/CSVStringSQL.html


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -