{"id":30696,"date":"2023-01-16T13:22:39","date_gmt":"2023-01-16T07:52:39","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/"},"modified":"2023-01-16T13:22:39","modified_gmt":"2023-01-16T07:52:39","slug":"solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/","title":{"rendered":"[Solved] Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-36354278\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"36354278\" data-parentid=\"36352791\" data-score=\"1\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>Here is my explanation for this script<\/p>\n<p>following creates a sample database table containing an object (name) and its dependends on an other field (DependsOnCSV) seperated by comma<\/p>\n<pre><code>CREATE TABLE tbl (Name VARCHAR(100),DependsOnCSV VARCHAR(100))\n<\/code><\/pre>\n<p>Following code populates above table with sample data. This is a new syntax for many developers. If you are working with a prier version of SQL2012 you might have to convert it into INSERT INTO .. SELECT &#8230; for each row<\/p>\n<pre><code>INSERT INTO tbl\nVALUES\n    ('a','b,c'),\n    ('b','d'),\n    ('c',''),\n    ('d',''),\n    ('e','g'),\n    ('f','b,e,a,g'),\n    ('g',''),\n    ('h','a')\n<\/code><\/pre>\n<p>Below function is used to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/www.kodyaz.com\/articles\/t-sql-convert-split-delimeted-string-as-rows-using-xml.aspx\">split string values in SQL<\/a>. You can find many similar functions. SQL Server 2016 is being shipped with a built-in split function<\/p>\n<pre><code>CREATE FUNCTION Split\n(\n  @delimited nvarchar(max),\n  @delimiter nvarchar(100)\n) RETURNS @t TABLE\n(\n  id int identity(1,1),\n  val nvarchar(max)\n)\nAS\nBEGIN\n  declare @xml xml\n  set @xml = N'&lt;root&gt;&lt;r&gt;' + replace(@delimited,@delimiter,'&lt;\/r&gt;&lt;r&gt;') + '&lt;\/r&gt;&lt;\/root&gt;'\n\n  insert into @t(val)\n  select \n    r.value('.','varchar(5)') as item\n  from @xml.nodes('\/\/root\/r') as records(r)\n\n  RETURN\nEND\nGO\n<\/code><\/pre>\n<p>This SELECT statements returns objects with each of their dependens by splitting the DependendOnCVS column by &#8220;,&#8221; comma<\/p>\n<pre><code>SELECT\n  tbl.Name,\n  split.val AS [DependsOn-Rows]\nFROM tbl AS tbl\nCROSS APPLY dbo.Split(tbl.DependsOnCSV,',') split\n<\/code><\/pre>\n<p>I hope the above code is readable now<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Here is my explanation for this script following creates a sample database table containing an object (name) and its dependends on an other field (DependsOnCSV) seperated by comma CREATE TABLE tbl (Name VARCHAR(100),DependsOnCSV VARCHAR(100)) Following code populates above table with sample data. This is a new syntax for many developers. If you are working &#8230; <a title=\"[Solved] Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/\" aria-label=\"More on [Solved] Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[483,546,500,577],"class_list":["post-30696","post","type-post","status-publish","format-standard","hentry","category-solved","tag-csv","tag-database","tag-sql-server","tag-xml"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>[Solved] Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Here is my explanation for this script following creates a sample database table containing an object (name) and its dependends on an other field (DependsOnCSV) seperated by comma CREATE TABLE tbl (Name VARCHAR(100),DependsOnCSV VARCHAR(100)) Following code populates above table with sample data. This is a new syntax for many developers. If you are working ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-16T07:52:39+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\\\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/person\\\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work\",\"datePublished\":\"2023-01-16T07:52:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\\\/\"},\"wordCount\":158,\"publisher\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\"},\"keywords\":[\"csv\",\"database\",\"sql-server\",\"xml\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\\\/\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\\\/\",\"name\":\"[Solved] Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work - JassWeb\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#website\"},\"datePublished\":\"2023-01-16T07:52:39+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#website\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/jassweb.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/jass-website-logo-1.png\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/person\\\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\\\/\\\/jassweb.com\"],\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/author\\\/jaspritsinghghumangmail-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work - JassWeb","og_description":"[ad_1] Here is my explanation for this script following creates a sample database table containing an object (name) and its dependends on an other field (DependsOnCSV) seperated by comma CREATE TABLE tbl (Name VARCHAR(100),DependsOnCSV VARCHAR(100)) Following code populates above table with sample data. This is a new syntax for many developers. If you are working ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/","og_site_name":"JassWeb","article_published_time":"2023-01-16T07:52:39+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work","datePublished":"2023-01-16T07:52:39+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/"},"wordCount":158,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["csv","database","sql-server","xml"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/","url":"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/","name":"[Solved] Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-01-16T07:52:39+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-convert-csv-values-into-table-rows-using-xml-can-anyone-please-explain-how-below-mentioned-queries-will-work\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Convert csv values into table rows using xml. Can anyone please explain how below mentioned queries will work"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/30696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=30696"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/30696\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=30696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=30696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=30696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}