Viewing 15 posts - 226 through 240 (of 2,452 total)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 30, 2017 at 8:49 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 30, 2017 at 8:14 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 30, 2017 at 7:31 am
what results are you expecting from this.....?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 28, 2017 at 3:16 pm
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 25, 2017 at 2:46 pm
Many thanks Eirikur
I am tending towards this solution (for reason not explained in my post)
-- CASE METHOD
DECLARE @NUM_LEAD INT = 3;
SELECT
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 25, 2017 at 10:59 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 24, 2017 at 1:03 pm
can you please why, although you have four different case statements and calculations, you are returning the number of days as a single column?
I was thinking along the lines...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 24, 2017 at 9:31 am
dont think is too hard to fix for you.....some sample data and expected results will help
please read https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ and post back accordingly
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 24, 2017 at 9:25 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 23, 2017 at 11:21 am
rmcguire 28206 - Thursday, March 23, 2017 10:59 AMso I believe this should workAND sPU.actual_departure > DateAdd(M, -1, GetDate());
you mention "dates roll...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 23, 2017 at 11:07 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 23, 2017 at 10:45 am
what are the rules that specifically exclude 25 from ('ABC222249_DAN25') and exclude 99 from ('IN217465_v99') ?
are there any other possible formats that will need to excluded?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 23, 2017 at 6:33 am
with our data we won't be able to insert the data in manually as I believe you are suggesting above
not sure what you mean?
the example created...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 22, 2017 at 2:10 pm
I would like you to read this please...as previously suggested https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
posting excel spreadsheets and expecting others, upon whom you are requesting help, to do the necessary work...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 22, 2017 at 1:30 pm
Viewing 15 posts - 226 through 240 (of 2,452 total)