Viewing 15 posts - 1,216 through 1,230 (of 2,452 total)
ok...we have a table script.....then some data in excel.....what are your expected results from the data?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 14, 2015 at 2:33 pm
Iwas Bornready (6/10/2015)
Easy one for me, thanks.
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 10, 2015 at 4:24 pm
thanks for script...what are the expected results from the sample data?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 7, 2015 at 2:04 pm
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.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 7, 2015 at 12:45 pm
Eric M Russell (6/3/2015)
J Livingston SQL (6/3/2015)
what does Order By Value DESC give you?LOL! Havn't had this morning's coffee yet? 😉
😛
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 3, 2015 at 9:08 am
what does Order By Value DESC give you?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 3, 2015 at 8:54 am
Jeff Moden (5/31/2015)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 31, 2015 at 2:30 pm
you could try reading these articles on this site
http://www.sqlservercentral.com/stairway/75773/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 29, 2015 at 10:36 am
emadkhanqai (5/28/2015)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 28, 2015 at 10:57 am
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 26, 2015 at 2:45 pm
SELECT DATEADD(mm , DATEDIFF(mm , 0 , GETDATE()) , 0);
SELECT DATEADD(mm , DATEDIFF(mm , 0 , GETDATE()) + 1 , 0);
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 25, 2015 at 5:29 am
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 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 22, 2015 at 3:11 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 22, 2015 at 5:17 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 22, 2015 at 4:52 am
yusufm 48726 (5/22/2015)
Is there a way to fix this query?Thanks,
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
May 22, 2015 at 4:39 am
Viewing 15 posts - 1,216 through 1,230 (of 2,452 total)