Hey I am not a SQl expert, but I am trying to query data and transpose it and am having trouble, here is what I am wanting:
make this
| DateandTime | Val1 | Val2 |
|---|---|---|
| 2020-01-01 00:00:00.000 | 10 | 20 |
look like this
| DateandTime | Tag | Value |
|---|---|---|
| 2020-01-01 00:00:00.000 | Val1 | 10 |
| 2020-01-01 00:00:00.000 | Val2 | 20 |
I am not sure what this kind of change this is called in SQL, but any help would be great.
Thanks
submitted by /u/CodyMythicPC
[link] [comments]
Go to Source of this post
Author Of this post: /u/CodyMythicPC
Title Of post: SQL Query Question
Author Link: {authorlink}
