While loop with comma separated values in sql server

-

 While loop with comma separated values in sql server


DECLARE @valueList varchar(8000)
DECLARE @pos INT
DECLARE @len INT
DECLARE @value varchar(8000)

SET @valueList = 'sam,delhi,kandy,'

set @pos = 0
set @len = 0

WHILE CHARINDEX(',', @valueList, @pos+1)>0
BEGIN
    set @len = CHARINDEX(',', @valueList, @pos+1) - @pos
    set @value = SUBSTRING(@valueList, @pos, @len)
       
    PRINT @value

    set @pos = CHARINDEX(',', @valueList, @pos+@len) +1

END

Comments

Post a Comment

Popular posts from this blog

Create and save QR code in asp.net with C#

-
Image
Create and save QR code in asp.net with C# Download Dll from given link https://drive.google.com/drive/folders/0B2VobjpburSGdFBaZzBZSEJic0E?usp=sharing .Aspx Page < form id ="form1" runat ="server">         < asp : TextBox ID ="txtInput" runat ="server"></ asp : TextBox >         < asp : Button ID ="btnGenerate" runat ="server" Text ="Generate" OnClick ="btnGenerate_Click" />         < hr />         < asp : PlaceHolder ID ="plQRCode" runat ="server" />     </ form > .Cs Page using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using QRCoder; using System.IO; using System.Drawing; public partial class CS : System.Web.UI. Page { ...
Read more

Change text of RadGrid Header Dynamically

-
Image
Change text of RadGrid Header Dynamically Step 1 :-Design web form .aspx page < div >             < asp : ScriptManager ID ="sm" runat ="server"></ asp : ScriptManager >             < telerik : RadGrid ID ="RadGrid1" runat ="server" CellSpacing ="0" AllowPaging ="true" PageSize ="8" Width ="50%" PagerStyle-AlwaysVisible ="true"                 GridLines ="None" AutoGenerateColumns ="false" OnPreRender ="RadGrid1_PreRender"  OnItemDataBound="RadGrid1_ItemDataBound1"                 OnNeedDataSource ="RadGrid1_NeedDataSource">                 < PagerStyle Mode ="NextPrevAndNumeric"></ PagerStyle...
Read more

Telerik Radwindow Open on Button Click

-
Image
Telerik Radwindow Open on Button Click Step 1: Design web form .aspx page < div >             < asp : ScriptManager ID ="ss" runat ="server"></ asp : ScriptManager >             < telerik : RadWindow ID ="modalPopup" runat ="server" Width ="250px" Height ="100px"   VisibleTitlebar ="false"   Modal ="true" VisibleStatusbar ="false"   EnableShadow ="true"   >                 < ContentTemplate >                                        < p style =" text-align : center ; ">             ...
Read more