Doubt in sqlserver, Date, Time, StaffNo

Posted by Mnrajra under Sql Server on 2/18/2013 | Points: 10 | Views : 710 | Status : [Member] | Replies : 2
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




Responses

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

Up
0
Down
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

Up
0
Down
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

Login to post response