Getting same output without cursor in SQL

Take the values from your table, and put the into a values format.

You can do it like this:

SELECT '('''+tPriceName+''', '''+tUserName+''', '''+@priceType+'''),'
  FROM mdPriceDesc

Then just add the create table syntax. You cannot declare a table with other variables.

---

Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.