I need this to return a boolean value if the following condition is met but I keep getting syntax errors
declare @OverLimit bit = 0
declare @var int
set @var = Select count(pkid)
From Clicks
If @var > 720,000 then
@OverLimit = 1
Select @OverLimit
Here is a version with the syntax errors rectified:
declare @OverLimit bit = 0 declare @var int
set @var = (Select count(pkid) From Clicks)
If @var > 720000 SET @OverLimit = 1
Select @OverLimit
The problems were:
The set - select statement needed brackets
The comma is reserved (removed it)
You might try reading the SQL manual, and the error messages and dealing with the underlying syntax issues:
declare @OverLimit bit
set @Overlimit = 0
declare @var int
select @var = count(pkid) From Clicks
If @var > 720000 set @OverLimit = 1
select @OverLimit
Try this:
declare @OverLimit bit = 0
declare @var int
SELECT @var = count(pkid) From Clicks
If @var > 720000 SET @OverLimit = 1
Select @OverLimit
Or alternatively:
SELECT CASE WHEN COUNT(pkid) > 720000 THEN CAST(1 AS bit) ELSE CAST(0 AS bit) END AS Overlimit
FROM Clicks
Wishing I had access to SQL as I write this to test: but isn't this wrong
set @var = Select count(pkid) From Clicks
try
Select @var=count(pkid) From Clicks
Since you didn't list specific errors, here are some lines I would recommend fixing.
Change from:
set @var = Select count(pkid) from Clicks
To:
set @var = (Select count(pkid) from Clicks)
remove the comma from 720,000
remove "then" from If statement and insert "Set":
If @var > 720000
set @OverLimit = 1
