SQL Server database programming

I have a temp table that I create to build some statistics, the results of which I copy back to a live table. My question is in regards to MIN/MAX and other such functions... Do these get re-evaluated for every row, or is SQL smart enough to store the value for the next iteration? Because if they are re-evaluated every time, then I will definitely want to copy them into a variable first so they are only evaluated one time. ...

I simply want to do this in a stored procedure: If @myValue = 1     Select Field1 From myTable Else If @myValue = 2     Select Field1, Field2 From myTable In query analyzer I get the right select statement, but in dotnet or access ...

Hi, Here's what I need as the output for running total Week   BU           Cumulative_Amount 1           AB         100 ...

Hi, I receive a flat file that contains, among other info, a value for date. This value is 10 char. long and a sample of what it could look like is (CCYY-MM-DD): 2007-4-12 2006-12-31 ...

My table contains 100 rows of data that was collected every 10 seconds.  The datetime is recorded along with other information.  I want to retrieve every 6th row from this table - that would be the row at each minute interval.  How ...