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

Tagged

Popular Posts of the Week

Top Posters Weekly

Optimum Creative