Stored Procedure Incorrect syntax

[fogal]

I am trying to run the following stored procedure. When I click check syntax, I get the error message Incorrect syntax near keyword begin, Incorrect syntax near keyword select

What am i doing wrong ???

declare @spid int, @sql varchar(1000)
select @spid = 10
while exists (select * from master..sysprocesses where spid > @spid and login_time > dateadd(dd,-1,getdate())
begin
select @spid = min(spid) from master..sysprocesses where spid > @spid and login_time > dateadd(dd,-1,getdate()
select @sql = 'kill ' + convert(varchar(20),@spid)
exec (@sql)
end

 

[LFCfan]

you're missing two closing brackets (in bold below)

declare @spid int, @sql varchar(1000)
select @spid = 10
while exists (select * from master..sysprocesses where spid > @spid and login_time > dateadd(dd,-1,getdate()))
begin
select @spid = min(spid) from master..sysprocesses where spid > @spid and login_time > dateadd(dd,-1,getdate())
select @sql = 'kill ' + convert(varchar(20),@spid)
exec (@sql)
end

 

[hmckillop]

replace your call to getdate() with a variable as shown below

declare @spid int, @sql varchar(1000)
select @spid = 10
declare @v_today datetime
set @v_today = getdate()
while exists (select * from master..sysprocesses where spid > @spid and login_time > dateadd(dd,-1,@v_today))
begin
select @spid = min(spid) from master..sysprocesses where spid > @spid and login_time > dateadd(dd,-1,@v_today )
select @sql = 'kill ' + convert(varchar(20),@spid)
exec (@sql)


That should do the job.