modified code 😀

-- ======================================================

-- Author:[Chero Díaz,Richard Johnnatan]

-- DBA.

-- Create date: [2013,11,28]

-- Description:[Simulación de Barra de Progreso]

-- © Copyright - Todos los Derechos reservados ™

-- ======================================================

---__________________________________________________________---

--- Creando e insertando registros a mi tabla Conteo ---

---__________________________________________________________---

--- Eliminamos la tabla si existe

if exists (select * from sysobjects

where id = object_id(N'[dbo].[conteo]') and OBJECTPROPERTY(id, N'IsTable') = 1)

drop table [dbo].[conteo]

--- Creamos tabla de conteo es decir los rangos de progreso

CREATE TABLE conteo (progreso int)

--- Inserto el primer valor de progreso en mi tabla conteo

insert into conteo values ('1')

--- Inserto los 100 valores en mi tabla conteo dinamicamente

WHILE (select max(progreso)+1 from conteo where progreso < 101) < 101

BEGIN

insert into conteo select max(progreso)+1 from conteo where progreso < 101

END

--- select * from conteo

/*_______________________________________________________________________________________*/

---__________________________________________________________---

--- Creando e insertando registros a mi tabla progress ---

---__________________________________________________________---

--- Eliminamos la tabla si existe

if exists (select * from sysobjects

where id = object_id(N'[dbo].[progress]') and OBJECTPROPERTY(id, N'IsTable') = 1)

drop table [dbo].[progress]

--- Creamos tabla de fechas es decir los dias del mes

CREATE TABLE progress (progreso varchar(255),descrip varchar(255))

--- Insertamos registro 0

insert into progress values(' ','Progreso ... 0 % Creditos ™ : Richard J.Chero Díaz ')

---select * from progress

/*_______________________________________________________________________________________*/

---Cursor Progreso

-- variable ----------------------------------------------

DECLARE @PROGRESO nvarchar(255)

-- variables para definir las consultas en tiempo de ejecución ------------------

DECLARE @exec1 nvarchar(4000)

DECLARE @exec2 nvarchar(4000)

DECLARE @exec3 nvarchar(4000)

-- declarar el cursor -----------------------------------------------------------

DECLARE RECORRE CURSOR FOR

SELECT * from conteo

-- abrir cursor -----------------------------------------------------------------

OPEN RECORRE

FETCH NEXT FROM RECORRE INTO @PROGRESO

-- mientras haya datos... -------------------------------------------------------

WHILE @@FETCH_STATUS = 0

BEGIN

-- por cada fila ----------------------------------------

declare @b-2 as varchar(100)

declare @C as varchar(100)

set @b-2 = @PROGRESO

set @C = @b-2

SET @exec1 = 'update a set progreso=replicate(''|'','+@c+'),descrip = (select ''Progreso ... ''+convert(varchar(10),'+ @C +')+'' % Creditos ™ : Richard J.Chero Díaz '') from progress awhere descrip like ''Progreso%''

'

IF (select @C)<101

BEGIN

print @exec1

EXECUTE (@exec1)

END

-- ======================================================

-- Author:[Chero Díaz,Richard Johnnatan]

-- DBA.

-- Create date: [2013,11,28]

-- Description:[Simulación de Barra de Progreso]

-- © Copyright - Todos los Derechos reservados ™

-- ======================================================

select * from [progress]

-----------------------------------------------------------------------------------

------ siguiente registro ---------------------------------------------------------

FETCH NEXT FROM RECORRE INTO @PROGRESO

END

-- cerrar y liberar la memoria del cursor -----------------------------------------

CLOSE RECORRE

DEALLOCATE RECORRE