Discussions
Why is the SQL so complicated?
almost 7 years ago by Jamie Rytlewski
Is there anyway to make the SQL statements smarter? Or for once, just let the users put in custom SQL.
SELECT Count([vBoCsContactBasic].[ID]) AS [Sum_Total] FROM vBoCsContactBasic WHERE ([vBoCsContactBasic].[IsCompany] = 0 AND [vBoCsContactBasic].[IsMember] = 1 AND [vBoCsContactBasic].[PaidThrough] <= CAST(cast(convert(varchar(10), getdate(), 112) as datetime) as DateTime2) AND [vBoCsContactBasic].[Status] = 'A')
Why are you converting a DateTime to VarChar, Casting it to a DateTime Then Casting it to a DateTime2?