in reply to SQL query using elements from array

Read this, then look at your code.

push @date1, "'; drop table TopsData.dbo.AUDT_AuditChrt; --"

Now, take placeholders seriously.