what is the format mapping table

See more:

ASP.NET

SQL

server

Hi,
I have a mapping table. It contains following fields and Records.

ID     LocationID    DeviceID
1 	 1	      16,15,
3	 2	      17,15,
4	 3	      16,18,
5	 4	      15,17,

Only one location has differen devices. That's why I save it with comma seperator.
That is a correct method or not. Otherwise we save it in to different rows for every device id like following.

ID     LocationID    DeviceID
1	1	       16
2	1	       15
3	2	       17
4	2	       15
5	3	       16
6       3              18
7       4              15
8       4              17

What is the correct method? Anybody can suggest me?