SQL Server knowledge center

SQL Server knowledge centerhttp://geeks.netindonesia.net/blogs/kasim.wirama/default.aspxeverything about SQL ServerenCommunityServer 2007.1 (Build: 20917.1142)seputar webhttp://geeks.netindonesia.net/blogs/kasim.wirama/archive/2013/01/18/seputar-web.aspxThu, 17 Jan 2013 18:51:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:194699Kasim.Wirama0http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=194699http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2013/01/18/seputar-web.aspx#commentshttp://brockallen.com/2012/04/07/think-twice-about-using-session-state/ http://www.develop.com/training-course/asp.net-mvc-4-training http://www.cloudydeveloper.com/differences-between-asp-net-web-api-and-asp-net-mvc-routing/ http://pfelix.wordpress.com/2012/03/05/asp-net-web-api-in-memory-hosting/ <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2013/01/18/seputar-web.aspx&subject=seputar web" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2013/01/18/seputar-web.aspx&t=seputar+web" target="_blank" title="Submit seputar web to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2013/01/18/seputar-web.aspx&title=seputar+web" target="_blank" title="Submit seputar web to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2013/01/18/seputar-web.aspx&phase=2" target="_blank" title="Submit seputar web to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2013/01/18/seputar-web.aspx&title=seputar+web" target="_blank" title="Add seputar web to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=194699" width="1" height="1">Fitur T-SQL Window Function Terbaru dari SQL Denalihttp://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/07/fitur-t-sql-window-function-terbaru-dari-sql-denali.aspxWed, 07 Sep 2011 12:40:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:193045Kasim.Wirama0http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=193045http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/07/fitur-t-sql-window-function-terbaru-dari-sql-denali.aspx#comments<font size="3" face="Times New Roman"> </font><h1 style="margin:24pt 0in 0pt;text-align:center;" align="center"><font size="5"><font color="#365f91"><font face="Cambria">Fitur T-SQL Window Function Terbaru dari SQL Denali</font></font></font></h1><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;text-align:center;" class="MsoNormal" align="center"><font size="3"><font face="Calibri">By : Kasim Wirama, MCDBA, MCITP</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Di sisi perkembangan fitur T-SQL Window function, SQL Denali menghadirkan pengembangan lebih lanjut dari window function. Yang anda butuhkan untuk menjalankan contoh-contoh query di artikel ini adalah anda perlu mendownload AdventureWorks2008 untuk database Denali.</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Berikut penerapan window function lewat contoh-contoh di bawah ini. Untuk mengerti contoh-contoh yang diberikan sebaiknya anda menjalankan query tersebut di SQL Denali.</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;text-indent:-0.25in;mso-list:l0 level1 lfo1;" class="MsoListParagraphCxSpFirst"><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;"><span style="mso-list:Ignore;"><font size="3" face="Calibri">1.</font><span style="font-size-adjust:none;font-stretch:normal;">       </span></span></span><font face="Calibri"><font size="3">Inovasi window function untuk mendapatkan running total lewat fungsi window function SUM(<nama kolom>) OVER (PARTITION BY <nama kolom> ORDER BY <nama kolom> ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW).</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt 0.5in;" class="MsoListParagraphCxSpLast"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-layout-grid-align:none;" class="MsoNormal"><span style="color:blue;font-size:10pt;mso-no-proof:yes;">select</span><span style="font-size:10pt;mso-no-proof:yes;"> CustomerID<span style="color:gray;">,</span> OrderDate<span style="color:gray;">,</span> TotalDue<span style="color:gray;">,</span> </span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-layout-grid-align:none;" class="MsoNormal"><span style="color:fuchsia;font-size:10pt;mso-no-proof:yes;">sum</span><span style="color:gray;font-size:10pt;mso-no-proof:yes;">(</span><span style="font-size:10pt;mso-no-proof:yes;">TotalDue<span style="color:gray;">)</span> <span style="color:blue;">over </span><span style="color:gray;">(</span><span style="color:blue;">partition</span> <span style="color:blue;">by</span> CustomerID <span style="color:blue;">order</span> <span style="color:blue;">by</span> OrderDate <span style="color:blue;">rows</span> <span style="color:gray;">between</span> unbounded preceding <span style="color:gray;">and</span> <span style="color:blue;">current</span> <span style="color:blue;">row</span><span style="color:gray;">)</span> <span style="color:blue;">as</span> running_total</span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpFirst"><span style="color:blue;line-height:115%;font-size:10pt;mso-no-proof:yes;">from</span><span style="line-height:115%;font-size:10pt;mso-no-proof:yes;"> Sales<span style="color:gray;">.</span>SalesOrderHeader</span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3"><font face="Calibri">Query di atas akan menampilkan running total untuk kolom TotalDue setiap customer.</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;text-indent:-0.25in;mso-list:l0 level1 lfo1;" class="MsoListParagraphCxSpMiddle"><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;"><span style="mso-list:Ignore;"><font size="3" face="Calibri">2.</font><span style="font-size-adjust:none;font-stretch:normal;">       </span></span></span><font face="Calibri"><font size="3">Inovasi window function untuk mendapatkan nilai sebelum dan nilai sesudah lewat fungsi window function LAG(<nama kolom>) OVER (PARTITION BY <nama kolom> ORDER BY <nama kolom>) dan LEAD(<nama kolom>) OVER (PARTITION BY <nama kolom> ORDER BY <nama kolom>).</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt 0.5in;" class="MsoListParagraphCxSpLast"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-layout-grid-align:none;" class="MsoNormal"><span style="color:blue;font-size:10pt;mso-no-proof:yes;">select</span><span style="font-size:10pt;mso-no-proof:yes;"> CustomerID<span style="color:gray;">,</span> OrderDate<span style="color:gray;">,</span> TotalDue<span style="color:gray;">,</span> </span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-layout-grid-align:none;" class="MsoNormal"><span style="font-size:10pt;mso-no-proof:yes;">lag<span style="color:gray;">(</span>TotalDue<span style="color:gray;">)</span> <span style="color:blue;">over </span><span style="color:gray;">(</span><span style="color:blue;">partition</span> <span style="color:blue;">by</span> CustomerID <span style="color:blue;">order</span> <span style="color:blue;">by</span> OrderDate<span style="color:gray;">,</span> SalesOrderID<span style="color:gray;">)</span> <span style="color:blue;">as</span> previous_TotalDue<span style="color:gray;">,</span></span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-layout-grid-align:none;" class="MsoNormal"><span style="font-size:10pt;mso-no-proof:yes;">lead<span style="color:gray;">(</span>TotalDue<span style="color:gray;">)</span> <span style="color:blue;">over </span><span style="color:gray;">(</span><span style="color:blue;">partition</span> <span style="color:blue;">by</span> CustomerID <span style="color:blue;">order</span> <span style="color:blue;">by</span> OrderDate<span style="color:gray;">,</span> SalesOrderID<span style="color:gray;">)</span> <span style="color:blue;">as</span> next_TotalDue</span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpFirst"><span style="color:blue;line-height:115%;font-size:10pt;mso-no-proof:yes;">from</span><span style="line-height:115%;font-size:10pt;mso-no-proof:yes;"> Sales<span style="color:gray;">.</span>SalesOrderHeader</span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3"><font face="Calibri">Query di atas akan menampilkan nilai sebelum dan sesudah TotalDue pada setiap row.</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;text-indent:-0.25in;mso-list:l0 level1 lfo1;" class="MsoListParagraphCxSpMiddle"><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;"><span style="mso-list:Ignore;"><font size="3" face="Calibri">3.</font><span style="font-size-adjust:none;font-stretch:normal;">       </span></span></span><font face="Calibri"><font size="3">Inovasi window function untuk mendapatkan nilai pertama dalam sebuah partisi lewat fungsi window function FIRST_VALUE(<nama kolom>) OVER (PARTITION BY <nama kolom> ORDER BY <nama kolom>)</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt 0.5in;" class="MsoListParagraphCxSpLast"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-layout-grid-align:none;" class="MsoNormal"><span style="color:blue;font-size:10pt;mso-no-proof:yes;">select</span><span style="font-size:10pt;mso-no-proof:yes;"> CustomerID<span style="color:gray;">,</span> OrderDate<span style="color:gray;">,</span> TotalDue<span style="color:gray;">,</span> </span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-layout-grid-align:none;" class="MsoNormal"><span style="font-size:10pt;mso-no-proof:yes;">first_value<span style="color:gray;">(</span>TotalDue<span style="color:gray;">)</span> <span style="color:blue;">over </span><span style="color:gray;">(</span><span style="color:blue;">partition</span> <span style="color:blue;">by</span> CustomerID <span style="color:blue;">order</span> <span style="color:blue;">by</span> OrderDate<span style="color:gray;">,</span> SalesOrderID<span style="color:gray;">)</span> <span style="color:blue;">as</span> first_TotalDue</span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpFirst"><span style="color:blue;line-height:115%;font-size:10pt;mso-no-proof:yes;">from</span><span style="line-height:115%;font-size:10pt;mso-no-proof:yes;"> Sales<span style="color:gray;">.</span>SalesOrderHeader</span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3"><font face="Calibri">Query di atas akan menampilkan nilai pertama untuk setiap customerID berdasarkan nilai terkecil dari OrderDate dan SalesOrderID</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;text-indent:-0.25in;mso-list:l0 level1 lfo1;" class="MsoListParagraphCxSpMiddle"><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;"><span style="mso-list:Ignore;"><font size="3" face="Calibri">4.</font><span style="font-size-adjust:none;font-stretch:normal;">       </span></span></span><font face="Calibri"><font size="3">Inovasi window function untuk mendapatkan nilai terakhir dalam sebuah partisi lewat fungsi window function LAST_VALUE(<nama kolom>) OVER (PARTITION BY <nama kolom> ORDER BY <nama kolom>)</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt 0.5in;" class="MsoListParagraphCxSpLast"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-layout-grid-align:none;" class="MsoNormal"><span style="color:blue;font-size:10pt;mso-no-proof:yes;">select</span><span style="font-size:10pt;mso-no-proof:yes;"> CustomerID<span style="color:gray;">,</span> OrderDate<span style="color:gray;">,</span> TotalDue<span style="color:gray;">,</span> </span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-layout-grid-align:none;" class="MsoNormal"><span style="font-size:10pt;mso-no-proof:yes;">last_value<span style="color:gray;">(</span>TotalDue<span style="color:gray;">)</span> <span style="color:blue;">over </span><span style="color:gray;">(</span><span style="color:blue;">partition</span> <span style="color:blue;">by</span> CustomerID <span style="color:blue;">order</span> <span style="color:blue;">by</span> OrderDate<span style="color:gray;">,</span> SalesOrderID<span style="color:gray;">)</span> <span style="color:blue;">as</span> recent_TotalDue</span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpFirst"><span style="color:blue;line-height:115%;font-size:10pt;mso-no-proof:yes;">from</span><span style="line-height:115%;font-size:10pt;mso-no-proof:yes;"> Sales<span style="color:gray;">.</span>SalesOrderHeader</span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3"><font face="Calibri">Query di atas akan menampilkan nilai terakhir untuk setiap customerID berdasarkan nilai terkecil dari OrderDate dan SalesOrderID, yang sama dengan nilai TotalDue pada setiap row.</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;text-indent:-0.25in;mso-list:l0 level1 lfo1;" class="MsoListParagraphCxSpMiddle"><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;"><span style="mso-list:Ignore;"><font size="3" face="Calibri">5.</font><span style="font-size-adjust:none;font-stretch:normal;">       </span></span></span><font face="Calibri"><font size="3">Inovasi window function untuk mendapatkan ranking lewat fungsi window function PERCENT_RANK() OVER (PARTITION BY <nama kolom> ORDER BY <nama kolom>)</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt 0.5in;" class="MsoListParagraphCxSpLast"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-layout-grid-align:none;" class="MsoNormal"><span style="color:blue;font-size:10pt;mso-no-proof:yes;">select</span><span style="font-size:10pt;mso-no-proof:yes;"> CustomerID<span style="color:gray;">,</span> OrderDate<span style="color:gray;">,</span> TotalDue<span style="color:gray;">,</span> </span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-layout-grid-align:none;" class="MsoNormal"><span style="font-size:10pt;mso-no-proof:yes;">percent_rank<span style="color:gray;">()</span> <span style="color:blue;">over </span><span style="color:gray;">(</span><span style="color:blue;">partition</span> <span style="color:blue;">by</span> CustomerID <span style="color:blue;">order</span> <span style="color:blue;">by</span> TotalDue<span style="color:gray;">)</span> <span style="color:blue;">as</span> percent_rank</span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpFirst"><span style="color:blue;line-height:115%;font-size:10pt;mso-no-proof:yes;">from</span><span style="line-height:115%;font-size:10pt;mso-no-proof:yes;"> Sales<span style="color:gray;">.</span>SalesOrderHeader</span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3"><font face="Calibri">Query di atas akan menampilkan ranking berdasarkan nilai TotalDue. Semakin besar nilai TotalDue maka rankingnya akan mendekati 1. </font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;text-indent:-0.25in;mso-add-space:auto;mso-list:l0 level1 lfo1;mso-layout-grid-align:none;" class="MsoListParagraphCxSpMiddle"><span style="font-size:10pt;mso-no-proof:yes;"><span style="mso-list:Ignore;">6.<span style="font-size-adjust:none;font-stretch:normal;">  </span></span></span><font face="Calibri"><font size="3">Invoasi window function untuk mendapatkan distribusi kumulatif lewat fungsi window function CUME_DIST() OVER (PARTITION BY <nama kolom> ORDER BY <nama kolom>) <span style="font-size:10pt;mso-no-proof:yes;"></span></font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-add-space:auto;mso-layout-grid-align:none;" class="MsoListParagraphCxSpMiddle"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-add-space:auto;mso-layout-grid-align:none;" class="MsoListParagraphCxSpLast"><span style="color:blue;font-size:10pt;mso-no-proof:yes;">select</span><span style="font-size:10pt;mso-no-proof:yes;"> CustomerID<span style="color:gray;">,</span> OrderDate<span style="color:gray;">,</span> TotalDue<span style="color:gray;">,</span> </span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;line-height:normal;mso-layout-grid-align:none;" class="MsoNormal"><span style="font-size:10pt;mso-no-proof:yes;">cume_dist<span style="color:gray;">()</span> <span style="color:blue;">over </span><span style="color:gray;">(</span><span style="color:blue;">partition</span> <span style="color:blue;">by</span> CustomerID <span style="color:blue;">order</span> <span style="color:blue;">by</span> TotalDue<span style="color:gray;">)</span> <span style="color:blue;">as</span> cumulative_distribution</span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpFirst"><span style="color:blue;line-height:115%;font-size:10pt;mso-no-proof:yes;">from</span><span style="line-height:115%;font-size:10pt;mso-no-proof:yes;"> Sales<span style="color:gray;">.</span>SalesOrderHeader</span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpMiddle"><span style="line-height:115%;font-size:10pt;mso-no-proof:yes;"> </span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt 0.5in;" class="MsoListParagraphCxSpLast"><font size="3"><font face="Calibri">Query di atas akan menampilkan distribusi kumulatif berdasarkan nilai TotalDue. Semakin besar nilai TotalDue maka distribusi kumulatifnya mendekati 1. </font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Selamat eksplorasi !</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;" class="MsoListParagraphCxSpFirst"><span style="line-height:115%;font-size:10pt;mso-no-proof:yes;"> </span></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt 0.5in;" class="MsoListParagraphCxSpLast"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/07/fitur-t-sql-window-function-terbaru-dari-sql-denali.aspx&subject=Fitur T-SQL Window Function Terbaru dari SQL Denali" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/07/fitur-t-sql-window-function-terbaru-dari-sql-denali.aspx&t=Fitur+T-SQL+Window+Function+Terbaru+dari+SQL+Denali" target="_blank" title="Submit Fitur T-SQL Window Function Terbaru dari SQL Denali to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/07/fitur-t-sql-window-function-terbaru-dari-sql-denali.aspx&title=Fitur+T-SQL+Window+Function+Terbaru+dari+SQL+Denali" target="_blank" title="Submit Fitur T-SQL Window Function Terbaru dari SQL Denali to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/07/fitur-t-sql-window-function-terbaru-dari-sql-denali.aspx&phase=2" target="_blank" title="Submit Fitur T-SQL Window Function Terbaru dari SQL Denali to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/07/fitur-t-sql-window-function-terbaru-dari-sql-denali.aspx&title=Fitur+T-SQL+Window+Function+Terbaru+dari+SQL+Denali" target="_blank" title="Add Fitur T-SQL Window Function Terbaru dari SQL Denali to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=193045" width="1" height="1">SQL ServerBermain-main dengan Fitur T-SQL Denali : SEQUENCEhttp://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/05/bermain-main-dengan-fitur-t-sql-denali-sequence.aspxMon, 05 Sep 2011 12:28:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:193039Kasim.Wirama0http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=193039http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/05/bermain-main-dengan-fitur-t-sql-denali-sequence.aspx#comments<font size="3" face="Times New Roman"> </font><h1 style="margin:24pt 0in 0pt;text-align:center;" align="center"><font size="5"><font color="#365f91"><font face="Cambria">Bermain-main dengan Fitur T-SQL Denali : SEQUENCE</font></font></font></h1><font size="3" face="Times New Roman"> </font><h2 style="margin:10pt 0in 0pt;text-align:center;" align="center"><font size="4"><font color="#4f81bd"><font face="Cambria">By : Kasim Wirama, MCDBA, MCITP</font></font></font></h2><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">SQL Denali memperkenalkan fitur T-SQL baru yaitu sequence yang mempunyai fungsi menghasilkan nomor urut seperti fungsi T-SQL yang ada sekarang yaitu IDENTITY. SEQUENCE ini merupakan obyek database seperti halnya table, stored procedure, view dsb. Sintax dari sequence ini adalah :</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">CREATE SEQUENCE <nama sequence> AS <tipe data misalnya INT></font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">START WITH <numeric></font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">| INCREMENT BY <numeric></font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">| {MINVALUE <numeric> | NO MINVALUE}</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">| {MAXVALUE <numeric> | NO MAXVALUE}</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">| {CYCLE | NO CYCLE}</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">| {CACHE <numeric> | NO CACHE}</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Contoh : </font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">CREATE SEQUENCE dbo.mysequence<br /> START WITH 1<br /> INCREMENT BY 1;</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Anda bisa mendefinisikan nilai ambang bawah dan ambang atas melalui MINVALUE dan MAXVALUE, bila anda ingin nilai sequence direset ke nilai awal setelah MAXVALUE anda bisa memberikan opsi CYCLE. Bila opsi NO CYCLE dipilih, maka akan terjadi run time exception bila nilai sequence melampui nilai MAXVALUE.</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Jika anda ingin mengubah angka awal, perintahnya :</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">CREATE SEQUENCE dbo.mysequence<br /> RESTART WITH 1;</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Keunggulan sequence ketimbang fungsi IDENTITY adalah sequence ini bisa diterapkan lebih dari satu table. Contohnya :</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">CREATE TABLE dbo.table1<br /> (<br /> Col1 INT PRIMARY KEY,<br /> Constraint df_table1 DEFAULT (NEXT VALUE FOR dbo.mysequence) FOR Col1<br /> );</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">CREATE TABLE dbo.table2<br /> (<br /> Col1 INT PRIMARY KEY,<br /> Constraint df_table1 DEFAULT (NEXT VALUE FOR dbo.mysequence) FOR Col1<br /> );</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Untuk mendapatkan angka nomor urut berikutnya bisa gunakan fungsi NEXT VALUE FOR <nama obyek sequence></font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Contoh : NEXT VALUE FOR dbo.mysequence.</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Keunggulan lain sequence adalah anda bisa dapatkan nomor sequence dan di-assign ke variable.</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Contoh : </font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">DECLARE @myvar AS INT = NEXT VALUE FOR dbo.mysequence;</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">SELECT @myvar;</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Keunggulan lain sequence adalah anda bisa memberikan nomor urut berdasarkan urutan kolom yang anda inginkan dengan kombinasi window function</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Contoh :</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Use AdventureWork2008R2<br /> GO</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">SELECT NEXT VALUE<span style="mso-spacerun:yes;">  </span>FOR dbo.mysequence OVER (ORDER BY BusinessEntityID DESC), BusinessEntityID, FirstName, LastName<br /> FROM Person.Person</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">SQL Denali menyediakan system function untuk melihat semua obyek sequence, yaitu SYS.SEQUENCES. Contoh :</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">SELECT * FROM SYS.SEQUENCES WHERE OBJECT_ID = OBJECT_ID(‘dbo.mysequence’);</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Anda bisa mendetect apakah suatu sequence sudah ada atau belum sebelum anda men-create ulang dengan fungsi OBJECT_ID dan nilai parameter SO. Contoh :</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">IF OBJECT_ID(‘dbo.mysequence’,’SO’) IS NOT NULL<br /> DROP SEQUENCE dbo.mysequence;</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">CREATE SEQUENCE dbo.mysequence AS INT START WITH 1 INCREMENT BY 1;</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/05/bermain-main-dengan-fitur-t-sql-denali-sequence.aspx&subject=Bermain-main dengan Fitur T-SQL Denali : SEQUENCE" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/05/bermain-main-dengan-fitur-t-sql-denali-sequence.aspx&t=Bermain-main+dengan+Fitur+T-SQL+Denali+%3a+SEQUENCE" target="_blank" title="Submit Bermain-main dengan Fitur T-SQL Denali : SEQUENCE to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/05/bermain-main-dengan-fitur-t-sql-denali-sequence.aspx&title=Bermain-main+dengan+Fitur+T-SQL+Denali+%3a+SEQUENCE" target="_blank" title="Submit Bermain-main dengan Fitur T-SQL Denali : SEQUENCE to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/05/bermain-main-dengan-fitur-t-sql-denali-sequence.aspx&phase=2" target="_blank" title="Submit Bermain-main dengan Fitur T-SQL Denali : SEQUENCE to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/05/bermain-main-dengan-fitur-t-sql-denali-sequence.aspx&title=Bermain-main+dengan+Fitur+T-SQL+Denali+%3a+SEQUENCE" target="_blank" title="Add Bermain-main dengan Fitur T-SQL Denali : SEQUENCE to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=193039" width="1" height="1">SQL ServerRenungan atas artikel "Being a SQL Server Pro Is Hard Work!"http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/03/renungan-atas-artikel-quot-being-a-sql-server-pro-is-hard-work-quot.aspxSat, 03 Sep 2011 12:52:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:193037Kasim.Wirama0http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=193037http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/03/renungan-atas-artikel-quot-being-a-sql-server-pro-is-hard-work-quot.aspx#comments<p>Saya menemui artikel menarik mengenai SQL Server di</p><p><a href="http://www.sqlmag.com/content1/tabid/461/catpath/sql-server/topic/sql-server-pro-hard-work-140312">http://www.sqlmag.com/content1/tabid/461/catpath/sql-server/topic/sql-server-pro-hard-work-140312</a></p><p>SQL Server sekarang bukan lagi sekedar database, namun sudah merupakan <strong>platform data</strong> yang mencakup database, reporting, ETL dan analysis service.</p><p>Mulai versi 2005, SQL Server dengan sejumlah inovasi sudah disejajarkan dengan vendor database besar seperti Oracle dan DB2. SAP bahkan mempercayakan aplikasi di-porting ke SQL Server.</p><p>Menurut pendapatku berdasarkan paragraf di atas, penguasaan hanya di SQL Server sudah dapat dijadikan acuan meniti karir database; idealnya IT pro sebaiknya menguasai database besar lain seperti Oracle dan DB2.</p><p>Bila seseorang menfocuskan menguasai 4 pilar dari SQL Server (database, reporting, ETL dan analysis service), saya yakin dia akan mampu memberikan value berharga ke client-nya dan tentunya merupakan resource yang berharga.</p><p>Kuncinya adalah terus menerus update perkembangan SQL Server karena SQL Server selalu berkembang dan berinovasi di setiap versinya. Investasi knowledge atas SQL Server akan selalu siap terap di setiap business challenge!</p> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/03/renungan-atas-artikel-quot-being-a-sql-server-pro-is-hard-work-quot.aspx&subject=Renungan atas artikel "Being a SQL Server Pro Is Hard Work!"" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/03/renungan-atas-artikel-quot-being-a-sql-server-pro-is-hard-work-quot.aspx&t=Renungan+atas+artikel+%26quot%3bBeing+a+SQL+Server+Pro+Is+Hard+Work!%26quot%3b" target="_blank" title="Submit Renungan atas artikel "Being a SQL Server Pro Is Hard Work!" to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/03/renungan-atas-artikel-quot-being-a-sql-server-pro-is-hard-work-quot.aspx&title=Renungan+atas+artikel+%26quot%3bBeing+a+SQL+Server+Pro+Is+Hard+Work!%26quot%3b" target="_blank" title="Submit Renungan atas artikel "Being a SQL Server Pro Is Hard Work!" to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/03/renungan-atas-artikel-quot-being-a-sql-server-pro-is-hard-work-quot.aspx&phase=2" target="_blank" title="Submit Renungan atas artikel "Being a SQL Server Pro Is Hard Work!" to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/09/03/renungan-atas-artikel-quot-being-a-sql-server-pro-is-hard-work-quot.aspx&title=Renungan+atas+artikel+%26quot%3bBeing+a+SQL+Server+Pro+Is+Hard+Work!%26quot%3b" target="_blank" title="Add Renungan atas artikel "Being a SQL Server Pro Is Hard Work!" to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=193037" width="1" height="1">SQL ServerFound Error When Starting First SQL Denali Analysis Service in Vertipaq Mode and How to Troubleshoothttp://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/27/found-error-when-starting-first-sql-denali-analysis-service-in-vertipaq-mode-and-how-to-troubleshoot.aspxSat, 27 Aug 2011 08:18:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:193032Kasim.Wirama0http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=193032http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/27/found-error-when-starting-first-sql-denali-analysis-service-in-vertipaq-mode-and-how-to-troubleshoot.aspx#comments<font size="3" face="Times New Roman"> </font><h1 style="margin:24pt 0in 0pt;text-align:center;" align="center"><font size="5"><font color="#365f91"><font face="Cambria">Found Error When Starting First SQL Denali Analysis Service in Vertipaq Mode and How to Troubleshoot</font></font></font></h1><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;text-align:center;" class="MsoNormal" align="center"><font size="3"><font face="Calibri">By : Kasim Wirama, MCDBA, MCITP</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">SQL Denali menghadirkan banyak fitur baru yang siap di-explore. Kali ini saya akan share mengenai fitur baru di sisi Analysis Service. Selain analysis service engine yang multidimensional, SQL Denali mulai memperkenalkan analysis engine yang baru namanya Vertipaq. Vertipaq ini analysis service engine yang bersifat tabular. Keuntungan vertipaq ini dapat mempercepat query pada cube (kubus) yang bersifat relational (ROLAP). </font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3" face="Calibri">Tutorial mengenai pembuatan solusi Analysis Service modus vertipaq ini dapat anda temui di link </font><a href="http://msdn.microsoft.com/en-us/library/hh231691(v=SQL.110).aspx"><font color="#0000ff" size="3" face="Calibri">http://msdn.microsoft.com/en-us/library/hh231691(v=SQL.110).aspx</font></a><font size="3" face="Calibri">. Yang perlu anda lakukan sebelum mencoba tutorial ini adalah menginstal analysis service modus tabular terlebih dahulu ! Link untuk instalasi analysis service modus tabular adalah </font><a href="http://msdn.microsoft.com/en-us/library/hh231722(v=SQL.110).aspx"><font color="#0000ff" size="3" face="Calibri">http://msdn.microsoft.com/en-us/library/hh231722(v=SQL.110).aspx</font></a><font face="Calibri"><font size="3">. <span style="mso-spacerun:yes;"> </span>Dan install database AdventureworksDWDenali dari situs codeplex.com</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3" face="Calibri">Step berikutnya adalah memulai mencoba step pertama, link : </font><a href="http://msdn.microsoft.com/en-us/library/hh231689(v=SQL.110).aspx"><font color="#0000ff" size="3" face="Calibri">http://msdn.microsoft.com/en-us/library/hh231689(v=SQL.110).aspx</font></a><font face="Calibri"><font size="3">. </font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font face="Calibri"><font size="3">Saat pertama kali pembuatan Analysis Service Modular, saya menemukan error : “<b style="mso-bidi-font-weight:normal;">you cannot open the BIM file. Reason: The workspace database server 'localhost' is not running in vertipaq mode.</b>” Solusi untuk mengatasi hal ini adalah sbb :</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 0pt 0.5in;text-indent:-0.25in;mso-list:l0 level1 lfo1;" class="MsoListParagraphCxSpFirst"><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;"><span style="mso-list:Ignore;"><font size="3" face="Calibri">1.</font><span style="font-size-adjust:none;font-stretch:normal;">       </span></span></span><font face="Calibri"><font size="3">Right click pada VS 2010 solution, pilih properties. Di entry “Server”, ketik nama instance analysis service vertipaq mode.</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt 0.5in;text-indent:-0.25in;mso-list:l0 level1 lfo1;" class="MsoListParagraphCxSpLast"><span style="mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;"><span style="mso-list:Ignore;"><font size="3" face="Calibri">2.</font><span style="font-size-adjust:none;font-stretch:normal;">       </span></span></span><font face="Calibri"><font size="3">Setelah itu, pada solution explorer, pilih properties untuk model.bim dan set hal yang sama seperti pada step 1 untuk property : Workspace Server.</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Untuk menghindari error message pada saat anda membuat solusi Analysis Service Vertipaq mode, anda bisa set di VS2010 options. Di panel sebelah kiri temukan kategori : Analysis Service. Set nama analysis service vertipaq pada sub kategori Data Modelling dan Deployment.</font></font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Selamat explore!</font></font></p><font size="3" face="Times New Roman"> </font> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/27/found-error-when-starting-first-sql-denali-analysis-service-in-vertipaq-mode-and-how-to-troubleshoot.aspx&subject=Found Error When Starting First SQL Denali Analysis Service in Vertipaq Mode and How to Troubleshoot" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/27/found-error-when-starting-first-sql-denali-analysis-service-in-vertipaq-mode-and-how-to-troubleshoot.aspx&t=Found+Error+When+Starting+First+SQL+Denali+Analysis+Service+in+Vertipaq+Mode+and+How+to+Troubleshoot" target="_blank" title="Submit Found Error When Starting First SQL Denali Analysis Service in Vertipaq Mode and How to Troubleshoot to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/27/found-error-when-starting-first-sql-denali-analysis-service-in-vertipaq-mode-and-how-to-troubleshoot.aspx&title=Found+Error+When+Starting+First+SQL+Denali+Analysis+Service+in+Vertipaq+Mode+and+How+to+Troubleshoot" target="_blank" title="Submit Found Error When Starting First SQL Denali Analysis Service in Vertipaq Mode and How to Troubleshoot to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/27/found-error-when-starting-first-sql-denali-analysis-service-in-vertipaq-mode-and-how-to-troubleshoot.aspx&phase=2" target="_blank" title="Submit Found Error When Starting First SQL Denali Analysis Service in Vertipaq Mode and How to Troubleshoot to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/27/found-error-when-starting-first-sql-denali-analysis-service-in-vertipaq-mode-and-how-to-troubleshoot.aspx&title=Found+Error+When+Starting+First+SQL+Denali+Analysis+Service+in+Vertipaq+Mode+and+How+to+Troubleshoot" target="_blank" title="Add Found Error When Starting First SQL Denali Analysis Service in Vertipaq Mode and How to Troubleshoot to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=193032" width="1" height="1">SQL ServerFitur-fitur yang tidak disupport di SQL Denalihttp://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/25/fitur-fitur-yang-tidak-disupport-di-sql-denali.aspxThu, 25 Aug 2011 11:42:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:193022Kasim.Wirama1http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=193022http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/25/fitur-fitur-yang-tidak-disupport-di-sql-denali.aspx#comments<font size="3" face="Times New Roman"> </font><h1 style="margin:24pt 0in 0pt;text-align:center;" align="center"><font size="5"><font color="#365f91"><font face="Cambria">Fitur-fitur yang tidak disupport di SQL Denali</font></font></font></h1><font size="3" face="Times New Roman"> </font><h2 style="margin:10pt 0in 0pt;text-align:center;" align="center"><font size="4"><font color="#4f81bd"><font face="Cambria">Kasim Wirama, MCDBA, MCITP</font></font></font></h2><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;" class="MsoNormal"><font size="3" face="Calibri"> </font></p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;text-align:justify;" class="MsoNormal"><font size="3"><font face="Calibri">Sekitar sebulan atau 2 bulan lalu, Microsoft me-release SQL Denali CTP 3 (Community Technology Preview ke 3), versi berikutnya setelah SQL Server 2008 R2. Banyak sekali fitur-fitur menarik yang akan dihadirkan di SQL Denali. Mungkin ini merupakan versi SQL Server yang punya fitur-fitur baru yang cukup signifikan setelah SQL Server 2005. Menurut artikel <a href="http://www.sqlservercentral.com/blogs/pearlknows/archive/2011/08/18/dancing-with-denali-ctp3-product-guide-and-more.aspx">http://www.sqlservercentral.com/blogs/pearlknows/archive/2011/08/18/dancing-with-denali-ctp3-product-guide-and-more.aspx</a>, 90% fitur Denali CTP 3 adalah production quality release ! yang berarti sudah siap di-release ke market. Saya sarankan mulai sekarang community SQL Server dan spesialis SQL Server sudah mulai melakukan eksplorasi fitur-fitur Denali ini.</font></font></p><p style="margin:0in 0in 10pt;text-align:justify;" class="MsoNormal"><font size="3" face="Calibri"></font> </p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;text-align:justify;" class="MsoNormal"><font size="3"><font face="Calibri">Ke depannya, T-SQL akan semakin konsisten mengimplementasikan standard SQL (ANSI SQL) sehingga Microsoft mengeluarkan daftar fitur-fitur T-SQL yang tidak lagi di support di Denali dan juga fitur-fitur T-SQL yang disarankan tidak digunakan karena akan tidak disupport pada versi berikutnya setelah Denali di-release ke market.</font></font></p><p style="margin:0in 0in 10pt;text-align:justify;" class="MsoNormal"><font size="3"><font face="Calibri"></font></font> </p><font size="3" face="Times New Roman"> </font><p style="margin:0in 0in 10pt;text-align:justify;" class="MsoNormal"><font size="3" face="Calibri">Saya sarankan buat perusahaan yang masih menggunakan SQL Server 2005 atau versi sebelumnya, inilah saat yang paling tepat untuk melakukan upgrade ke Denali karena banyak fitur-fitur menarik di antaranya di sisi skalabilitas dan performance; semakin ditunda cost untuk migrasi semakin mahal dan beresiko karena bisa jadi semakin banyak fitur-fitur SQL Server yang tidak kompatibel atau usang sehingga perlu dilakukan development dari awal lagi. Daftar fitur-fitur yang tidak lagi disupport dan yang tidak akan disupport bisa dijadikan patokan untuk melakukan maintenance dan development SQL Server ke depannya. Untuk detilnya silahkan lihat di </font><a href="http://msdn.microsoft.com/en-us/library/ms143729(v=SQL.110).aspx"><font color="#0000ff" size="3" face="Calibri">http://msdn.microsoft.com/en-us/library/ms143729(v=SQL.110).aspx</font></a><font size="3"><font face="Calibri"> </font></font></p><font size="3" face="Times New Roman"> </font> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/25/fitur-fitur-yang-tidak-disupport-di-sql-denali.aspx&subject=Fitur-fitur yang tidak disupport di SQL Denali" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/25/fitur-fitur-yang-tidak-disupport-di-sql-denali.aspx&t=Fitur-fitur+yang+tidak+disupport+di+SQL+Denali" target="_blank" title="Submit Fitur-fitur yang tidak disupport di SQL Denali to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/25/fitur-fitur-yang-tidak-disupport-di-sql-denali.aspx&title=Fitur-fitur+yang+tidak+disupport+di+SQL+Denali" target="_blank" title="Submit Fitur-fitur yang tidak disupport di SQL Denali to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/25/fitur-fitur-yang-tidak-disupport-di-sql-denali.aspx&phase=2" target="_blank" title="Submit Fitur-fitur yang tidak disupport di SQL Denali to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/08/25/fitur-fitur-yang-tidak-disupport-di-sql-denali.aspx&title=Fitur-fitur+yang+tidak+disupport+di+SQL+Denali" target="_blank" title="Add Fitur-fitur yang tidak disupport di SQL Denali to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=193022" width="1" height="1">SQL ServerDifferent role of IT architectshttp://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/different-role-of-it-architects.aspxThu, 10 Mar 2011 11:49:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:192223Kasim.Wirama0http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=192223http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/different-role-of-it-architects.aspx#comments<p><a href="http://dwbi1.wordpress.com/2010/06/16/data-architect-data-warehouse-architect-and-bi-solution-architect/">http://dwbi1.wordpress.com/2010/06/16/data-architect-data-warehouse-architect-and-bi-solution-architect/</a></p> <p> <a href="http://www.sqlmag.com/article/sql-server/What-s-the-Difference-Between-a-Data-Architect-and-an-Enterprise-Architect-.aspx">http://www.sqlmag.com/article/sql-server/What-s-the-Difference-Between-a-Data-Architect-and-an-Enterprise-Architect-.aspx</a></p> <p> </p> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/different-role-of-it-architects.aspx&subject=Different role of IT architects" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/different-role-of-it-architects.aspx&t=Different+role+of+IT+architects" target="_blank" title="Submit Different role of IT architects to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/different-role-of-it-architects.aspx&title=Different+role+of+IT+architects" target="_blank" title="Submit Different role of IT architects to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/different-role-of-it-architects.aspx&phase=2" target="_blank" title="Submit Different role of IT architects to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/different-role-of-it-architects.aspx&title=Different+role+of+IT+architects" target="_blank" title="Add Different role of IT architects to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=192223" width="1" height="1">SQL ServerPertanyaan Mengenai SQL Query Optimizerhttp://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/pertanyaan-mengenai-sql-query-optimizer.aspxThu, 10 Mar 2011 10:33:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:192222Kasim.Wirama0http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=192222http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/pertanyaan-mengenai-sql-query-optimizer.aspx#comments<p><strong>Pertanyaan Mengenai SQL Query Optimizer</strong></p> <p>Pertanyaan dan jawaban dari milis sql server indo.</p> <p> </p> <p><font size="2"><font face="Tahoma"><span style="FONT-WEIGHT:bold;">From:</span> sn mailist <sn.mailist@gmail.com><br /><b><span style="FONT-WEIGHT:bold;">To:</span></b> sqlserver-indo@yahoogroups.com<br /><b><span style="FONT-WEIGHT:bold;">Sent:</span></b> Tue, March 8, 2011 11:54:01 PM<br /><b><span style="FONT-WEIGHT:bold;">Subject:</span></b> Re: [sqlserver-indo] Mencari Stock Part<br /><br /></font></font><span> </span> </p> <div id="ygrp-text"> <p>Numpang tanya ama temen2 yg tiap hari ber SQL ria.<br />Melihat ulasan yg diberikan sdr Chiang:<br />select ...<br />From (select . . .<br />From . . .)<br />where ...<br /><br />Apakah query tsb diperkenankan jika kita mengacu pada tuning & optimizer?<br />Kira2 apa solusi selain bentuk query diatas dan apa pertimbangannya ?<br /><br />Terima kasih sharing nya<br /><br />On 3/8/11, Mr Kamsul Chiang <<a href="mailto:kslchiang%40yahoo.com" rel="nofollow" target="_blank">kslchiang@yahoo.com</a>> wrote:<br />> Bro Afri,<br />> Berikut ini saya kirimkan contoh sederhana core query yang biasanya saya<br />> gunakan<br />> untuk mendapatkan kartu stok, tinggal di modifikasi sesuai kebutuhan.<br />><br />> SELECT StockCode, SaldoAwal, QtyIn, QtyOut, SaldoAwal+QtyIn-QtyOut AS<br />> SaldoAkhir<br />> FROM (<br />> SELECT StockCode, Tanggal, SaldoAwal, QtyIn, QtyOut<br />> FROM (<br />> SELECT StockCode, Tanggal, Qty AS SaldoAwal, 0 AS QtyIn, 0 AS QtyOut<br />> FROM tblStockAwal WHERE StockCode = @KodeStock<br />> UNION ALL<br />> SELECT StockCode, Tanggal, 0 AS SaldoAwal, Qty AS QtyIn, 0 AS QtyOut<br />> FROM tblTransTerimaStock WHERE StockCode = @KodeStock<br />> UNION ALL<br />> SELECT StockCode, Tanggal, 0 AS SaldoAwal, 0 AS QtyIn, Qty AS QtyOut<br />> FROM tblTransKeluarStock WHERE StockCode = @KodeStock<br />> ) AS TableSementaraUntukUrutTanggal<br />> ORDER BY Tanggal<br />> ) AS TableHasilKartuStock<br />><br />> Semoga bermanfaat.<br />><br />> Salam<br />> K.C.<br /></p> <p> JAWABAN :</p> <div>Menganalisa execution plan membutuhkan pengertian apa yang dilakukan operator fisikal. Cara paling gampang adalah melihat persentase yang diconsume operator fisikal. Namun bbrp kasus, persentase tersebut sering menyesatkan apalagi bila operator tersebut menyangkut operasi XML. Namun ada bbrp panduan yang sekiranya membantu spot bagian dari execution plan yang membutuhkan perhatian.</div> <div>1. bila tabel berukuran besar dan terdapat clustered index scan, itu sama saja dengan table scan; kemungkinan yang terjadi adalah select query tidak terdapat filtering (ON, HAVING, WHERE) atau hasil filtering tidak SARG.</div> <div> </div> <div>2. bila anda menemui bookmark lookup, berarti index yang digunakan tidak mencakup kolom yang ditampilkan dalam SELECT list. Sangat mudah utk fix problem ini dengan mengubah/create covering index (index yg menyertakan kolom di dalam SELECT list).</div> <div> </div> <div>3. bila anda menemui komponen Nested Loop; itu bisa berarti buruk ataupun baik. Bila anda amati, nested loop akan me-look up pada inner table/index berdasarkan input pada outer table/index. Yang buruk adalah begitu besar jumlah row yang harus di-retrieve pada inner table/index.</div> <div><br />4. Sebisa mungkin hindari akses tabel bbrp kali; anda bisa melihat sympton tersebut dari execution plan; dan most cases anda bisa akali dengan penggunaan OUTER APPLY, CROSS JOIN, GROUPING SETS, Common Table Expression dan fitur2 T-SQL lainnya. Fitur-fitur 'kaya' tersebut sudah ada dari SQL Server 2005. Itu merupakan salah satu alasan kenapa perlu upgrade dari SQL Server 2000 ke 2005/2008/2008R2.</div> <div> </div> <div>5. biasanya bagian SQL ORDER BY/GROUP BY/DISTINCT menyebabkan timbulnya sorting operation di dalam execution plan. Sorting operation ada 2 macam, index sorting/implisit sort atau explisit sort dengan munculnya SORT operator. Index sorting memiliki performa lebih baik ketimbang explisit sort. </div> <div> </div> <div> </div> <div>Penggunaan HINT pada dasarnya "memaksa" optimizer untuk execute execution plan yang disodorkan oleh user. Bila seseorang kurang mengerti "pesan" dari execution plan dalam analisa problem performance, penggunaan HINT tidak banyak berpengaruh.</div></div> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/pertanyaan-mengenai-sql-query-optimizer.aspx&subject=Pertanyaan Mengenai SQL Query Optimizer" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/pertanyaan-mengenai-sql-query-optimizer.aspx&t=Pertanyaan+Mengenai+SQL+Query+Optimizer" target="_blank" title="Submit Pertanyaan Mengenai SQL Query Optimizer to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/pertanyaan-mengenai-sql-query-optimizer.aspx&title=Pertanyaan+Mengenai+SQL+Query+Optimizer" target="_blank" title="Submit Pertanyaan Mengenai SQL Query Optimizer to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/pertanyaan-mengenai-sql-query-optimizer.aspx&phase=2" target="_blank" title="Submit Pertanyaan Mengenai SQL Query Optimizer to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/10/pertanyaan-mengenai-sql-query-optimizer.aspx&title=Pertanyaan+Mengenai+SQL+Query+Optimizer" target="_blank" title="Add Pertanyaan Mengenai SQL Query Optimizer to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=192222" width="1" height="1">SQL ServerSolusi dan Pemrograman Transact-SQL : Convert Comma Delimited String into Resultset with Transact-SQLhttp://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/06/solusi-dan-pemrograman-transact-sql-convert-comma-delimited-string-into-resultset-with-transact-sql.aspxSun, 06 Mar 2011 11:46:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:192197Kasim.Wirama0http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=192197http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/06/solusi-dan-pemrograman-transact-sql-convert-comma-delimited-string-into-resultset-with-transact-sql.aspx#comments<h1 style="TEXT-ALIGN:center;MARGIN:24pt 0in 0pt;" align="center"><font size="5"><font color="#365f91"><font face="Cambria"><span class="spelle"><span style="mso-ansi-language:EN;">Solusi</span></span><span style="mso-ansi-language:EN;"> <span class="spelle">dan</span> <span class="spelle">Pemrograman</span> Transact-SQL</span></font></font></font></h1> <h1 style="TEXT-ALIGN:center;MARGIN:24pt 0in 0pt;" align="center"><font size="5"><font color="#365f91"><font face="Cambria">Convert Comma Delimited String into Resultset with Transact-SQL</font></font></font></h1> <h2 style="TEXT-ALIGN:center;MARGIN:10pt 0in 0pt;" align="center"><font size="4"><font color="#4f81bd"><font face="Cambria">By : Kasim Wirama</font></font></font></h2><font size="3" face="Calibri"> </font> <p style="MARGIN:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">Very often, you will need to parse one line of string delimited by comma and convert it into resultset. How do you achieve that? Conventional way is to do looping; this is less optimal approach especially there will be huge number of data. I wouldn’t discuss how to do conventional way. I would show 2 possible ways to do. First way is using repetition pattern based on input length. Second way is using XML feature introduced from SQL 2005 onwards.</font></font></p><font size="3"><font face="Calibri"></font></font> <font size="3"><font face="Calibri">Here is how conversion from string into resultset is done through first way.</font></font> <p style="LINE-HEIGHT:normal;MARGIN:0in 0in 0pt;mso-layout-grid-align:none;" class="MsoNormal"><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"></span> </p><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">CREATE</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">TABLE</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">Nums</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">n</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">INT</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">NOT</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">NULL</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">PRIMARY</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">KEY</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">);</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"></span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><font color="#000000"><br /></font>SET</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">NOCOUNT</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">ON</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"></span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />DECLARE</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;"><br />  </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@max</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">AS</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">INT</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">  </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@rc</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">AS</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">INT</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">SET</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@max</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">=</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> 1000000</span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">SET</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@rc</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">=</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> 1</span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;"><br /> </span></span></b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"></span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">BEGIN</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">TRAN</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">  </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">INSERT</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">INTO</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">Nums</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">n</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">VALUES</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;">1<span style="COLOR:gray;">);</span><b><span style="mso-spacerun:yes;">  </span></b></span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">  </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">WHILE</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@rc</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">*</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> 2 </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><=</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@max</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">  </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">BEGIN</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">INSERT</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">INTO</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">Nums</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">n</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">) </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">SELECT</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">n</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@rc</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">FROM</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">Nums</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">  </span></span></b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"></span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">    </span><span style="mso-tab-count:1;"></span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">SET</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@rc</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">=</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@rc</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">*</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> 2</span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">  </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">END</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">  </span></span></b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"></span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">  </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">INSERT</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">INTO</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">Nums</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">n</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">    </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">SELECT</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">n</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@rc</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">FROM</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">Nums</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">    </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">WHERE</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">n</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@rc</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><=</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@max</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">COMMIT</span><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">TRAN</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span><font size="3"><font face="Calibri"><br />After the Nums table is created, execute the code below. The below code is actual T-SQL functions that does conversion from single string into resultset.</font></font><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />CREATE FUNCTION</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">fn_split</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@arr</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">AS</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">VARCHAR</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;">8000<span style="COLOR:gray;">),</span><b> </b><span style="COLOR:teal;">@sep</span><b> </b><span style="COLOR:blue;">AS</span><b> </b><span style="COLOR:blue;">CHAR</span><span style="COLOR:gray;">(</span>1<span style="COLOR:gray;">))</span></span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">  </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">RETURNS</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">TABLE</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />AS</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />RETURN</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;"><br />  </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">SELECT</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;"><br /> </span><span style="mso-spacerun:yes;"> </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:fuchsia;FONT-SIZE:12pt;mso-no-proof:yes;">SUBSTRING</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@arr</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">n</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:fuchsia;FONT-SIZE:12pt;mso-no-proof:yes;">CHARINDEX</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@sep</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@arr</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@sep</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">n</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">-</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">n</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">AS</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">col</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> <br /></span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">  </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">FROM</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">Nums</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">  </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">WHERE</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">n</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><=</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:fuchsia;FONT-SIZE:12pt;mso-no-proof:yes;">LEN</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@arr</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> 1</span></b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"></span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-spacerun:yes;">    </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">AND</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:fuchsia;FONT-SIZE:12pt;mso-no-proof:yes;">SUBSTRING</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@sep</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@arr</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">n</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> 1</span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">=</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@sep</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">GO</span><font size="3"><font face="Calibri"><br />Second way is using combination of XML and CROSS APPLY, here is T-SQL solution in SQL 2005 with sample input is ‘a,b,c’</font></font><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />with</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cte</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />select</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:fuchsia;FONT-SIZE:12pt;mso-no-proof:yes;">cast</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'<r>'</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:fuchsia;FONT-SIZE:12pt;mso-no-proof:yes;">replace</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cola</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">','</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'</r><r>'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'</r>'</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">XML</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">b</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"></span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />from </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">select</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'a,b,c'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cola</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />)</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />select</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">d</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x2</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">col</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />from</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cte</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />cross</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">apply</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />(</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />select</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x1</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">value</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'.'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'varchar(10)'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x2</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />from</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cte</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">b</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">nodes</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'r'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x1</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />)</span><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">D</span><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;<span style="mso-tab-count:1;">        </span></span><font size="3" face="Calibri"><br /> </font><font size="3"><font face="Calibri">When using SQL 2008, you could replace <span style="mso-spacerun:yes;"> </span></font><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">select</span><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'a,b,c' </span><font face="Calibri">with syntax of ROW-VALUE constructor T-SQL here.</font></font><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />with</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cte</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />select</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:fuchsia;FONT-SIZE:12pt;mso-no-proof:yes;">cast</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'<r>'</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:fuchsia;FONT-SIZE:12pt;mso-no-proof:yes;">replace</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cola</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">','</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'</r><r>'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'</r>'</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">XML</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">b</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"></span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />from </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'a,b,c'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">))</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cola</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />)</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />select</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">d</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x2</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">col</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />from</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cte</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />cross</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">apply</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />(</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />select</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x1</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">value</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'.'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'varchar(10)'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x2</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />from</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cte</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">b</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">nodes</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'r'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x1</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />)</span><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">D</span><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span><font size="3" face="Calibri"><br /> </font><font size="3"><font face="Calibri">One of audience in SQL Server Indo mailing list, asks the question here:</font></font><b style="mso-bidi-font-weight:normal;"><font size="3"><font face="Calibri"><br />Hallo, mau Tanya<br /><span style="mso-spacerun:yes;"> </span>saya ketik di textField  “HOKA BENTO”<br /><span style="mso-spacerun:yes;"> </span>mau muncul data dibawah ini<br /><span style="mso-spacerun:yes;"> </span>HOKA<br /><span style="mso-spacerun:yes;"> </span>BENTO<br /><span style="mso-spacerun:yes;"> </span>HOKA BENTO<br /><span style="mso-spacerun:yes;"> </span>HOK BENTO2 HO<br /><span style="mso-spacerun:yes;"> </span>HOKA2<br /><span style="mso-spacerun:yes;"> </span>2BENTO<br /> <br />Cara selectnya gimana</font></font></b><font size="3"><font face="Calibri"><b style="mso-bidi-font-weight:normal;"><br />Here is my T-SQL solution </b></font></font><font size="3"><font face="Calibri"><br />You could use either first way or second way. I use second way with assumption he uses SQL 2008 because I like to use ROW-VALUE constructor T-SQL feature.</font></font><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />create</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">table</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t1</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cola</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">varchar</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;">50<span style="COLOR:gray;">));</span></span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />go</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"> </span><span style="FONT-FAMILY:'Courier New';COLOR:green;FONT-SIZE:12pt;mso-no-proof:yes;"><br />/*sql 2008*/</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />insert</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">into</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t1</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'outlet opens new hoka 2 bento'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">),(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'hokaben'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">),(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'hoka'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">),(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'bento'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">),(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'2hoka'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">),(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'bento2'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">),(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'hokahoka'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">),(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'z'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">);</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />go</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="FONT-FAMILY:'Courier New';COLOR:green;FONT-SIZE:12pt;mso-no-proof:yes;">/*sql 2005/2000*/</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />insert</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">into</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t1</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'outlet opens new hoka 2 bento'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">);</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />insert</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">into</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t1</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'hokaben'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">);</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />insert</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">into</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t1</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'hoka'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">);</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />insert</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">into</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t1</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'bento'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />insert</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">into</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t1</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'2hoka'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />insert</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">into</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t1</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'bento2'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">);</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />insert</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">into</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t1</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'hokahoka'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">);</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />insert</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">into</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t1</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'z'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">);</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />go</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">create</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">procedure</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">search_hoka_hoka_bento</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@cola</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">varchar</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;">50<span style="COLOR:gray;">),</span><b> </b><span style="COLOR:teal;">@delimiter</span><b> </b><span style="COLOR:blue;">char</span><span style="COLOR:gray;">(</span>1<span style="COLOR:gray;">))</span></span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />as</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />begin</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />set</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">nocount</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">on</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />declare</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@t2</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">table </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cola</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">varchar</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;">50<span style="COLOR:gray;">));</span></span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />with</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cte</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />select</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:fuchsia;FONT-SIZE:12pt;mso-no-proof:yes;">cast</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'<r>'</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:fuchsia;FONT-SIZE:12pt;mso-no-proof:yes;">replace</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cola</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">' '</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'</r><r>'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'</r>'</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">XML</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">b</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"></span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />from </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@cola</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">))</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cola</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />)</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">insert</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">into</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@t2</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cola</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />select</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">d</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x2</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />from</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cte</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />cross</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">apply</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />(</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />select</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x1</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">value</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'.'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'varchar(10)'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x2</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />from</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cte</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">b</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">nodes</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'r'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">x1</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />)</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">D</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">select</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">*</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">from</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t1</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"></span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />where</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"></span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />exists</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"> </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />select</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">*</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">from</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">@t2</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t2</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">where</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t1</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cola</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">like</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'%'</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">t2</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">cola</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">+</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'%'</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;"><br />);</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />End</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"> </span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:black;FONT-SIZE:12pt;mso-no-proof:yes;"><br />Execute the sproc below :</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"></span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><br /> </span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">exec</span><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">search_hoka_hoka_bento</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"> </span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'hoka bento'</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">' '</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">;</span> <p> </p> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/06/solusi-dan-pemrograman-transact-sql-convert-comma-delimited-string-into-resultset-with-transact-sql.aspx&subject=Solusi dan Pemrograman Transact-SQL : Convert Comma Delimited String into Resultset with Transact-SQL" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/06/solusi-dan-pemrograman-transact-sql-convert-comma-delimited-string-into-resultset-with-transact-sql.aspx&t=Solusi+dan+Pemrograman+Transact-SQL+%3a+Convert+Comma+Delimited+String+into+Resultset+with+Transact-SQL" target="_blank" title="Submit Solusi dan Pemrograman Transact-SQL : Convert Comma Delimited String into Resultset with Transact-SQL to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/06/solusi-dan-pemrograman-transact-sql-convert-comma-delimited-string-into-resultset-with-transact-sql.aspx&title=Solusi+dan+Pemrograman+Transact-SQL+%3a+Convert+Comma+Delimited+String+into+Resultset+with+Transact-SQL" target="_blank" title="Submit Solusi dan Pemrograman Transact-SQL : Convert Comma Delimited String into Resultset with Transact-SQL to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/06/solusi-dan-pemrograman-transact-sql-convert-comma-delimited-string-into-resultset-with-transact-sql.aspx&phase=2" target="_blank" title="Submit Solusi dan Pemrograman Transact-SQL : Convert Comma Delimited String into Resultset with Transact-SQL to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/03/06/solusi-dan-pemrograman-transact-sql-convert-comma-delimited-string-into-resultset-with-transact-sql.aspx&title=Solusi+dan+Pemrograman+Transact-SQL+%3a+Convert+Comma+Delimited+String+into+Resultset+with+Transact-SQL" target="_blank" title="Add Solusi dan Pemrograman Transact-SQL : Convert Comma Delimited String into Resultset with Transact-SQL to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=192197" width="1" height="1">Rubrik Solusi dan Teknik Pemrograman Transact SQLsolusiSolusi dan Pemrograman Transact-SQL : UNPIVOT Problem and Solutionhttp://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/02/01/solusi-dan-pemrograman-transact-sql-unpivot-problem-and-solution.aspxTue, 01 Feb 2011 11:20:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:191985Kasim.Wirama2http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=191985http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/02/01/solusi-dan-pemrograman-transact-sql-unpivot-problem-and-solution.aspx#comments <h1 style="TEXT-ALIGN:center;" class="WordSection1" align="center"><span class="SpellE">Solusi</span> <span class="SpellE">dan</span> <span class="SpellE">Pemrograman</span> Transact-SQL</h1> <h2 style="TEXT-ALIGN:center;" class="WordSection1" align="center">UNPIVOT Problem and Solution</h2> <h2 style="TEXT-ALIGN:center;" class="WordSection1" align="center">“Applicable to SQL Server 2005 and above”</h2> <div class="WordSection1">  <br /><br /></div> <p class="MsoNormal">PIVOT and UNPIVOT are T-SQL feature that have been <span class="GramE">introduced<span style="mso-spacerun:yes;">  </span>since</span> SQL Server 2005. PIVOT a row means rotating data from state of rows into state of columns like the example <span class="GramE">below :</span></p> <p class="MsoNormal"><br />Original <span class="GramE">data :<br /><br /><br /></span></p> <div class="WordSection1"> <table style="WIDTH:166pt;BORDER-COLLAPSE:collapse;MARGIN-LEFT:4.65pt;mso-yfti-tbllook:1184;mso-padding-alt:0in 5.4pt 0in 5.4pt;" class="MsoNormalTable" cellspacing="0" cellpadding="0"> <tr style="HEIGHT:15pt;mso-yfti-irow:0;mso-yfti-firstrow:yes;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;BACKGROUND:#fabf8f;HEIGHT:15pt;PADDING-TOP:0in;"><span class="SpellE"><b><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">shipperid</span></b></span><b><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;"></span></b></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;BACKGROUND:#fabf8f;HEIGHT:15pt;PADDING-TOP:0in;"><span class="SpellE"><b><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">shippercity</span></b></span><b><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;"></span></b></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;BACKGROUND:#fabf8f;HEIGHT:15pt;PADDING-TOP:0in;"><span class="SpellE"><b><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">freight_cost</span></b></span><b><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;"></span></b></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:1;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">1</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Jakarta</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">20000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:2;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">1</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Bandung</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">10000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:3;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">1</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Denpasar</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">50000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:4;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">2</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Jakarta</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">40000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:5;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">2</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Bandung</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">50000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:6;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">2</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Denpasar</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">60000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:7;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">3</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Jakarta</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">100000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:8;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">3</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Bandung</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">200000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:9;mso-yfti-lastrow:yes;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">3</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Denpasar</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">300000</span></td></tr></table></div> <div class="WordSection1">  </div> <p class="MsoNormal"><br />Pivot <span class="GramE">result :<br /><br /><br /></span></p> <div class="WordSection1"> <table style="WIDTH:214pt;BORDER-COLLAPSE:collapse;MARGIN-LEFT:4.65pt;mso-yfti-tbllook:1184;mso-padding-alt:0in 5.4pt 0in 5.4pt;" class="MsoNormalTable" cellspacing="0" cellpadding="0"> <tr style="HEIGHT:15pt;mso-yfti-irow:0;mso-yfti-firstrow:yes;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;BACKGROUND:#fabf8f;HEIGHT:15pt;PADDING-TOP:0in;"><span class="SpellE"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">shipperid</span></span><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;"></span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;BACKGROUND:#fabf8f;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Jakarta</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;BACKGROUND:#fabf8f;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Bandung</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;BACKGROUND:#fabf8f;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Denpasar</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:1;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">1</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">20000</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">10000</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">50000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:2;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">2</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">40000</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">50000</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">60000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:3;mso-yfti-lastrow:yes;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">3</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">100000</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">200000</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">300000</span></td></tr></table></div> <div class="WordSection1">  </div> <p class="MsoNormal"><br />What could you see from above illustration? Jakarta, Bandung, Denpasar becomes names columns, whilst its <span class="SpellE">freight_cost</span> becomes values columns. This is very important concept to grasp; <b style="mso-bidi-font-weight:normal;"><u>NAMES COLUMNS</u></b> and <b style="mso-bidi-font-weight:normal;"><u>VALUES COLUMNS</u></b>.</p> <p class="MsoNormal"><br />UNPIVOT will do reverse than PIVOT has done earlier. Both PIVOT and UNPIVOT must contain 2 type of columns as mentioned above.</p> <p class="MsoNormal"><br />I discuss about UNPIVOT operator in this posting. Syntax of UNPIVOT is</p><b style="mso-bidi-font-weight:normal;"> <div class="WordSection1"><br />UNPIVOT (<span class="SpellE">values_column</span> FOR <span class="SpellE">names_column</span> IN (list of column for <span class="SpellE">unpivoting</span>)) AS <span class="SpellE">table_alias</span>.</b> </div> <p class="MsoNormal"><br />UNPIVOT received input from table/table expression before it as an input and it returns a table <span class="SpellE">resultset</span> as an output. UNPIVOT is regarded as TABLE operator like JOIN operator is. Because it is TABLE operator, it must have a table alias. <span class="SpellE">Resultset</span> of UNPIVOT could became input for next TABLE operator or further processed by condition after WHERE clause.</p> <p class="MsoNormal"><br />To demonstrate use of UNPIVOT, here is script for table creation with sample rows, <span class="GramE">here :</span></p><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"> <div class="WordSection1"><br />create</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">table</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">PivotTable</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-tab-count:1;">     </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">shipperid</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">int</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-tab-count:1;">     </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">Jakarta</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">int</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-tab-count:1;">     </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">Bandung</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">int</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"><span style="mso-tab-count:1;">     </span></span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">Denpasar</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">int</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">);<br /></span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">go<br /></span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">insert</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">into</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">PivotTable</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;">1<span style="COLOR:gray;">,</span>20000<span style="COLOR:gray;">,</span>10000<span style="COLOR:gray;">,</span>50000<span style="COLOR:gray;">);<br /></span></span><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">insert</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">into</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">PivotTable</span><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;">2<span style="COLOR:gray;">,</span>40000<span style="COLOR:gray;">,</span>50000<span style="COLOR:gray;">,</span>60000<span style="COLOR:gray;">);<br /></span></span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">insert</span><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">into</span><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">PivotTable</span><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">values </span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;">3<span style="COLOR:gray;">,</span>100000<span style="COLOR:gray;">,</span>200000<span style="COLOR:gray;">,</span>300000<span style="COLOR:gray;">);</span></span> </div> <p class="MsoNormal"><br />UNPIVOT statement for the <span class="SpellE">dbo.PivotTable</span> <span class="GramE">is :</span></p> <div class="WordSection1"><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"><br />select</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">D</span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">shipperid</span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">D</span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">shipcity</span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">D</span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">freight_cost</span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">from</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">dbo</span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">.</span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">PivotTable</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">P<br /></span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">UNPIVOT</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">freight_cost</span></b><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">for</span></b><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">shipcity</span></b><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">in(</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">Jakarta</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">Bandung</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">,</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">Denpasar</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">))</span></b><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span></b><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">D</span></b> </div> <p class="MsoNormal"><br />Result of UNPIVOT <span class="GramE">is :<br /><br /><br /></span></p> <div class="WordSection1"> <table style="WIDTH:166pt;BORDER-COLLAPSE:collapse;MARGIN-LEFT:4.65pt;mso-yfti-tbllook:1184;mso-padding-alt:0in 5.4pt 0in 5.4pt;" class="MsoNormalTable" cellspacing="0" cellpadding="0"> <tr style="HEIGHT:15pt;mso-yfti-irow:0;mso-yfti-firstrow:yes;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;BACKGROUND:#fabf8f;HEIGHT:15pt;PADDING-TOP:0in;"><span class="SpellE"><b><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">shipperid</span></b></span><b><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;"></span></b></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;BACKGROUND:#fabf8f;HEIGHT:15pt;PADDING-TOP:0in;"><span class="SpellE"><b><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">shippercity</span></b></span><b><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;"></span></b></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;BACKGROUND:#fabf8f;HEIGHT:15pt;PADDING-TOP:0in;"><span class="SpellE"><b><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">freight_cost</span></b></span><b><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;"></span></b></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:1;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">1</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Jakarta</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">20000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:2;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">1</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Bandung</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">10000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:3;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">1</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Denpasar</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">50000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:4;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">2</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Jakarta</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">40000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:5;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">2</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Bandung</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">50000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:6;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">2</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Denpasar</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">60000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:7;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">3</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Jakarta</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">100000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:8;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">3</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Bandung</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">200000</span></td></tr> <tr style="HEIGHT:15pt;mso-yfti-irow:9;mso-yfti-lastrow:yes;"> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:48pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">3</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:57pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">Denpasar</span></td> <td style="PADDING-BOTTOM:0in;PADDING-LEFT:5.4pt;WIDTH:61pt;PADDING-RIGHT:5.4pt;HEIGHT:15pt;PADDING-TOP:0in;"><span style="COLOR:black;mso-fareast-font-family:'Times New Roman';mso-bidi-font-family:Calibri;">300000</span></td></tr></table></div> <div class="WordSection1">  </div> <p class="MsoNormal"><br />This is part of Transact SQL series that give broad opportunity to turn data into useful information. Many things you could solve business challenge with strong knowledge in transact-SQL.</p> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/02/01/solusi-dan-pemrograman-transact-sql-unpivot-problem-and-solution.aspx&subject=Solusi dan Pemrograman Transact-SQL : UNPIVOT Problem and Solution" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/02/01/solusi-dan-pemrograman-transact-sql-unpivot-problem-and-solution.aspx&t=Solusi+dan+Pemrograman+Transact-SQL+%3a+UNPIVOT+Problem+and+Solution" target="_blank" title="Submit Solusi dan Pemrograman Transact-SQL : UNPIVOT Problem and Solution to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/02/01/solusi-dan-pemrograman-transact-sql-unpivot-problem-and-solution.aspx&title=Solusi+dan+Pemrograman+Transact-SQL+%3a+UNPIVOT+Problem+and+Solution" target="_blank" title="Submit Solusi dan Pemrograman Transact-SQL : UNPIVOT Problem and Solution to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/02/01/solusi-dan-pemrograman-transact-sql-unpivot-problem-and-solution.aspx&phase=2" target="_blank" title="Submit Solusi dan Pemrograman Transact-SQL : UNPIVOT Problem and Solution to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/02/01/solusi-dan-pemrograman-transact-sql-unpivot-problem-and-solution.aspx&title=Solusi+dan+Pemrograman+Transact-SQL+%3a+UNPIVOT+Problem+and+Solution" target="_blank" title="Add Solusi dan Pemrograman Transact-SQL : UNPIVOT Problem and Solution to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=191985" width="1" height="1">Rubrik Solusi dan Teknik Pemrograman Transact SQLSolusi dan Pemrograman Transact-SQLhttp://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/31/solusi-dan-pemrograman-transact-sql.aspxMon, 31 Jan 2011 10:39:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:191979Kasim.Wirama1http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=191979http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/31/solusi-dan-pemrograman-transact-sql.aspx#comments<h1 style="TEXT-ALIGN:center;MARGIN:24pt 0in 0pt;" align="center"><font size="5"><font color="#365f91"><font face="Cambria">Solusi dan Pemrograman Transact-SQL</font></font></font></h1> <h2 style="TEXT-ALIGN:center;MARGIN:10pt 0in 0pt;" align="center"><font size="4"><font color="#4f81bd"><font face="Cambria">Table-Valued Constructor</font></font></font></h2> <h2 style="TEXT-ALIGN:center;MARGIN:10pt 0in 0pt;" align="center"><font size="4"><font color="#4f81bd"><font face="Cambria">“Applicable to SQL Server 2008 and above”</font></font></font></h2> <h2 style="TEXT-ALIGN:center;MARGIN:10pt 0in 0pt;" align="center"><font size="4"><font color="#4f81bd"><font face="Cambria"></font></font></font> </h2><font size="3"><font face="Calibri">SQL Server 2008 introduces new T-SQL syntax called table-valued constructor. Before I show what exactly table-valued constructor is, I show how to do static resultset by using T-SQL construct before SQL Server 2008.</font></font> <p style="MARGIN:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri"></font></font> </p><font size="3"><font face="Calibri">You sometimes need to create a derived table that contains constant value like this below :</font></font> <p style="LINE-HEIGHT:normal;MARGIN:0in 0in 0pt;mso-layout-grid-align:none;" class="MsoNormal"><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"></span></b> </p><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">select</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'1'</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">number<br /></span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">union</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">all<br /></span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">select</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'2'</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> <br /></span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">union</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">all<br /></span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">select</span></b><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'3'</span></b> <p style="MARGIN:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri"></font></font> </p><font size="3"><font face="Calibri">Execute it and it will display a resultset contains 3 records. Now with SQL Server 2008, you could do other way by constructing resultset using table-valued constructor like below :<br /></font></font> <p style="LINE-HEIGHT:normal;MARGIN:0in 0in 0pt;mso-layout-grid-align:none;" class="MsoNormal"><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;"></span></b> </p><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">select</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">*</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">from</span></b><b><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"></span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">VALUES </span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'1'</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">),(</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'2'</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">),(</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:red;FONT-SIZE:12pt;mso-no-proof:yes;">'3'</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">))</span></b><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:blue;FONT-SIZE:12pt;mso-no-proof:yes;">as</span></b><b><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';FONT-SIZE:12pt;mso-no-proof:yes;"> </span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">D</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">(</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:teal;FONT-SIZE:12pt;mso-no-proof:yes;">number</span></b><b style="mso-bidi-font-weight:normal;"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Courier New';COLOR:gray;FONT-SIZE:12pt;mso-no-proof:yes;">)</span></b> <p style="MARGIN:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri"></font></font> </p> <p style="MARGIN:0in 0in 10pt;" class="MsoNormal"><font size="3"><font face="Calibri">You wrap VALUES keyword with parentheses and give table alias (<b style="mso-bidi-font-weight:normal;">D(number)</b> in the example). Because only one columns which is <b style="mso-bidi-font-weight:normal;">number</b>, you could specify multiple but single-column value with comma separated.</font></font></p> <p style="MARGIN:0in 0in 10pt;" class="MsoNormal"> </p> <p style="MARGIN:0in 0in 10pt;" class="MsoNormal"><span style="LINE-HEIGHT:115%;FONT-FAMILY:'Calibri','sans-serif';FONT-SIZE:11pt;mso-fareast-font-family:Calibri;mso-bidi-font-family:'Times New Roman';mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;">Hope this little information will enrich your T-SQL knowledge.</span></p> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/31/solusi-dan-pemrograman-transact-sql.aspx&subject=Solusi dan Pemrograman Transact-SQL" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/31/solusi-dan-pemrograman-transact-sql.aspx&t=Solusi+dan+Pemrograman+Transact-SQL" target="_blank" title="Submit Solusi dan Pemrograman Transact-SQL to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/31/solusi-dan-pemrograman-transact-sql.aspx&title=Solusi+dan+Pemrograman+Transact-SQL" target="_blank" title="Submit Solusi dan Pemrograman Transact-SQL to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/31/solusi-dan-pemrograman-transact-sql.aspx&phase=2" target="_blank" title="Submit Solusi dan Pemrograman Transact-SQL to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/31/solusi-dan-pemrograman-transact-sql.aspx&title=Solusi+dan+Pemrograman+Transact-SQL" target="_blank" title="Add Solusi dan Pemrograman Transact-SQL to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=191979" width="1" height="1">Rubrik Solusi dan Teknik Pemrograman Transact SQLForeign Key in SQL Serverhttp://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/30/foreign-key-in-sql-server.aspxSun, 30 Jan 2011 00:44:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:191958Kasim.Wirama0http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=191958http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/30/foreign-key-in-sql-server.aspx#comments<h1 style="TEXT-ALIGN:center;MARGIN:24pt 0in 0pt;" align="center"><font size="5"><font color="#365f91"><font face="Cambria">Foreign Key in SQL Server</font></font></font></h1><font size="3"><font face="Calibri">By: Kasim Wirama</font></font><font size="3" face="Calibri"> </font> <p><font size="3" face="Calibri"></font> </p><font size="3" face="Calibri">So far I think a foreign key is same as index in term of join between primary key-foreign key between 2 tables. But this is not true. It’s good start if you put index on foreign key. The additional benefit besides those explained at </font><a href="http://www.sqlskills.com/blogs/kimberly/post/when-did-sql-server-stop-putting-indexes-on-foreign-key-columns.aspx"><font color="#800080" size="3" face="Calibri">http://www.sqlskills.com/blogs/kimberly/post/when-did-sql-server-stop-putting-indexes-on-foreign-key-columns.aspx</font></a><font size="3"><font face="Calibri"> is that you could include additional column on the index. That’s the reason why SQL Server doesn’t automatically create foreign index when a foreign key is defined.</font></font><font size="3"><font face="Calibri"> </font></font> <p> </p> <p> </p></font><font size="3"><font face="Calibri">It gives you additional knowledge in doing query tuning.</font></font> </font></font> <p> </p> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/30/foreign-key-in-sql-server.aspx&subject=Foreign Key in SQL Server" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/30/foreign-key-in-sql-server.aspx&t=Foreign+Key+in+SQL+Server" target="_blank" title="Submit Foreign Key in SQL Server to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/30/foreign-key-in-sql-server.aspx&title=Foreign+Key+in+SQL+Server" target="_blank" title="Submit Foreign Key in SQL Server to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/30/foreign-key-in-sql-server.aspx&phase=2" target="_blank" title="Submit Foreign Key in SQL Server to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/30/foreign-key-in-sql-server.aspx&title=Foreign+Key+in+SQL+Server" target="_blank" title="Add Foreign Key in SQL Server to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=191958" width="1" height="1">SQL ServerGaji Pekerja IT Indonesia Paling Rendahhttp://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/08/gaji-pekerja-it-indonesia-paling-rendah.aspxSat, 08 Jan 2011 09:17:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:191741Kasim.Wirama2http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=191741http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/08/gaji-pekerja-it-indonesia-paling-rendah.aspx#comments<h3 class="judul_artikel">Gaji Pekerja IT Indonesia Paling Rendah</h3> <p><a href="http://tekno.kompas.com/read/2011/01/07/16033924/Gaji.Pekerja.IT.Indonesia.Paling.Rendah">http://tekno.kompas.com/read/2011/01/07/16033924/Gaji.Pekerja.IT.Indonesia.Paling.Rendah</a></p> <h3>ZDNet Asia IT Salary Benchmark 2010</h3> <p><a href="http://www.zdnetasia.com/zdnet-asia-it-salary-benchmark-2010-62204873.htm">http://www.zdnetasia.com/zdnet-asia-it-salary-benchmark-2010-62204873.htm</a></p> <h3 class="judul_artikel">Ini Dia Rata-rata Gaji Pekerja IT di Indonesia</h3> <p class="judul_artikel"><a href="http://tekno.kompas.com/read/2011/01/07/1632242/Ini.Dia.Rata-rata.Gaji.Pekerja.IT.di.Indonesia">http://tekno.kompas.com/read/2011/01/07/1632242/Ini.Dia.Rata-rata.Gaji.Pekerja.IT.di.Indonesia</a></p> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/08/gaji-pekerja-it-indonesia-paling-rendah.aspx&subject=Gaji Pekerja IT Indonesia Paling Rendah" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/08/gaji-pekerja-it-indonesia-paling-rendah.aspx&t=Gaji+Pekerja+IT+Indonesia+Paling+Rendah" target="_blank" title="Submit Gaji Pekerja IT Indonesia Paling Rendah to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/08/gaji-pekerja-it-indonesia-paling-rendah.aspx&title=Gaji+Pekerja+IT+Indonesia+Paling+Rendah" target="_blank" title="Submit Gaji Pekerja IT Indonesia Paling Rendah to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/08/gaji-pekerja-it-indonesia-paling-rendah.aspx&phase=2" target="_blank" title="Submit Gaji Pekerja IT Indonesia Paling Rendah to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/08/gaji-pekerja-it-indonesia-paling-rendah.aspx&title=Gaji+Pekerja+IT+Indonesia+Paling+Rendah" target="_blank" title="Add Gaji Pekerja IT Indonesia Paling Rendah to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=191741" width="1" height="1">General/motivationPeer to Peer Replication SQL 2008 on Youtubehttp://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/04/peer-to-peer-replication-sql-2008-on-youtube.aspxTue, 04 Jan 2011 10:42:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:191710Kasim.Wirama1http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=191710http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/04/peer-to-peer-replication-sql-2008-on-youtube.aspx#comments<font size="3" face="Calibri">It has been 2 years ago when first time I presented it before audience and I uploaded it about 1 year ago. Today I receive one of feedbacks. Though my English seems to have strong Indonesian accent, I still let you know the link: </font><a href="http://www.youtube.com/watch?v=mbANQW-73Mc"><font color="#800080" size="3" face="Calibri">http://www.youtube.com/watch?v=mbANQW-73Mc</font></a><font size="3"><font face="Calibri">. Enjoy!</font></font> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/04/peer-to-peer-replication-sql-2008-on-youtube.aspx&subject=Peer to Peer Replication SQL 2008 on Youtube" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/04/peer-to-peer-replication-sql-2008-on-youtube.aspx&t=Peer+to+Peer+Replication+SQL+2008+on+Youtube" target="_blank" title="Submit Peer to Peer Replication SQL 2008 on Youtube to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/04/peer-to-peer-replication-sql-2008-on-youtube.aspx&title=Peer+to+Peer+Replication+SQL+2008+on+Youtube" target="_blank" title="Submit Peer to Peer Replication SQL 2008 on Youtube to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/04/peer-to-peer-replication-sql-2008-on-youtube.aspx&phase=2" target="_blank" title="Submit Peer to Peer Replication SQL 2008 on Youtube to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2011/01/04/peer-to-peer-replication-sql-2008-on-youtube.aspx&title=Peer+to+Peer+Replication+SQL+2008+on+Youtube" target="_blank" title="Add Peer to Peer Replication SQL 2008 on Youtube to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=191710" width="1" height="1">SQL ServerWill I be hired for 300 Poundsterling/day as SQL Contractor?http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2010/12/05/will-i-be-hired-for-300-poundsterling-day-as-sql-contractor.aspxSat, 04 Dec 2010 21:32:00 GMT5cc3a90d-ac9a-472a-8983-30514957434c:191511Kasim.Wirama2http://geeks.netindonesia.net/blogs/kasim.wirama/rsscomments.aspx?PostID=191511http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2010/12/05/will-i-be-hired-for-300-poundsterling-day-as-sql-contractor.aspx#comments<p><a href="http://shaun-j-turner.blogspot.com/2010/12/question-of-day.html">http://shaun-j-turner.blogspot.com/2010/12/question-of-day.html</a></p> <p><a href="http://shaun-j-turner.blogspot.com/2010/12/interview-questions.html">http://shaun-j-turner.blogspot.com/2010/12/interview-questions.html</a></p> <div class = "shareblock"><strong>Share this post: </strong><a href="mailto:?body=Thought you might like this: http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2010/12/05/will-i-be-hired-for-300-poundsterling-day-as-sql-contractor.aspx&subject=Will I be hired for 300 Poundsterling/day as SQL Contractor?" target="_blank" title="Send via email"><img src="http://geeks.netindonesia.net/Images/Share.Mail.16.gif" border="0"></a> | <a href="http://www.facebook.com/sharer.php?u=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2010/12/05/will-i-be-hired-for-300-poundsterling-day-as-sql-contractor.aspx&t=Will+I+be+hired+for+300+Poundsterling%2fday+as+SQL+Contractor%3f" target="_blank" title="Submit Will I be hired for 300 Poundsterling/day as SQL Contractor? to DotNetKicks"><img src="http://geeks.netindonesia.net/Images/Share.Facebook.16.gif" border="0"></a> | <a href="http://del.icio.us/post?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2010/12/05/will-i-be-hired-for-300-poundsterling-day-as-sql-contractor.aspx&title=Will+I+be+hired+for+300+Poundsterling%2fday+as+SQL+Contractor%3f" target="_blank" title="Submit Will I be hired for 300 Poundsterling/day as SQL Contractor? to del.icio.us"><img src="http://geeks.netindonesia.net/Images/Share.Delicious.16.gif" border="0"></a> | <a href="http://www.digg.com/submit?url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2010/12/05/will-i-be-hired-for-300-poundsterling-day-as-sql-contractor.aspx&phase=2" target="_blank" title="Submit Will I be hired for 300 Poundsterling/day as SQL Contractor? to digg.com"><img src="http://geeks.netindonesia.net/Images/Share.Digg.16.gif" border="0"></a> | <a href="https://favorites.live.com/quickadd.aspx?marklet=1&mkt=en-us&url=http://geeks.netindonesia.net/blogs/kasim.wirama/archive/2010/12/05/will-i-be-hired-for-300-poundsterling-day-as-sql-contractor.aspx&title=Will+I+be+hired+for+300+Poundsterling%2fday+as+SQL+Contractor%3f" target="_blank" title="Add Will I be hired for 300 Poundsterling/day as SQL Contractor? to Live Bookmarks"><img src="http://geeks.netindonesia.net/Images/Share.Live.16.gif" border="0"></a></div><img src="http://geeks.netindonesia.net/aggbug.aspx?PostID=191511" width="1" height="1">SQL Server