Solve problems. The nuance with the correct select in the stored procedure (The problem of extra select in queries GetItems)

Your storage must output select sets strictly according to the Protocol of the component

(i.e. strict order of SELECT 1, SELECT 2, SELECT 3 and correct column names). 

IMPORTANT. If another storage is called in your store, this may lead to the fact that it may also have its own unnecessary select inside it.

To avoid this, use the following solution (https://stackoverflow.com/questions/1492411/sql-server-select-from-stored-procedure):

INSERT INTO #tab EXEC MyProc

The alternative is to call only the stores without the output select (i.e. create some of your own system stores and use them).

Another example of an error is that you wanted to assign a variable via select, forgot about it, and as a result, your output stream gets selected and is incorrectly interpreted by the program. 

Falcon Space is a functional web development platform on a narrow stack MS SQL/Bootstrap. Falcon Space Gettting started

SQL-tool for creating personal accounts on the site

The essence of the approach and the history of the creation of Falcon Space
Web platform for creating personal accounts

Falcon Space Platform

This is a reduction in the cost of ownership

at the expense of fewer people to support

This is a quick change

while using the program

This is a modern interface

full adaptation for mobile devices

MS SQL web applications. Affiliate program for developers and web studios

You can develop yourself or collaborate with us for web development on the Falcon Space platform using only SQL and HTML.
View examples with SQL code
Platform documentation
Working on MS SQL Server
Note