Solved

Problem with Reporting services - creatign a report Errors in SQL Statement

Posted on 2008-10-02
2
180 Views
Last Modified: 2012-05-05
Hiya,

I am going around in circles here - I am trying to do a sql statement that takes the date that is greater than the Start date I choose and less than / equal to the finish date. I wrote the attached statement and it keeps failling please tell me where I am going wrong.

Under the parameters both parameters are set to Date / Time as type.

Thanks
SQL.JPG
0
Comment
Question by:mickinoz2005
2 Comments
 
LVL 1

Expert Comment

by:LindaClaes
ID: 22711934
It's more readable if you would say AND date_entered BETWEEN @StartDate AND @FinishDate
0
 
LVL 5

Accepted Solution

by:
mickinoz2005 earned 0 total points
ID: 22872528
I deleted all parameters and re created them, there is a bug in SQL reporting that keeps appearing and the only solution seems to be to delete the parameters and recreate them.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question