Viewing 15 posts - 1,141 through 1,155 (of 2,452 total)
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...
July 31, 2015 at 2:21 pm
WITH ctegrp
AS (SELECT
PartNumber
, InspectionDate
, ...
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,...
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...
July 31, 2015 at 4:31 am
this should help explain
http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/
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
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...
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...
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...
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
...
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...
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
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 =...
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
...
July 29, 2015 at 10:38 am
Viewing 15 posts - 1,141 through 1,155 (of 2,452 total)