Create Params passed to a Store Proc.. as local variables in Debug Code,,, and to check whether a SP returns data, execute the SP with those local variable with specified values.. by marking comment on Create or Alter Command on SP
My problem is that I want to play that music at my website, I don't want to redirect to any any other website. I want that user just click on play button and it start playing, without showing the actual website which is hosting the song.
</artist_url><artist_website>http://www.cameronmusic.co.uk/</artist_website><album_id>10345</album_id><album_title>Free Film Music (cameronmusic.co.uk)</album_title><album_url>
</album_url><license_title>Creative Commons Attribution</license_title><license_url>http://creativecommons.org/licenses/by/3.0/</license_url><track_language_code/><track_duration>01:44</track_duration><track_number>0</track_number><track_disc_number>1</track_disc_number></value>
I need query which will check user supplied date range is in between the existing table startdate and enddate.
if any of the date of user supplied date range is in between the tables start date and end date,it should retrun that record from table.
for example user supply date range is from 1 may 2012 to 5 may 2012.
then query must check that
1 may 2005
2 may 2005
3 may 2005
4 may 2005
5 may 2005
(all dates) is in between startdate and enddate of existing table.