I'm utterly stuck and desperately need help from someone with more experience.
I have a table with a locale column (that can only have two values) and need to transform it into a table with one column for each of the two locales. Here's a simple but a complete example:
the following table
_________________________
key | name | locale
-------------------------
1 | oneEng | eng
1 | oneSwe | swe
2 | twoEng | eng
3 | threeSwe | swe
needs to be transformed into this:
__________________________
key | engName | sweName
--------------------------
1 | oneEng | oneSwe
2 | twoEng | (NULL)
3 | (NULL) | threeSwe
Obviously, the problematic thing is that some entries only have a version for one locale and not both...
Any ideas how to do this? Or a confirmation that it's impossible... I'd greatly appreciate it.
Edited 1 time(s). Last edit at 03/16/2010 05:06PM by Bojan Tomic.