# Having create\_temp\_table = False on MS SQL Server produces error: 'NoneType' object is not iterable

**URL:** <https://discourse.greatexpectations.io/t/having-create-temp-table-false-on-ms-sql-server-produces-error-nonetype-object-is-not-iterable/1551>\
**Category:** GX Core Support\
**Created:** [January 4, 2024, 5:10pm UTC](https://discourse.greatexpectations.io/t/having-create-temp-table-false-on-ms-sql-server-produces-error-nonetype-object-is-not-iterable/1551 "2024-01-04T17:10:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alex](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Alex](https://discourse.greatexpectations.io/u/Alex)\
**Post date:** [January 4, 2024, 5:10pm UTC](https://discourse.greatexpectations.io/t/having-create-temp-table-false-on-ms-sql-server-produces-error-nonetype-object-is-not-iterable/1551/1 "2024-01-04T17:10:54Z")

</div>

please see the bug here - [Having create\_temp\_table = False on MS SQL Server produces error: 'NoneType' object is not iterable · Issue #9186 · great-expectations/great\_expectations · GitHub](https://github.com/great-expectations/great_expectations/issues/9186)

---

<div class="post-metadata">

**Author:** ![Alex](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Alex](https://discourse.greatexpectations.io/u/Alex)\
**Post date:** [January 4, 2024, 5:11pm UTC](https://discourse.greatexpectations.io/t/having-create-temp-table-false-on-ms-sql-server-produces-error-nonetype-object-is-not-iterable/1551/2 "2024-01-04T17:11:25Z")

</div>

looks like you have smth similar - [Cannot use QueryAsset with Microsoft SQL Server (MSSQL) - #4 by oneextrafact](https://discourse.greatexpectations.io/t/cannot-use-queryasset-with-microsoft-sql-server-mssql/1379/4)

---

<div class="post-metadata">

**Author:** ![Alex](https://avatars.discourse-cdn.com/v4/letter/a/db5fbb/32.png) [@Alex](https://discourse.greatexpectations.io/u/Alex)\
**Post date:** [December 5, 2024, 2:03pm UTC](https://discourse.greatexpectations.io/t/having-create-temp-table-false-on-ms-sql-server-produces-error-nonetype-object-is-not-iterable/1551/3 "2024-12-05T14:03:35Z")

</div>

there is one more case when you get same ‘NoneType’ object is not iterable ERROR: if you have word “from” inside SQL comment:

select myfield /\* comment with from word \*/ from mytable

just remove it !