SQL Query Question

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}