Viewing 15 posts - 76 through 90 (of 90 total)
There is a slight problem in that if J.DELLPOSTCODE is blank in the database it seems to not put any post codes at all in the destination field it doesn't...
December 8, 2016 at 8:05 am
Awesome thank you Chris, that seems to have done the trick for me.
December 8, 2016 at 7:40 am
Hi Phil,
I have removed that line and it's got the problem where it takes a long time to run again and puts a lot of postcodes repeating in the "destination"...
December 8, 2016 at 7:37 am
Hi Chris,
This is how it is currently....
alter VIEW [dbo].[CarouselDailyMileages] AS
SELECT DATENAME(DW,J.DELDATEANDTIME) AS [WEEKDAY],
J.DELDATEANDTIME AS [DATE],
(J.colpostcode +...
December 8, 2016 at 7:19 am
I think the reason it's taking so long to run is that I have put that line in the wrong place.
Whats happening now is that if a job has extra...
December 8, 2016 at 5:14 am
I decided to just let it run this time instead of killing it and it is working it just takes about 5 minutes to run. Brilliant. thank you
December 8, 2016 at 4:32 am
Ok Thom, no problem. Thank you taking the time to help me out.
December 8, 2016 at 4:17 am
I use the view to get the bulk of what I need that allows me to use a simple query in SSRS. This is the query in SSRS
SELECT
CarouselDailyMileages.WEEKDAY
...
December 8, 2016 at 3:59 am
it is something to do with that line
WHERE J.JOBID IN (SELECT sq.JOBID FROM dbo.Drops sq)
that it doesn't like
December 8, 2016 at 3:55 am
No graphics. It's as if it's stuck in an infinite loop of some sort. It's only a small report that they export to excel and it's filtered down to just...
December 8, 2016 at 3:42 am
Thank you, that seems to have solved the issue
I assume I have put it in the correct place...
ISNULL(STUFF((SELECT ', ' + d.POSTCODE
...
December 8, 2016 at 3:05 am
Thank you very much for your help Thom and Phil.
It seems to be working now for the most part but there seem to be random jobs appearing in the view...
December 8, 2016 at 2:10 am
Thank you Thom,
That appears to be nearly there the only problem now is if a job doesn't have any additional drops it doesnt show the collection and delivery post...
December 7, 2016 at 10:25 am
This is a sample of what the the drops table looks like
DROPID JOBID DROPNO TYPE POSTCODE
567 444342 1 ...
December 7, 2016 at 10:12 am
Hi Thom,
Thanks, I have edited the post.
I am not sure how to post samples with DDL?
December 7, 2016 at 10:02 am
Viewing 15 posts - 76 through 90 (of 90 total)