Database

T.Senthilnathan wrote:

I got a solutions.

SELECT ...
FROM SingleDate d LEFT OUTER JOIN Packages p
     ON d.Date = p.Add_Date
GROUP BY d.Date

CREATE TEMPORARY TABLE date_col (add_dates nvarchar(50));
INSERT INTO date_col (add_dates) VALUES('2011-04-06');
SELECT * FROM date_col;

I appreciate your help all the time...
CodingLover

CREATE PROCEDURE DateFill(d1 DATE, d2 DATE)
BEGIN
   SET @d3 = d1;
   REPEAT
      INSERT INTO DateTable (date_co) VALUES (@d3);
      SET @d3 = DATE_ADD(@d3, INTERVAL 1 DAY);
   UNTIL @d3 > d2 
END;
//

CodingLover wrote:

The requirement is, for few sales rep I want to find the sales in a date range

SELECT ...
FROM DateTable dt LEFT OUTER JOIN MyTable mt
     ON dt.DateColumn =  mt.DateColumn
WHERE dt.DateColumn BETWEEN @startdate AND @enddate

Shameel wrote:

Step 1: Create a table variable with a date column and fill the table with the date range that you need (probably the min and max dates from 'packages' table)

CREATE TEMPORARY TABLE date_col (add_dates nvarchar(50));
INSERT INTO date_col (add_dates) VALUES ('2011-04-06' through '2011-04-01'); /* how can I do that */

I appreciate your help all the time...
CodingLover