So i try to explain:

I have a table where select statement are saved:

(TABLEOFQUERY)
Row ID 1) SELECT * FROM MYTABLE1
Row ID 2) SELECT * FROM...

Is there no way to show a preview of RECORD COUNT for each SQL STATEMENT saved in rows ? :crazy:

Im looking for UDF executing query as parameter.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION dbo.fnCountRecord(@SQL NVARCHAR(800))
RETURNS int 
AS

USE [TEST]
GO
/****** Oggetto: Table [dbo].[MSPVISTE]  Data script: 03/16/2018 12:13:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE...

I try a view like this :

SELECT  Id, SqlWhere, SqlOrder, sp_executesql('SELECT COUNT(*) FROM MyTableOfContent WHERE ' + SqlWhere) AS RecordCount
FROM   MyTableOfQuery

I need RecordCount...