Is it possible to write a SELECT statement to obtain all dates between 2 date columns? My question is related to these 2 questions:  


https://stackoverflow.com/questions/17529860/how-to-list-all-dates-between-two-dates/27319120
https://stackoverflow.com/questions/1378593/get-a-list-of-dates-between-two-dates-using-a-function


However in my case, I have a table with an ID,StartDate,EndDate columns and I want to apply the same approach (but instead of 2 days, I want to use the entire table).

And before dropping into functions, I wanted to see if this is possible w/ a select and a date dimension table.

Basically I want to scale this up to the entire table:

SELECT 
    t.Id
    ,dd.[Date]
FROM dbo.DateDimension dd
    ,dbo.T1 t   
WHERE
    t.Id = 957
    and  dd.Date&gt;=t.StartDate and dd.Date &lt;= t.EndDate 




I have Sample Data + Desired Output (The Select Statement) here:
www.sqlfiddle.com/#!18/0e389/2
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 t.id = ? 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;


In your example in the fiddle, you output 3 id's. If you only want a subset you can use an IN predicate:

SELECT t.Id, dd.[Date]
FROM dbo.DateDimension dd
JOIN dbo.dbse t   
    ON dd.Date BETWEEN t.StartDate and t.EndDate;
WHERE t.id IN (4229, 4268, 4269);