]]>By: sprocedurehttp://itknowledgeexchange.techtarget.com/itanswers/to-write-a-stored-procedure/#comment-78008
Wed, 09 Jun 2010 18:53:03 +0000#comment-78008oaky not a sp but a query I am looking for
]]>By: sprocedurehttp://itknowledgeexchange.techtarget.com/itanswers/to-write-a-stored-procedure/#comment-78007
Wed, 09 Jun 2010 18:52:33 +0000#comment-78007Okay here is what I am looking for

1. I have two tables Zipcode and a temp .
2. Zipcode has many columns along with Zipcode and CongDist
3. I need a temp table to store only Zipcode and CongDist
4. They was the values are stored in Zipcode table is Zipcode = 44819 and CongDist = 15|13|14
5. So what it means is Zipcode 44819 has 3 CongDist
6. I want to seperate each CongDist as a seperate entry in temp table
7. So the way it should store in temp table is each entry for 44819 and 15, 44819 and 13, 44819 and 14