# SmartList Builder based on SQL View not returning data

- URL: https://dynamicaccounting.net/smartlist-builder-based-on-sql-view-not-returning-data/
- Date: 2010-06-23
- Topics: SQL & Data
- Type: link to an external article
- Source: https://blogs.msdn.microsoft.com/developingfordynamicsgp/2010/06/23/smartlist-builder-based-on-sql-view-not-returning-data/

David Musgrave has a great look at a [SQL view that works in SQL Management Studio but doesn’t work in a SmartList Builder view](https://blogs.msdn.microsoft.com/developingfordynamicsgp/2010/06/23/smartlist-builder-based-on-sql-view-not-returning-data/). David shows us the cause and the fix.

Update: Fixed Link