quote:

---

Originally posted by hockeyman9474

I'm trying to use Cast in a view but it automatically adds Top 100 percent and still wont work in a view. I get the following error:

SQL Select Execution Error
Executed SQL Statement: Select Top (100) Percent CAST[(Sales Accepted Date]AS DATE). ToString() AS SAC , Count(Cast([Sale Accepted Date]AS DATE) AS [Sales Count] FROM dbo.SdcYtdSales GROUP BY CAST([Sale Accepted Date] AS DATE) ORDER BY SAC
Error Source: .Net SqlClient Data Provider
Error Message: Cannot Call Methods on date



1. Also here is my code from the query:

SELECT CAST([Sale Accepted Date] as DATE) as SAC,count(CAST([Sale Accepted Date] as DATE))
from SdcYtdSales
group by CAST([Sale Accepted Date] as DATE)
order by SAC asc

2. and my code from the view including the Top statement:

SELECT TOP (100) PERCENT CAST([Sale Accepted Date] AS DATE) AS SAC, COUNT(CAST([Sale Accepted Date] AS DATE)) AS Expr1
FROM dbo.SdcYtdSales
GROUP BY CAST([Sale Accepted Date] AS DATE)
ORDER BY SAC

---

 Select Top (100) Percent CAST([Sales Accepted Date] AS DATE).ToString() AS SAC , 
 Count(Cast([Sale Accepted Date]AS DATE)) AS [Sales Count] FROM dbo.SdcYtdSales 
 GROUP BY CAST([Sale Accepted Date] AS DATE) ORDER BY SAC