September 23, 2009 at 8:39 pm
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 depotcol_state col_post col_zone del_state del_post
1362941 ALT VIC 3153 MELB VIC 3062
SELECT [job_no]
,[depot]
,[col_state]
,[col_post]
,[col_zone]
,[del_state]
,[del_post]
FROM [dbo].[Job]
Thanks,
D
September 23, 2009 at 9:31 pm
Have you tried looking this up? Or even taking a guess? It's really terribly awfully simple.
I'm guessing this is part of a homework assignment or a take-home quiz. Yes?
Your example doesn't say whether the post codes are integer data or character data. Neither do you say what you expect your output to look like. Nobody can read your mind and quite a few are unwilling to start guessing. For more complex problems in the future, you will get better results if you follow the guidelines found here[/url].
Just put a little more effort in and someone will give you the answer if you don't figure it out yourself.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply