Database

Use Northwind
Go

DECLARE @sql nvarchar(2000)

SELECT @sql = 'SELECT * FROM Products;and;SELECT * FROM Region;and;SELECT * FROM Invoices;and;'

SELECT @sql = REPLACE(@sql,';and;',' ')

exec (@sql)

Rate this message. Thank you. Harini

Use Northwind
Go

DECLARE @sql nvarchar(2000)

SELECT @sql = 'SELECT * FROM Products;and;SELECT * FROM Region;and;SELECT * FROM Invoices;and;'

SELECT @sql = REPLACE(@sql,';and;',';')

DECLARE @theString varchar(4000), @separator char(1)

DECLARE @seppos INT
DECLARE @curval VARCHAR(4000)

SET @theString = @sql
set @separator = ';'

WHILE PATINDEX('%' + @separator + '%' , @theString) <> 0
BEGIN
	SELECT @seppos =  PATINDEX('%' + @separator + '%' , @theString)
	SELECT @curval = LEFT(@theString, @seppos - 1) 
        --> use this variable for inserting into a table
	PRINT 'Select Tables: ' + @curval	
	SELECT @theString = STUFF(@theString, 1, @seppos, '')
END

Rate this message. Thank you. Harini

Harini311 wrote:

I dont have blog site.