There is probably something I don't understand in your question, but from the looks of it all you have to do is remove the predicate ` = ?` You can shorten the query a bit by using `BETWEEN` predicate, I also prefer explicit JOINS over "," joins:

    SELECT t.Id, dd.[Date]
    FROM dbo.DateDimension dd
    JOIN dbo.dbse t   
        ON dd.Date BETWEEN t.StartDate and t.EndDate;