string newfinddate = "SELECT Available = CASE WHEN ( SELECT COUNT (*) FROM EquipTB WHERE STime <= @startdate and ETime > @startdate and EqName = @useditem ) > 0 THEN 'NO' ELSE CASE WHEN ( SELECT COUNT (*) FROM EquipTB WHERE STime > @startdate AND @enddate > STime ) > 0 THEN 'NO' ELSE 'YES' END END";
that is the mssql code.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) FROM EquipTB WHERE STime > '2012-01-13 01:15:00' AND '2012-01-13 02:15:00' > ' at line 1
is the error. what supposed to be the problem?
that is the mssql code.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) FROM EquipTB WHERE STime > '2012-01-13 01:15:00' AND '2012-01-13 02:15:00' > ' at line 1
is the error. what supposed to be the problem?