i need to increment values i have written this script execute this : this is for this scenario Insert Into #String SELECT 'S601-S630',1,'Desc1' Drop table #IDs CREATE TABLE #IDs(ID INT IDENTITY(1,1) ,String VARCHAR(100),Flag Int,Description VARCHAR(1000))CREATE TABLE #string(ID INT IDENTITY(1,1) ,String VARCHAR(100),Falg Int,Descript VARCHAR(1000))DECLARE @min INT ,@Max INT ,@String VARCHAR(50),@Start VARCHAR(50),@End VARCHAR(50),@Flag INT,@Desc VARCHAR(1000)DECLARE @CharIndex CHAR(1),@FinalString VARCHAR(100)Insert Into #String SELECT 'S601-S630',1,'Desc1'--Insert Into #String SELECT '800T-900T',2,'desc2'--Insert Into #String SELECT '901-1200',3,'desc3'SELECT @min = MIN(Id) ,@Max= MAX(Id)FROM #stringWHILE @min < = @Max BEGIN SELECT @String = String, @Desc = Descript, @Flag = Falg FROM #string WHERE id = @min --SET @Start = SUBSTRING(@String,1,CHARINDEX('-',@String)-1) --SET @ENd = SUBSTRING(@String,CHARINDEX('-',@String)+1,LEN(@String)) SET @CharIndex = CAST(SUBSTRING(@String,1,1) AS VARCHAR) IF ISNUMERIC(@CharIndex) = 0 BEGIN SET @String = REPLACE(@String,@CharIndex,'') --SELECT @String SET @Start = SUBSTRING(@String,1,CHARINDEX('-',LTRIM((RTRIM(@String))))-1) --SELECT @Start SET @ENd = SUBSTRING(@String,CHARINDEX('-',LTRIM((RTRIM(@String))))+1,LEN(LTRIM(RTRIM(@String)))) --SELECT @ENd END WHILE CAST(@Start AS INT) < = CAST(@ENd AS INT) BEGIN SET @Start = @CharIndex+ @Start INSERT INTO #IDs SELECT @Start,@Flag,@Desc SET @Start = CAST(REPLACE(@Start,@CharIndex,'') AS INT) SET @Start = @Start+1 END SET @min = @min+1 END Select * from #IDs --ORDER BY id Drop table #string
how i need to increment if the input is like this Insert Into #String SELECT '6S01-6S30',1,'Desc1'if alphabet is in middle of the number??P.V.P.MOhan