Hi all,

Could someone tell me a way I can convert my data here...
http://users.bigpond.net.au/randombeings/example.txt
....into two numerical columns like this?
http://users.bigpond.net.au/randombeings/example2.txt

The data I have has multiple CategoryIDs for some RestaurantIDs. Rather than
being comma separated in a nvarchar field, I would like those multiple
CategoryIDs converted to multiple rows with the RestaurantID repeated.

Any help would be much appreciated.

Thx,
Offal Eater.

Something like this then

Processing The Same Row More Than Once
(http://www.sqldts.com/default.aspx?266)
--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Offal Eater" <drear80 (AT) hotmail (DOT) com.nospam> wrote