Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
3,148 questions
Visual Studio Database Project MATERIALIZED VIEW Error SQL71640: COUNT_BIG(a) is required when using this tool to create a materialized view
Coby Lin
0
Reputation points
I have COUNT_BIG(**) in the script and I got the "SQL71640: COUNT_BIG(a) is required" error.*
Am I missing something here?
[
](https://i.stack.imgur.com/oeAob.png)
SQL71640: COUNT_BIG(a) is required when using this tool to create a materialized view that has SUM(a) in the SELECT list.
Visual Studio
{count} votes
-
ShaktiSingh-MSFT 7,136 Reputation points Microsoft Employee2023-05-10T14:54:49.71+00:00 Hi Coby Lin •,
Welcome to Microsoft Q&A forum.
As I understand, you are getting error "SQL71640: COUNT_BIG(a) is required" error.* though using COUNT_BIG(**) in the script.
Could you please let us know the Visual Studio version in use?
Also sample View of what you are trying to perform so that we can better assist you. Thanks
-
Coby Lin 0 Reputation points
2023-05-10T21:02:24.0766667+00:00 Here you go @ShaktiSingh-MSFT
-
AnnaXiu-MSFT 14,996 Reputation points
2023-05-12T06:44:54.21+00:00 Hello, does it occur in other projects or this specific project?
Please update your VS2019 to the latest version with Visual Studio Installer.
-
Coby Lin 0 Reputation points
2023-06-01T00:04:16.5233333+00:00 Hi @AnnaXiu-MSFT, This is the only project we have with the MATERIALIZED VIEW. And our VS has been updated, but issue still exists.
Sign in to comment