BobThornton
Programmer
I have the following so far -
USE MASTER
CREATE TABLE #TEMP_PHARM (
FILE_EXISTS INT
,FILE_DIRECTORY INT
,PARENT_DIRECTORY INT
)
INSERT INTO #TEMP_PHARM
EXEC xp_fileexist 'file path \ filename'
SELECT * FROM #TEMP_PHARM
Now I want to start DROP OR TRUNCATING tables (from a different database then the MASTER) where the value of FILE_EXISTS = 1 from the #TEMP_PHARM table
Any and all help is appreciated!!!
USE MASTER
CREATE TABLE #TEMP_PHARM (
FILE_EXISTS INT
,FILE_DIRECTORY INT
,PARENT_DIRECTORY INT
)
INSERT INTO #TEMP_PHARM
EXEC xp_fileexist 'file path \ filename'
SELECT * FROM #TEMP_PHARM
Now I want to start DROP OR TRUNCATING tables (from a different database then the MASTER) where the value of FILE_EXISTS = 1 from the #TEMP_PHARM table
Any and all help is appreciated!!!