I'm trying to figure out how to use the SQL where/in syntax with a paramterized query. For instance let's say I'd like to run the following query:select * from customers where custid in (1,2,3);I ...

What I would like to do is calculate the values in the SQL Query instead so that I can sort by those columns. How do I assign values based on other fields to a temporary field name?<P>Hope this ...

You can use SQL to create, modify, search, and display database information. Dynamic SQL lets you create a query string based off of user input. SQL Server allows you to create dynamic SQL statements.

asking yourself: Why would you want to display money values in currency format? Assuming that the output target is Query Analyzer, then it makes sense to want your format to look more attractive.