Currently working on BI tool in .NET MVC. i have created procedure that accept sql statement as string to clone temp table from another table using select query. Now i want to create view of temp table that is recently created by using string.How to do i perform this task.
My code is
- USE [AirViewX2_DEV]
- GO
- /****** Object: StoredProcedure [dbo].[Tmp_CloneOfDataset] ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- ALTER PROCEDURE [dbo].[Tmp_CloneOfDataset]
- @Filter NVARCHAR(500),
- @Value NVARCHAR(50)=NULL
- AS
- BEGIN
- SET NOCOUNT ON
-
-
- DECLARE @GetTemName varchar(200)= RTRIM(LTRIM( SUBSTRING(@Filter,CHARINDEX('into',@Filter)+4,CHARINDEX('from',@Filter)-CHARINDEX('into',@Filter)-4)))
- IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = @GetTemName)
- BEGIN
- DECLARE @alreadyExist int =1;
- return @alreadyExist
-
-
-
- EXECUTE(@Filter)
- END
- ELSE
- BEGIN
- EXECUTE(@Filter)
- declare @sqlcode varchar(max)
Here i want to create sql view for @GetTemName
-
-
-
- DECLARE @status varchar(200) ='Done'
- SELECT @status
- END
-
- END