Database

declare @vSQL varchar(1000)
DECLARE @SNO INT;
DECLARE @SNO2 INT;
DECLARE @KNO INT;
DECLARE @SONUC VARCHAR(10);
SET @SNO = 10;
SET @SNO2 = 10;


WHILE @SNO < 83
BEGIN
--	DECLARE ankcev_cursor SCROLL CURSOR FOR
--	SELECT KULLANICINO FROM AnketCevap WHERE ANKETID='7'
--	OPEN ankcev_cursor
--
--	FETCH NEXT FROM ankcev_cursor INTO @KNO
--
--	WHILE @@FETCH_STATUS = 0
--	BEGIN
--	--SELECT CEVAPSIK FROM ANKETCEVAP WHERE ANKETID='7' AND KULLANICINO = @KNO AND SORUNO=@SNO
--		SET @SONUC=(SELECT CEVAPSIK FROM ANKETCEVAP WHERE ANKETID='7' AND KULLANICINO = @KNO AND SORUNO=@SNO)
--		SELECT @vSQL = 'UPDATE #rapor SET S'+ convert(varchar, @SNO)+'='''+ convert(varchar, @SONUC)+''' where ID='''+ convert(varchar, @KNO) + ''''
--		Execute (@vSQL)
--		FETCH NEXT FROM ankcev_cursor INTO @KNO
--	END
--
--	CLOSE ankcev_cursor
--	DEALLOCATE ankcev_cursor
	SET @SNO = @SNO+1;
END

PRINT @vSQL 
PRINT @SNO ------ALWAYS WRITE S10 why stay same value ???? 

select datediff(ms,getdate(), dateadd(hour, datepart(ss,getdate()),getdate()))

notes4we wrote:

I am not getting a proper syntax for the same.