The following is the query and it is returning 1184 records and it should return 331 only.

Note: replace the Satisfied icon with ")". Where ever I use that icon is...

If I add group by months I am getting 4534 records from Jan to May 2005, but I should get only 331 records (if I add the record count of individual...

Hi,

  Following is the query:

USE CyberScholar

DECLARE @VendorID INT

DECLARE @QuizTypeID INT

DECLARE @StartDate smalldatetime

DECLARE @EndDate smalldatetime

SET @VendorID = 43

SET @QuizTypeID = 23

SET @StartDate = '01/01/2005 12:00:00 AM'

SET @EndDate = '05/31/2005 11:59:59 PM'

SELECT...

Hi,

   Our query is written such a way that it works for individual months. It fails if I execute that for more than one month. Can you please suggest me...