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.
Instead of usign Between Operator, you should use FromDate >= @FromDate
AND EndDate < DateAdd(D, 1, @EndDate )
(It always perform the accurate process, specially in case when Date Column accepts dates also)
Remember EndDate must work with LessThan and FromDate performs on GreaterThanEqualTo
Sorry, but this is a technical forum, it's unlikely we can offer useful career guidance. You need to decide these things for yourself based on your knowledge, experience and the job vacancies open to you.
Binding 100,000 items to a list box can be just silly regardless of what pattern you are following. Jeremy Likness
First you need a complicated data structure to work with, then you need a detailed requirement and then you need to work through examples, read books and learn TSQL (or the flavour of the database you choose to work with).
Never underestimate the power of human stupidity