Doubt in sqlserver, Date, Time, StaffNo

Posted by Mnrajra under Sql Server on 2/18/2013 | Points: 10 | Views : 804 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Input :
I am having the table
StaffNo Date Time
12333 12-02-2013 09.30
12333 12-02-2013 17.30

13245 12-02-2013 09.15
13245 12-02-2013 10.10
13245 12-02-2013 17.35

14555 12-02-2013 09.10
14555 12-02-2013 10.40
14555 12-02-2013 11.45
14555 12-02-2013 17.30

Output :

12333 12-02-2013 09.30-17.30
13245 12-02-2013 09.15-10.10,17.35
14555 12-02-2013 09.10-10.40,11.45-17.30

Thanks & Regards,
Nirmal.M

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Oswaldlily on: 2/18/2013 [Member] Starter | Points: 25

0	Use (Select distinct ..............) Mnrajra, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Mnrajra on: 2/18/2013 [Member] Starter | Points: 25

0	HOw can i use Comma(,) and Underline (-) using function Pls Help me, Regrd, Nirmal.M Mnrajra, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts