Doubt in sqlserver, Date, Time, StaffNo

Posted by Mnrajra under Sql Server on 2/18/2013 | Points: 10 | Views : 785 | 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

dowload pdf files from server to local .asp.net mvc (0)New
Get +1-833-445-7444 Verizon Email Customer Support Number (0)New
specific cast is not valid in linq query when compare two tables (0)New
SEO(Search Engine Optimization) (0)New
Dial Hotmail Customer service Number +1-800-518-0963 (0)New
Best Assignment Help Services Provider (0)
How can a video in the website explain the navbar values? (1)
surge arresters price (1)Updated
More ...