one colum into multiple rows sql server

Sometimes, you would want to split values in a column into separate rows  in SQL server.  This is a simple guide. Lets check the fields in the table we will be working with.

Let’s check the result:   We can see that the itemType field has different values wheres as the price and quantity…