how to use insert in case statement with select
  • hi i am trying to use insert query in case statement but its not working properly can anyone share proper syntex for use insert query according to case when condition.
  • 2 Comments sorted by
  • hello coder,
    if you ever work on dynamic built query like this

    Declare @query Varchar(500)

    Set @query = 'Select * From Employees'

    Exec (@query)
    this will help you to create your insert query in case statement
  • Paste your code so we can look at it and fix it.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook


Popular Posts of the Week