vs query builder

Thanks, will do

Igor, you should create a new thread for your question and then when someone answers the question you should check the "Do you like this Answer" checkbox. You don't see the "Do you like this Answer" checkbox becasue you did not create this tread/question.

Igor Tiz16y ago

Hi,
How to implement complex SQL statements? To retrieve data we using SQL statement with multiple SELECT and #temp tables. Simply copy-past all that sql code to Query Builder in VS2008 does not work.
Need some advise where to look for or general directions.
Thank you

Sam Hobbs16y ago

The following is accepted by the query builder in VS 2008 for me, but when I execute it, Expr1 is equal to UnitPrice. I am using the Northwind database.

SELECT UnitPrice, UnitPrice % 60 AS Expr1
FROM [Order Details]