Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nikoo56
Starting Member
26 Posts |
 Posted - 2011-12-09 : 18:56:07
|
| You cannot vote on your own post0I have this SQl statement that is returning hour and minutes between the 2 hours that are is in ' 'select convert(varchar(5),dt_created,108) as hour from vwInternetProspects3where convert(varchar(5),dt_created,108) BETWEEN '23:00' AND '24:00' I like to use this in my report and send variable @starthour and @endhours instead of that 2 fixed hours. I have 2 dropdown in my report that is showing hours , how I should write the SQL in the report t filter report by the dropdown values? I have this one but it is not working,where convert(varchar(5),dt_created,108) BETWEEN @startHour AND @EndHour |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-10 : 08:10:21
|
something like...where cast(time,dt_created) BETWEEN @startHour AND @EndHour ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
k_nataraj
Starting Member
7 Posts |
Posted - 2011-12-19 : 06:13:55
|
| I have recently uploaded a video on creating a SSRS report with 2 date parameters. I am sure this will help you.http://www.bitipsntricks.com/?p=314regardsNatraj |
|
|
|
|
|
|
Use value in dropdown to filter the report