Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ozsql
Starting Member
14 Posts |
 Posted - 2009-09-23 : 22:41:24
|
| Hi Gurus,I am creating DimTable and I got a situation where hierarchy is with postcode. But issue is got two postcodes collect (postcode) and delivery (postcode), now I need to combine both the postcode column for DimLocation table.Can anyone help me out with this.Below is the data: job_no depot col_state col_post col_zone del_state del_post1362941 ALT VIC 3153 MELB VIC 3062SELECT [job_no] ,[depot] ,[col_state] ,[col_post] ,[col_zone] ,[del_state] ,[del_post] FROM [dbo].[Job]Thanks,D |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2009-09-24 : 13:36:51
|
| I'm not sure I'm following your requirements. How do you want to combine the two postcodes? Are you trying to insert that "combination" into the DimLocation table?This link might help you present the data and expected output in a more consumable format that'll make it easier for us to help you: [url]http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx[/url] |
 |
|
|
|
|
|
Adding Columns