ok...we have a table script.....then some data in excel.....what are your expected results from the data?

huh?

why bother posting the only reply to a QOTD from 2006?

or are you just trying to increase your bragging rights on number of points?.......seems...

thanks for script...what are the expected results from the sample data?

will be probably easier if you provided create table / sample insert data statements and expected results ....this makes it much easier to provide you with a tested solution.

😛

what does Order By Value DESC give you?

Jeff Moden (5/31/2015)

---

The next part of the problem is the fact that these are start and end times with no date. What happens when a start time is just...

you could try reading these articles on this site

http://www.sqlservercentral.com/stairway/75773/

emadkhanqai (5/28/2015)

---

This is the solution :

DECLARE @startDate date , @endDate date;

SET @startDate = ( SELECT proj_start_date FROM [BSD].[dbo].[d_project_p] WHERE proj_id = 1)

SET @endDate = ( SELECT proj_end_date FROM...

useful reading here

http://sqlmag.com/sql-server-2012/how-use-microsoft-sql-server-2012s-window-functions-part-1

http://sqlmag.com/sql-server-2012/microsoft-sql-server-2012-how-write-t-sql-window-functions-part-2

http://sqlmag.com/sql-server-2012/sql-server-2012-how-write-t-sql-window-functions-part-3

SELECT DATEADD(mm , DATEDIFF(mm , 0 , GETDATE()) , 0);

SELECT DATEADD(mm , DATEDIFF(mm , 0 , GETDATE()) + 1 , 0);

is this what you require?

if this gives you the desired results

SELECT

ID

, value1

, value2

, value3

, value1 / value2 * value3 AS finalvaluetest

FROM yourtable

then

UPDATE yourtable

SET ...

lets start with some simple example data

your job is to tell us what you would want your results to be on this sample data....edit it accordingly to show all the...

remove the "HAVING....." line....sorry

but you still havent answered my questions....seems that all you are doing is cutting and pasting without trying to take time to understand the basics of a...

yes......but you still havent given enough detail of what your final results should be

something like this....may help you get started

GROUP BY...