query for specific data in date range

what query should i write in c# with backend sql server for finding all purchases i did from george in a date range. from purchases table.

Newbie Poster

13 posts since Jun 2010

Reputation Points: 10

Solved Threads: 0

Hi,
SELECT * FROM purchases WHERE client = 'George' and date >= some_date and date < some_other_date;

Obviously change your table columns to suit but that should work for you.

Practically a Posting Shark

823 posts since Nov 2007

Reputation Points: 136

Solved Threads: 167

This article has been dead for over three months

You