My stored procedure is not working, how should I break this up? Declare @SearchStr nvarchar(100) SET @SearchStr='Search String' BEGIN CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630)) SET NOCOUNT ON DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110) SET…