I have been searching for this for quite sometime, but all the clips I found did not explained it clearly. But yours is easy to understand thank you so much this helped me alot!
@@BeardedDevData just as in this example, where we have id, attribute and multiple values: 1 Master bedroom size 5x5 1 Master bedroom size 100x100 Result should be: [id] [Master bedroom size] ... 1 5x5; 100x100 ... It would be great to see that in some future video. Thanks so much for your work!
The best SQL tutorials of what I found so far
Thanks so much
I have been searching for this for quite sometime, but all the clips I found did not explained it clearly. But yours is easy to understand thank you so much this helped me alot!
That's so good to hear, glad I could help.
Thank you! You are a life saver sparing me headaches.
You're pretty good.
Looking forward to dynamic pivoting as in my context the number of elements varies and will be enumerated by a window function.
Thanks so much for this, just so know you, I watched all the horrible commercials so you would get a small revenue from this.😁
Thank you.
Is it possible to concatenate values, like '5x5; 100x100' ?
You can concatenate before in the table expression or the results of the pivot operation. If you can give me more details I can explain more.
@@BeardedDevData just as in this example, where we have id, attribute and multiple values:
1 Master bedroom size 5x5
1 Master bedroom size 100x100
Result should be:
[id] [Master bedroom size] ...
1 5x5; 100x100
...
It would be great to see that in some future video.
Thanks so much for your work!
Boo
Dude thanks a million