Cacher is the code snippet organizer for pro developers

  Declare @SQLSourceString nvarchar(1000)--sql_variant
	Declare @ExcelRowCount int 
	Declare @TestInput nvarchar(100)

	set @TestInput = 'WHERE 1=2'
	
	set @SQLSourceString = 'Select @RowCounts=COUNT(*) FROM Sikkerhedslogning.rapportPatientAdministrationPersisteret ' + @TestInput +''

	EXECUTE sp_executesql @SQLSourceString, N'@RowCounts int OUTPUT', @RowCounts = @ExcelRowCount OUTPUT

	Select @ExcelRowCount