Viewing 15 posts - 361 through 375 (of 542 total)
Ninja's_RGR'us (8/10/2011)
For the next time around, you can use this tool, it generates the insert statement for the sample data. Takes only 2-3 secs per table...
Thanks a ton Ninja...
August 15, 2011 at 4:53 am
Roy Ernest (8/9/2011)
August 9, 2011 at 10:00 am
Ninja's_RGR'us (8/9/2011)
You'll need to add a filter for only "uncompleted" trips or something like that (however this is represented in your data). I can't...
August 9, 2011 at 7:11 am
Ninja's_RGR'us (8/9/2011)
That's already what my query is doing, anything between now and the next 3 months.What dates are you missing in you new requirements?
Sorry for the Mis-explanation, now the requirment...
August 9, 2011 at 6:48 am
Ninja's_RGR'us (8/3/2011)
Not much.
SELECT * FROM dbo.Calendar WHERE dt >= DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) AND dt < DATEADD(MM, 3, GETDATE())Again STOP cross posting.
Hi Ninja,
If you remember you helped me with...
August 9, 2011 at 2:15 am
David Burrows (8/5/2011)
pwalter83 (8/5/2011)
I tried your query but its displaying data for ARRIVAL_SCHEDULE_DT 3 months prior to todays date now.
My mistake I thought the date test was for BEZEE only
WHERE...
August 5, 2011 at 6:57 am
David Burrows (8/5/2011)
This will select all ports except 'BEZEE' which will only be selected if the...
August 5, 2011 at 4:54 am
Welsh Corgi (8/4/2011)
Paul,Did you ever resolve the issue with the script to insert data?
I may have missed it but where is the sample output?
Regards,
WC
Hi,
No Welsh, I am still struggling with...
August 5, 2011 at 3:35 am
David Burrows (8/4/2011)
Now all that needs to be done is just include the condition that the above scenario will apply only if the ship reaches the port(PORT_CD) 'BEZEE' first.
How do...
August 5, 2011 at 3:34 am
Ninja's_RGR'us (8/4/2011)
Why?
I am tired, mate and just cant seem to create inserts through the method suggested in the link you mentioned. this is really frustrating...i am done with the whole...
August 4, 2011 at 9:19 am
Ninja's_RGR'us (8/4/2011)
Try again, that code works.
okay thanks for your help, Ninja, I cant go any further than this.
August 4, 2011 at 8:55 am
pwalter83 (8/4/2011)
pwalter83 (8/4/2011)
Ninja's_RGR'us (8/3/2011)
Normally you'd join on the itinaty table where first port = 'port code'Still not too sure where you need help here.
Can't see the tables, data nor code.
Pls...
August 4, 2011 at 7:37 am
pwalter83 (8/4/2011)
Ninja's_RGR'us (8/3/2011)
Normally you'd join on the itinaty table where first port = 'port code'Still not too sure where you need help here.
Can't see the tables, data nor code.
Pls also...
August 4, 2011 at 7:17 am
Welsh Corgi (8/4/2011)
Nice double post.
Ya, interesting isn't it ? you like it don't you
August 4, 2011 at 7:12 am
Ninja's_RGR'us (8/3/2011)
Normally you'd join on the itinaty table where first port = 'port code'Still not too sure where you need help here.
Can't see the tables, data nor code.
Pls also find...
August 4, 2011 at 4:41 am
Viewing 15 posts - 361 through 375 (of 542 total)