problem
I have stored procedure move data by openrowset based on select statement
I need to modify stored procedure to prevent repeated data
suppose i have on table company on database SQL server 2012
1 mazda
2 toyotal
first time Executed stored procedure it show on excel with data above
when Execute stored procedure for second time it show repeated data on excel as following
1 mazda
2 toyotal
1 mazda
2 toyotal
so that how to allow stored procedure for work for one time only to prevent repeating ?
What I have tried:
create proc exportcompanydata
(
@ImporterQueueID INT=1,
@InputFilePath Nvarchar(500)='',
@OutputFilePath Nvarchar(500)='',
@UserID INT=1
)
as
Declare @sqlout nvarchar(4000);
Set @sqlout='INSERT INTO OPENROWSET(''Microsoft.ACE.OLEDB.12.0'',''Excel 12.0 Xml;HDR=YES;Database='+@OutputFilePath+ ''','' SELECT * FROM [Sheet1$]'' )
select CompanyID,CompanyName,PersonLastCheckDate from CompanyManagers.Company with(nolock)
WHERE CompanyID IS NOT NULL AND ISNULL(IsDeleted, 0) = 0'
Execute(@sqlout)