I have a SQL query that I’m running against SQL server using Data Point Beta 3.4. In the query I define a Date variable called @InForceDate.
The query works fine in other editors. (Toad for SQL Server, SSMS, Excel)
However, when I execute the query in Data Point Beta 3.4 I get the following error message: Must declare the scalar variable “@InForceDate”.
Is this some sort of bug in Data Point ?
`DECLARE @InForceDate Date
SET @InForceDate = ‘8/15/2013’
SELECT blah blah…`
I also tried assigning the date using CONVERT(Datetime,‘08/15/2013’, 101) but that didn’t help at all.