{"id":30657,"date":"2024-03-13T07:08:00","date_gmt":"2024-03-13T06:08:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=30657"},"modified":"2024-03-13T11:57:38","modified_gmt":"2024-03-13T10:57:38","slug":"sql-server-unpivot-beispiel","status":"publish","type":"post","link":"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/","title":{"rendered":"SQL Server UNPIVOT Beispiel"},"content":{"rendered":"\n<p><strong>Mit diesem T-SQL-Beispiel k\u00f6nnen Sie dank der SQL Server UNPIVOT Funktion ganz einfach Spalten in Zeilen umwandeln.<\/strong><\/p>\n\n\n\n<p>Es ist das genaue Gegenteil der PIVOT-Abfrage. In diesem Beispiel werden nur die ersten sechs Monate des Jahres als Spalten verwendet, n\u00e4mlich Januar bis Juni. Sie k\u00f6nnen jedoch die Abfrage auf alle 12 Perioden des Jahres erweitern, indem Sie die fehlenden hinzuf\u00fcgen.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#1-daten-erstellen-um-sie-mit-dem-unpivot-operator-in-zeilen-umzuwandeln\" >1. Daten erstellen, um sie mit dem UNPIVOT-Operator in Zeilen umzuwandeln<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#2-daten-in-die-quelltabelle-einfuegen-um-sie-zu-transformieren\" >2. Daten in die Quelltabelle einf\u00fcgen, um sie zu transformieren<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#3-sql-server-unpivot-abfrage-um-spalten-in-zeilen-umzuwandeln\" >3. SQL Server UNPIVOT-Abfrage, um Spalten in Zeilen umzuwandeln<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-daten-erstellen-um-sie-mit-dem-unpivot-operator-in-zeilen-umzuwandeln\"><span class=\"ez-toc-section\" id=\"1-daten-erstellen-um-sie-mit-dem-unpivot-operator-in-zeilen-umzuwandeln\"><\/span>1. Daten erstellen, um sie mit dem UNPIVOT-Operator in Zeilen umzuwandeln<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Die SQL Server Verkaufstabelle enth\u00e4lt beispielsweise eine Typspalte und die Monatsspalten. Diese enthalten jeweils den Typ und den Betrag der Verk\u00e4ufe f\u00fcr den Monat. Zum Starten kopieren und f\u00fcgen Sie einfach die SQL-Abfrage f\u00fcr die Tabellenerstellung in SSMS ein.<\/p>\n\n\n\n<p><strong>Zuerst erstellen Sie die Beispieltabelle mit diesem Skript, kopieren und f\u00fcgen Sie das Beispiel einfach in Ihr SQL Server Management Studio Fenster ein.<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Zuerst l\u00f6schen Sie die Tabelle Verk\u00e4ufe nach Monat, falls sie bereits in der DB existiert\nIF EXISTS( \n\tSELECT 1 FROM sys.objects\n     WHERE object_id = object_id(N'[dbo].[SALES_BY_MONTH]')\n\t\tAND type in (N'U') )\n-- BEGIN DROP TABLE [dbo].[SALES_BY_MONTH]\nEND;\n\n-- Erstellen Sie die VERKAUFE Tabelle\nCREATE table [dbo].[SALES_BY_MONTH] (\n    [SalesType] NVARCHAR(20),\n    [January] NUMERIC(5),\n    [February] NUMERIC(5),\n    [March] NUMERIC(5),\n    [April] NUMERIC(5),\n    [May] NUMERIC(5),\n    [June] NUMERIC(5)\n);\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-daten-in-die-quelltabelle-einfugen-um-sie-zu-transformieren\"><span class=\"ez-toc-section\" id=\"2-daten-in-die-quelltabelle-einfuegen-um-sie-zu-transformieren\"><\/span>2. Daten in die Quelltabelle einf\u00fcgen, um sie zu transformieren<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>Als N\u00e4chstes f\u00fcgen Sie die Daten in die Tabelle ein, die transponiert werden soll. Jede SQL-Dateneinf\u00fcgung f\u00fcgt 12 neue Verkaufsbetr\u00e4ge hinzu. Eine Spalte pro Monat, mit dem zugeh\u00f6rigen Verkaufstyp.<\/strong><\/p>\n\n\n\n<p>F\u00fcgen Sie die fehlenden Monate hinzu, falls n\u00f6tig. So k\u00f6nnen Sie die 12 Monate des Jahres in einer einzigen SQL Server Abfrage von Spalten in Zeilen umwandeln.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Einf\u00fcgen von Beispielsdaten f\u00fcr jeden Monat: d.h. von Januar bis Juni\n-- Die Monatsspalten werden von Spalten in Zeilen umgewandelt\nINSERT INTO dbo.SALES_BY_MONTH ( [SalesType], [January], [February], [March], [April], [May], [June] )\nVALUES ( N'Sales', 1000, 2000, 3000, 4000, 5000, 6000);\n\nINSERT INTO dbo.SALES_BY_MONTH ( [SalesType], [January], [February], [March], [April], [May], [June] )\nVALUES ( N'Discounts', 100, 200, 300, 400, 500, 600);\n\nINSERT INTO dbo.SALES_BY_MONTH ( [SalesType], [January], [February], [March], [April], [May], [June] )\nVALUES ( N'Offers', 10, 20, 30, 40, 50, 60);\n\n-- \u00dcberpr\u00fcfen Sie die eingef\u00fcgten Zeilen in der Verkaufstabelle\nSELECT * \nFROM   dbo.SALES_BY_MONTH;<\/pre>\n\n\n<div class=\"wp-block-image wp-image-394 size-full\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/expert-only.net\/wp-content\/uploads\/2017\/06\/UNPIVOT-Source-Table-SQL-Server.png\" alt=\"Daten einf\u00fcgen, um sie mit T-SQL UNPIVOT von Spalten in Zeilen zu transformieren\" class=\"wp-image-394\"\/><figcaption class=\"wp-element-caption\"><em>Daten einf\u00fcgen, um sie mit T-SQL UNPIVOT von Spalten in Zeilen zu transformieren<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-sql-server-unpivot-abfrage-um-spalten-in-zeilen-umzuwandeln\"><span class=\"ez-toc-section\" id=\"3-sql-server-unpivot-abfrage-um-spalten-in-zeilen-umzuwandeln\"><\/span>3. SQL Server UNPIVOT-Abfrage, um Spalten in Zeilen umzuwandeln<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Schlie\u00dflich besteht die SQL Server UNPIVOT-Funktion aus 3 verschiedenen Schritten, um die Spalten in Zeilen zu transponieren.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Die Auswahl der 3 Ergebnisspalten, d.h. Typ, Monat und Betrag.<\/li>\n\n\n\n<li>Dann die SQL-Unterabfrage mit der urspr\u00fcnglichen Datenauswahl.<\/li>\n\n\n\n<li>Die UNPIVOT-Operation selbst mit den 6 explizit benannten Monaten.<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- UNPIVOT Spalten zu Zeilen mit SQL-Abfrage\nSELECT [TYPE], Monat, Betrag\nFROM (\t\n\tSELECT [TYPE], [January], [February], [March], [April], [May], [June]\n\tFROM dbo.SALES_BY_MONTH \t) sbm\nUNPIVOT\n   (Betrag FOR Monat IN \n      ([January], [February], [March], [April], [May], [June])\n)AS SalesUnPivot;\n<\/pre>\n\n\n<div class=\"wp-block-image wp-image-395 size-full\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/expert-only.net\/wp-content\/uploads\/2017\/06\/SQL-Server-UNPIVOT-Columns-To-Rows.png\" alt=\"SQL Server UNPIVOT Beispielabfrage in SSMS\" class=\"wp-image-395\"\/><figcaption class=\"wp-element-caption\"><em>SQL Server UNPIVOT Beispielabfrage in SSMS<\/em><\/figcaption><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-uber-die-pivot-und-unpivot-operatoren-von-sql-server\">\u00dcber die PIVOT- und UNPIVOT-Operatoren von SQL Server<\/h3>\n\n\n\n<p>Falls Sie immer noch Schwierigkeiten mit diesem SQL Server UNPIVOT-Operator und seiner Syntax haben, kopieren und f\u00fcgen Sie einfach das Beispiel ein und wiederholen die drei Schritte, indem Sie sie an Ihren realen Fall anpassen. Beginnen Sie damit, die Spalten umzubenennen, um zu verstehen, wie es funktioniert. Abschlie\u00dfend ist die offizielle Microsoft-Dokumentation f\u00fcr die <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/from-using-pivot-and-unpivot?view=sql-server-2017\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">unpivot-Funktion<\/a> verf\u00fcgbar. UNPIVOT ist das Gegenteil der <a href=\"https:\/\/dictionary.cambridge.org\/dictionary\/english\/pivot\" target=\"_blank\" rel=\"noreferrer noopener\">PIVOT<\/a>-Funktion, hier ist ein weiteres kurzes Tutorial zur Verwendung der <a href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-pivot-rows-to-columns-in-sql-server\/\"><strong>SQL Server PIVOT-Funktion<\/strong><\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"8cPNqFz0gi\"><a href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-pivot-rows-to-columns-in-sql-server\/\">How to Pivot Rows To Columns in SQL Server ? Simple Query<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8222;How to Pivot Rows To Columns in SQL Server ? Simple Query&#8220; &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-pivot-rows-to-columns-in-sql-server\/embed\/#?secret=4UUtY83tLM#?secret=8cPNqFz0gi\" data-secret=\"8cPNqFz0gi\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Verwenden Sie den UNPIVOT-Operator von SQL Server, um Quelldaten von Spalten in Zeilen umzuwandeln. <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/\" title=\"SQL Server UNPIVOT Beispiel\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":30663,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[697],"tags":[],"class_list":{"0":"post-30657","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server UNPIVOT Beispiel - T-SQL<\/title>\n<meta name=\"description\" content=\"Verwenden Sie das Beispiel des SQL Server UNPIVOT-Operators in einer Abfrage, um Daten von Spalten in Zeilen zu konvertieren.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server UNPIVOT Beispiel\" \/>\n<meta property=\"og:description\" content=\"Verwenden Sie das Beispiel des SQL Server UNPIVOT-Operators in einer Abfrage, um Daten von Spalten in Zeilen zu konvertieren.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-13T06:08:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-13T10:57:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/melbourne-city-buidings-lights-C6A5E117A05_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"3\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/de\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"SQL Server UNPIVOT Beispiel\",\"datePublished\":\"2024-03-13T06:08:00+00:00\",\"dateModified\":\"2024-03-13T10:57:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/\"},\"wordCount\":380,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/de\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/melbourne-city-buidings-lights-C6A5E117A05_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/\",\"url\":\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/\",\"name\":\"SQL Server UNPIVOT Beispiel - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/melbourne-city-buidings-lights-C6A5E117A05_1920x1080.jpg\",\"datePublished\":\"2024-03-13T06:08:00+00:00\",\"dateModified\":\"2024-03-13T10:57:38+00:00\",\"description\":\"Verwenden Sie das Beispiel des SQL Server UNPIVOT-Operators in einer Abfrage, um Daten von Spalten in Zeilen zu konvertieren.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/melbourne-city-buidings-lights-C6A5E117A05_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/melbourne-city-buidings-lights-C6A5E117A05_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server UNPIVOT Beispiel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/de\/#website\",\"url\":\"https:\/\/expert-only.com\/de\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/de\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/expert-only.com\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/de\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/de\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/expert-only.com\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server UNPIVOT Beispiel - T-SQL","description":"Verwenden Sie das Beispiel des SQL Server UNPIVOT-Operators in einer Abfrage, um Daten von Spalten in Zeilen zu konvertieren.","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:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/","og_locale":"de_DE","og_type":"article","og_title":"SQL Server UNPIVOT Beispiel","og_description":"Verwenden Sie das Beispiel des SQL Server UNPIVOT-Operators in einer Abfrage, um Daten von Spalten in Zeilen zu konvertieren.","og_url":"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-13T06:08:00+00:00","article_modified_time":"2024-03-13T10:57:38+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/melbourne-city-buidings-lights-C6A5E117A05_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Verfasst von":"Expert-Only","Gesch\u00e4tzte Lesezeit":"3\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/de\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"SQL Server UNPIVOT Beispiel","datePublished":"2024-03-13T06:08:00+00:00","dateModified":"2024-03-13T10:57:38+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/"},"wordCount":380,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/de\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/melbourne-city-buidings-lights-C6A5E117A05_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/","url":"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/","name":"SQL Server UNPIVOT Beispiel - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/melbourne-city-buidings-lights-C6A5E117A05_1920x1080.jpg","datePublished":"2024-03-13T06:08:00+00:00","dateModified":"2024-03-13T10:57:38+00:00","description":"Verwenden Sie das Beispiel des SQL Server UNPIVOT-Operators in einer Abfrage, um Daten von Spalten in Zeilen zu konvertieren.","breadcrumb":{"@id":"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/melbourne-city-buidings-lights-C6A5E117A05_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/melbourne-city-buidings-lights-C6A5E117A05_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/de\/t-sql\/sql-server-unpivot-beispiel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/de\/"},{"@type":"ListItem","position":2,"name":"SQL Server UNPIVOT Beispiel"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/de\/#website","url":"https:\/\/expert-only.com\/de\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/de\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/expert-only.com\/de\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/de\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/de\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/expert-only.com\/de\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/de\/wp-json\/wp\/v2\/posts\/30657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/de\/wp-json\/wp\/v2\/comments?post=30657"}],"version-history":[{"count":1,"href":"https:\/\/expert-only.com\/de\/wp-json\/wp\/v2\/posts\/30657\/revisions"}],"predecessor-version":[{"id":30662,"href":"https:\/\/expert-only.com\/de\/wp-json\/wp\/v2\/posts\/30657\/revisions\/30662"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/de\/wp-json\/wp\/v2\/media\/30663"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/de\/wp-json\/wp\/v2\/media?parent=30657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/de\/wp-json\/wp\/v2\/categories?post=30657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/de\/wp-json\/wp\/v2\/tags?post=30657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}