Viewing 15 posts - 376 through 390 (of 542 total)
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.
5th and last...
August 4, 2011 at 3:49 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.
4th table: ...
August 4, 2011 at 3:47 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.
3rd table: MG_VSLVOY_SCHEDULE
-----------------------------
USE...
August 4, 2011 at 3:44 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.
2nd table: MG_VESSEL_VOYAGE
-----------------------------
USE...
August 4, 2011 at 3:42 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.
Would this explanation...
August 4, 2011 at 3:38 am
Ninja's_RGR'us (8/3/2011)
It's still unclear to me atm. I'll read it back in a couple...
August 3, 2011 at 9:35 am
Ninja's_RGR'us (8/3/2011)
So basically you want the date filter to only apply to that 1 port.All other ports show all rows no matter the dates?
Actually no, the date filter along with...
August 3, 2011 at 9:24 am
Ninja's_RGR'us (8/3/2011)
Of those 3 rows, which ones need to stay, which one needs to go.
Actually that would depend, if the ARRIVAL_SCHEDULE_DT is within the 3 months time range when checked...
August 3, 2011 at 9:17 am
Ninja's_RGR'us (8/3/2011)
Not clear in my mind.I need to see a few rows of data and required output.
Okay I have some sample data below from a table-
---------------------------
ARRIVAL_SCHEDULE_DT -...
August 3, 2011 at 8:48 am
Ninja's_RGR'us (8/3/2011)
SELECT
*
FROM
dbo.Calendar
WHERE
dt >= DATEADD(D , 0 , DATEDIFF(D , 0 , GETDATE()))
...
August 3, 2011 at 8:13 am
pwalter83 (8/3/2011)
Ninja's_RGR'us (8/3/2011)
Aside for good manner and respect?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.
Thanks for...
August 3, 2011 at 7:58 am
Ninja's_RGR'us (8/3/2011)
Aside for good manner and respect?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.
Thanks for your...
August 3, 2011 at 7:50 am
Ninja's_RGR'us (8/3/2011)
I think you missed a typo in your postAND MG_VSLVOY_SCHEDULE.ARRIVAL_SCHEDULE_DT >= dateadd(mm, -3, getdate())
No more replies here please, continue the discussion here : http://www.sqlservercentral.com/Forums/Topic1153351-149-1.aspx
okay you win Ninja, you...
August 3, 2011 at 7:48 am
Ninja's_RGR'us (8/3/2011)
pwalter83 (8/3/2011)
Welsh Corgi (8/3/2011)
Do you know what DDL and sample data is?
No actually my English is not good neither are my SQL skills...I do know what a stored procedure...
August 3, 2011 at 7:07 am
Viewing 15 posts - 376 through 390 (of 542 total)