Viewing 15 posts - 1,141 through 1,155 (of 2,452 total)
the five monkeys experiment
http://www.mannkal.org/downloads/rspt/monkies.pdf
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2015 at 1:03 am
sdownen05 (7/31/2015)
I appreciate all of your responses. I have learned a whole lot and have been able to incorporate the code into production using your examples.
forum etiquette suggests that you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 31, 2015 at 2:21 pm
WITH ctegrp
AS (SELECT
PartNumber
, InspectionDate
, ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 31, 2015 at 8:35 am
gazy007 (7/31/2015)
dateadd(dd, datediff(dd, 0, getdate()), 0) and other but somehow it does not display the data but it shows the column.
when I use
DATEADD(dd, DATEDIFF(dd,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 31, 2015 at 4:41 am
gazy007 (7/31/2015)
J Livingston SQL (7/31/2015)
this should help explainhttp://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/
Thanks Mr Livingston. I got the link working now.
My query runs ok without any error but it does not show any data.
sorry...have edited...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 31, 2015 at 4:31 am
this should help explain
http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 31, 2015 at 4:15 am
bryan.holmstrom (7/30/2015)
any suggestions on how to resolve this?Thanks
post some sample data in the form of CREATE TABLE / INSERT DATA scripts
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 30, 2015 at 12:43 pm
Luis Cazares (7/30/2015)
I have an idea of what you want, but I'm not completely sure. If possible follow the advice of this article...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 30, 2015 at 9:37 am
Welsh Corgi (7/29/2015)
Basically what I'm trying to do is to populate the ActionRating Column in the #ImportExperianDataTest Table based on the Min_Score Column in the ActionRatingDuns Table.
ok...so as long as...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 29, 2015 at 2:35 pm
Lynn Pettis (7/29/2015)
J Livingston SQL (7/29/2015)
SELECT
IE.ID
, IE.ExperianScore
, AR.Min_Score
, AR.Max_Score
, AR.actionRatingDesc
FROM #ImportExperianDataTest AS IE
LEFT OUTER JOIN
ActionRatingDuns AS AR...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 29, 2015 at 2:19 pm
try this for a start
SELECT
IE.ID
, IE.ExperianScore
, AR.Min_Score
, AR.Max_Score
, AR.actionRatingDesc
FROM #ImportExperianDataTest AS IE
LEFT OUTER JOIN
ActionRatingDuns AS AR ON IE.ExperianScore <= AR.Max_Score
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 29, 2015 at 2:08 pm
dandenise316 (7/29/2015)
I tried using the second solution with month(n.campaign_date)
..
WHERE
day(campaign_date) between 1 and 23
And I'm getting the following error.
ERROR: 42883: function day(timestamp without time zone) does...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 29, 2015 at 11:51 am
http://www.sqlservercentral.com/Forums/Topic1706760-2799-1.aspx
seems you have already asked the same question in link above
please dont multiple post the same question......the answers and threads get confusing for all of us
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 29, 2015 at 11:10 am
you havent given any us any scripts to set up sample data plus the DATE_TRUNC is not MS SQL
but heres an idea for MS SQL
SELECT TOP 10000
CustomerID =...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 29, 2015 at 11:07 am
SELECT
C.cs
, L.MIN_CS
, L.MAX_CS
, L.CS_ACTION
FROM CREDITSCORE AS C
LEFT OUTER JOIN LOOKUP AS L ON C.cs <= L.MAX_CS
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 29, 2015 at 10:38 am
Viewing 15 posts - 1,141 through 1,155 (of 2,452 total)