Microsoft Business Intelligence (Data Tools): SQL- Difference between Temp Table and CTE

Microsoft Business Intelligence (Data Tools): SQL- Difference between Temp Table and CTE:

What's the difference between a temp table and Common Type Expression (CTE) in SQL Server? In the real practice, it depends on the...