Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

6
  • "update a existing table based on execution result" what do you mean with this statement? You need joins to update against another result set. Commented Jun 14, 2018 at 11:23
  • as @EzLo writes. Then you need to join you result from var1 to your update table otherwise it makes no sense. Commented Jun 14, 2018 at 11:36
  • I am hoping to update an existing table example:(tbl1) based on execution result of @Var1 as explained in my question. Commented Jun 14, 2018 at 11:36
  • @Gary you are basically saying "I want to update [Table A] based on [Table B]". That is not enough information. Commented Jun 14, 2018 at 12:24
  • @JasonGeiger What ever data I retrieve by executing Var1, I am hoping to store that into exiting table "tbl1" . Just wondering if this is a possibility or not possible within SQL? Commented Jun 14, 2018 at 12:49