‘COL’+CAST(ROW(Person.ID) AS VARCHAR(MAX)) You could use this column in a query like the following to create an output like you have stated, if you want: What this will do is take the Person.ID field and create a new ordered list in a column. If you have a table called “Person” in your database, you can use a query like the following to make a new table called “Person2”: I have a list of values (rows) and need to turn it into a table (columns). Samsung Tools V2 1.0 7 Hwk By Sarassoft.Q:Ĭonverting rows in a SQL Database to columns Samsung tools v2 2.0.0.3 hwk by sarassoft full version Samsung tools v2 2.0.0.3 hwk by sarassoft free Samsung tools v2.2.0.3 hwk by sarassoft free Samsung tools v2.2.0.3 hwk by sarassoft full version
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |