Last post May 05, 2021 05:15 AM by yij sun
May 04, 2021 09:41 AM|bczm8703|LINK
Below is a sample of my schema design:
<script async="" src="//s.imgur.com/min/embed.js" charset="utf-8"></script>
From the design above, different form might have different template id, I am wondering how do I write a generic query to transpose the rows in TemplateColumn to table column.
i am reading a guide from
here but am still unsure how to implement the query for my sceanrio
Sample of final result I wanted as below
May 05, 2021 05:15 AM|yij sun|LINK
How do you design the sql table? What's result do you need?
I just only tell you that you need "pivot" according to your post to us currently. Could you post us more details?It will help us to solve your problems and give the codes you want.