Solved

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

Posted on 2008-10-02
2
182 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 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