in reply to SQL query using elements from array
Read this, then look at your code.
push @date1, "'; drop table TopsData.dbo.AUDT_AuditChrt; --" [download]
Now, take placeholders seriously.