SQL drop

• galaxykitty40

  Old Hand

  Points: 307

  More actions

  June 10, 2022 at 10:38 pm

  #4047764

   

  DROP TABLE IF EXISTS OARD, and a correlated subquery with a grouping that would give the total of adding all the null and blank votes, but I'm a bit lost. Thanks for the help!

  • This topic was modified 2 years, 11 months ago by  galaxykitty40.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  June 11, 2022 at 11:10 pm

  #4048133

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Grant Fritchey

  SSC Guru

  Points: 399047

  More actions

  June 13, 2022 at 11:47 am

  #4048657

  I'm not sure what you mean. You're saying you want to drop the table if it exists AND some additional criteria? DROP only uses IF EXISTS. There's not a way, within the DROP statement itself, to add more criteria. So, step back, make an IF statement that matches the additional criteria, then, if that passes, go to the DROP IF EXISTS.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning