August 3, 2011 at 9:35 am
Ninja's_RGR'us (8/3/2011)
Can you paste the whole where clause you have right now (need to see the parenthesis)It's still unclear to me atm. I'll read it back in a couple hours when I'm less tired.
L8r.
Thanks Ninja, its okay you can take your time...the WHERE clause condition is as below:
-----------------------------
WHERE MG_VESSEL_PARTICULAR.VESSEL_TYPE_CD = 'PCC'
AND MG_VESSEL_VOYAGE.SERVICE_CD IN ('WBTAS', 'NCTAS')
AND MG_VSLVOY_SCHEDULE.ARRIVAL_SCHEDULE_DT > = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) AND MG_VSLVOY_SCHEDULE.ARRIVAL_SCHEDULE_DT <= DATEADD(MM, 3, GETDATE())
AND PORT_CD IN ('BEZEE', 'GBSOU', 'MXVER', 'USGLS', 'USJAX', 'USBAL', 'USCHS', 'USSSI')
group by VESSEL_NAME, VOYAGE_CD, MG_VESSEL_VOYAGE.LEG_CD
August 3, 2011 at 9:53 am
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.
August 4, 2011 at 3:38 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 be of any help:
The condition is:
ARRIVAL_SCHEDULE_DT for a ship at PORT_CD 'BEZEE' should be within the 3 months time range from today's date. That is if the ARRIVAL_SCHEDULE_DT for a ship arriving at port 'BEZEE' is September 5, 2011 then this should be included in the report. The reason being September 5, 2011 is within the 3 months time range from August 4, 2011 (today's date).
ARRIVAL_SCHEDULE_DT and PORT_CD are 2 columns that belong to the same table- MG_VSLVOY_SCHEDULE.
You had resolved the first problem which was determining the 3 months period through this query:
ARRIVAL_SCHEDULE_DT > = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) AND ARRIVAL_SCHEDULE_DT <= DATEADD(MM, 3, GETDATE()).
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. In order to achieve this, somehow the PORT_CD = 'BEZEE' will need to be merged with the formula you created above. But the problem is we can't simply do this:
PORT_CD = 'BEZEE'
AND ARRIVAL_SCHEDULE_DT > = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) AND ARRIVAL_SCHEDULE_DT <= DATEADD(MM, 3, GETDATE())
This is because I do not want to filter out the remaining PORT_CD's that also need to be displayed on the report.
Is this helpful for you ? The thing is posting DDL and sample data can only proveful helpful if the requirement is clear enough to understand.
I would attach the DDL and sample data for each of the 5 tables involved but maybe on separate posts.
Starting with the first one:
1. MG_VESSEL_PARTICULAR
-----------------------------------------
USE [MiniGapp]
GO
/****** Object: Table [dbo].[MG_VESSEL_PARTICULAR] Script Date: 08/04/2011 10:33:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MG_VESSEL_PARTICULAR](
[VESSEL_CD] [varchar](10) NOT NULL,
[VESSEL_NAME] [varchar](35) NOT NULL,
[VESSEL_TYPE_CD] [varchar](4) NOT NULL,
[TBA_VESSEL_FLG] [char](1) NOT NULL,
[CALL_SIGN] [varchar](9) NULL,
[CLASSIFICATION] [varchar](20) NULL,
[LLOYDS_CD] [varchar](8) NULL,
[NATIONALITY_CD] [varchar](2) NULL,
[OFFICIAL_NUMBER] [varchar](8) NULL,
[MOTHER_PORT_CD] [varchar](5) NULL,
[OWNER_NAME] [varchar](70) NULL,
[OWNER_COUNTRY_CD] [varchar](2) NULL,
[SHIP_MANAGEMENT] [varchar](70) NULL,
[DISPONENT_OWNER] [varchar](70) NULL,
[NEXT_DRY_DOCK_DUE_DT] [datetime] NULL,
[YEAR_BUILT] [varchar](4) NULL,
[MONTH_BUILT] [varchar](4) NULL,
[SHIP_YARD_CD] [varchar](20) NULL,
[DEAD_WEIGHT_MT_NBR] [numeric](7, 0) NULL,
[GROSS_TONNAGE_NBR] [numeric](8, 2) NULL,
[NET_TONNAGE_NBR] [numeric](8, 2) NULL,
[LIGHT_TON_NBR] [numeric](7, 0) NULL,
[SUEZ_GROSS_TONNAGE_NBR] [numeric](8, 2) NULL,
[SUEZ_NET_TONNAGE_NBR] [numeric](8, 2) NULL,
[PANAMA_GROSS_TONNAGE_NBR] [numeric](8, 2) NULL,
[PANAMA_NET_TONNAGE_NBR] [numeric](8, 2) NULL,
[LOA_MT_NBR] [numeric](5, 2) NULL,
[LBP_MT_NBR] [numeric](5, 2) NULL,
[OVERALL_BREADTH_NBR] [numeric](4, 2) NULL,
[SUMMER_DRAFT_MT_NBR] [numeric](4, 2) NULL,
[DEPTH_MOULDED_MT_NBR] [numeric](4, 2) NULL,
[SERVICE_SPEED_KNTS_NBR] [numeric](3, 1) NULL,
[SPEED_CONDITION] [varchar](20) NULL,
[FUEL_CONS_SEA_NBR] [numeric](4, 1) NULL,
[FUEL_CONS_PORT_NBR] [numeric](4, 1) NULL,
[ENDURANCE_NBR] [numeric](5, 0) NULL,
[WBT_TANK_CAPA_NBR] [numeric](6, 1) NULL,
[WFT_TANK_CAPA_NBR] [numeric](6, 1) NULL,
[DWT_TANK_CAPA_NBR] [numeric](6, 1) NULL,
[FOT_TANK_CAPA_NBR] [numeric](6, 1) NULL,
[DOT_TANK_CAPA_NBR] [numeric](6, 1) NULL,
[MAIN_ENGINE] [varchar](20) NULL,
[MAIN_ENGINE_MAKER] [varchar](40) NULL,
[MAIN_ENGINE_MCO] [varchar](20) NULL,
[MAIN_ENGINE_NOR] [varchar](20) NULL,
[GENERATOR] [varchar](20) NULL,
[BOILER] [varchar](20) NULL,
[BOW_THRUSTER] [varchar](30) NULL,
[STERN_THRUSTER] [varchar](30) NULL,
[ME_OIL_GRADE] [varchar](10) NULL,
[AUX_OIL_GRADE] [varchar](10) NULL,
[TEU_CAPA_NOMINAL] [numeric](5, 0) NULL,
[TEU_CAPA_14TON] [numeric](5, 0) NULL,
[TEU_CAPA_10TON] [numeric](5, 0) NULL,
[MAX_STACK_WEIGHT_DECK] [varchar](40) NULL,
[MAX_STACK_WEIGHT_HOLD] [varchar](40) NULL,
[MAX_NO_OF_TIERS_ON_DECK_NBR] [numeric](2, 0) NULL,
[NUMBER_OF_HOLD] [numeric](3, 0) NULL,
[HATCH_COVER_SIZE] [varchar](40) NULL,
[REEFER_PLUG_NBR] [numeric](4, 0) NULL,
[SHIP_GEAR] [varchar](40) NULL,
[PHONE_NUM] [varchar](20) NULL,
[FAX_NUM] [varchar](20) NULL,
[TELEX_NUM] [varchar](20) NULL,
[EMAIL_ADDR] [varchar](255) NULL,
[REMARKS_TXT] [varchar](255) NULL,
[DELETED_FLG] [char](1) NOT NULL,
[LAST_UPDATE_USER_ID] [numeric](10, 0) NOT NULL,
[LAST_UPDATE_DT] [datetime] NOT NULL,
[CREATE_USER_ID] [numeric](10, 0) NOT NULL,
[CREATE_DT] [datetime] NOT NULL,
[INACTIVE_DT] [datetime] NULL,
[INACTIVE_REMARKS] [varchar](1000) NULL,
[HEIGHT] [numeric](5, 3) NULL,
[KLINE_CHARTER_OWN_FLG] [char](1) NOT NULL,
[DAILY_HIRE_USD] [numeric](7, 2) NULL,
[DAILY_HIRE_JPY] [numeric](7, 0) NULL,
[KAF_COMMISSION_FLG] [char](1) NOT NULL,
[HIRE_PERIOD_FROM] [datetime] NULL,
[HIRE_PERIOD_TO_MIN] [datetime] NULL,
[HIRE_PERIOD_TO_MAX] [datetime] NULL,
[INACTIVE_FLG] [char](1) NOT NULL,
CONSTRAINT [PK_MG_VESSEL_PARTICULAR] PRIMARY KEY CLUSTERED
(
[VESSEL_CD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
------------------------------------------
Pls find my Main Query and sample data for the MG_VESSEL_PARTICULAR table attached.
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.
2nd table: MG_VESSEL_VOYAGE
-----------------------------
USE [MiniGapp]
GO
/****** Object: Table [dbo].[MG_VESSEL_VOYAGE] Script Date: 08/04/2011 10:39:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MG_VESSEL_VOYAGE](
[VESSEL_CD] [varchar](6) NOT NULL,
[VOYAGE_CD] [varchar](6) NOT NULL,
[LEG_CD] [char](1) NOT NULL,
[OPERATOR_CD] [varchar](4) NULL,
[PRINCIPAL_01_CD] [varchar](4) NULL,
[PRINCIPAL_02_CD] [varchar](4) NULL,
[PRINCIPAL_03_CD] [varchar](4) NULL,
[PRINCIPAL_04_CD] [varchar](4) NULL,
[PRINCIPAL_05_CD] [varchar](4) NULL,
[SERVICE_CD] [varchar](10) NOT NULL,
[CAPTAIN_NAME_DSC] [varchar](24) NULL,
[SCHEDULE_REFERENCE_DSC] [varchar](10) NULL,
[START_VOYAGE_DT] [datetime] NOT NULL,
[END_VOYAGE_DT] [datetime] NOT NULL,
[PLAN_INPUT_OFFICE_DSC] [varchar](10) NULL,
[PLAN_INPUT_SECTION_DSC] [varchar](10) NULL,
[PLAN_INPUT_USER_DSC] [varchar](10) NULL,
[REFERENCE_ONLY_FLG] [char](1) NOT NULL,
[DELETED_FLG] [char](1) NOT NULL,
[LAST_UPDATE_USER_ID] [decimal](10, 0) NULL,
[LAST_UPDATE_DT] [datetime] NULL,
[CREATE_USER_ID] [decimal](10, 0) NOT NULL,
[CREATE_DT] [datetime] NOT NULL,
CONSTRAINT [PK_MG_VESSEL_VOYAGE] PRIMARY KEY CLUSTERED
(
[VESSEL_CD] ASC,
[VOYAGE_CD] ASC,
[LEG_CD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
--------------------------------
sample data attached:
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.
3rd table: MG_VSLVOY_SCHEDULE
-----------------------------
USE [MiniGapp]
GO
/****** Object: Table [dbo].[MG_VSLVOY_SCHEDULE] Script Date: 08/04/2011 10:43:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MG_VSLVOY_SCHEDULE](
[VSLVOY_SCHEDULE_ID] [numeric](10, 0) NOT NULL,
[PORT_CD] [varchar](5) NOT NULL,
[FACILITY_CD] [varchar](10) NULL,
[ARRIVAL_SCHEDULE_DT] [datetime] NULL,
[ARRIVAL_SCHEDULE_GMT_DT] [datetime] NULL,
[ARRIVAL_ESTIMATE_DT] [datetime] NULL,
[ARRIVAL_ESTIMATE_GMT_DT] [datetime] NULL,
[ARRIVAL_ACTUAL_DT] [datetime] NULL,
[ARRIVAL_ACTUAL_GMT_DT] [datetime] NULL,
[ARRIVAL_STATUS_CD] [char](1) NULL,
[BERTH_SCHEDULE_DT] [datetime] NULL,
[BERTH_ESTIMATE_DT] [datetime] NULL,
[BERTH_ACTUAL_DT] [datetime] NULL,
[BERTH_STATUS_CD] [char](1) NULL,
[DEPART_SCHEDULE_DT] [datetime] NULL,
[DEPART_SCHEDULE_GMT_DT] [datetime] NULL,
[DEPART_ESTIMATE_DT] [datetime] NULL,
[DEPART_ESTIMATE_GMT_DT] [datetime] NULL,
[DEPART_ACTUAL_DT] [datetime] NULL,
[DEPART_ACTUAL_GMT_DT] [datetime] NULL,
[DEPART_STATUS_CD] [char](1) NULL,
[CY_AVAILABILITY_SCHEDULE_DT] [datetime] NULL,
[CY_AVAILABILITY_ESTIMATE_DT] [datetime] NULL,
[CY_AVAILABILITY_ACTUAL_DT] [datetime] NULL,
[CY_AVAILABILITY_STATUS_CD] [char](1) NULL,
[CFS_AVAILABILITY_SCHEDULE_DT] [datetime] NULL,
[CFS_AVAILABILITY_ESTIMATE_DT] [datetime] NULL,
[CFS_AVAILABILITY_ACTUAL_DT] [datetime] NULL,
[CFS_AVAILABILITY_STATUS_CD] [char](1) NULL,
[CY_CUTOFF_SCHEDULE_DT] [datetime] NULL,
[CY_CUTOFF_ESTIMATE_DT] [datetime] NULL,
[CY_CUTOFF_ACTUAL_DT] [datetime] NULL,
[CY_CUTOFF_STATUS_CD] [char](1) NULL,
[CFS_CUTOFF_SCHEDULE_DT] [datetime] NULL,
[CFS_CUTOFF_ESTIMATE_DT] [datetime] NULL,
[CFS_CUTOFF_ACTUAL_DT] [datetime] NULL,
[CFS_CUTOFF_STATUS_CD] [char](1) NULL,
[COMMENCED_OPE_ESTIMATE_DT] [datetime] NULL,
[COMMENCED_OPE_ACTUAL_DT] [datetime] NULL,
[COMMENCED_OPE_STATUS_CD] [char](1) NULL,
[VESSEL_DISCHARGE_COMPLETE_DT] [datetime] NULL,
[COMPLETED_OPE_ESTIMATE_DT] [datetime] NULL,
[COMPLETED_OPE_ACTUAL_DT] [datetime] NULL,
[COMPLETED_OPE_STATUS_CD] [char](1) NULL,
[DOCUMENTATION_CUTOFF_DT] [datetime] NULL,
[AWK_REF_SEQ_NBR] [numeric](3, 0) NULL,
[RFR_REF_SEQ_NBR] [numeric](3, 0) NULL,
[HZD_REF_SEQ_NBR] [numeric](3, 0) NULL,
[GENERAL_REMARKS_TXT] [varchar](255) NULL,
[ARRIVAL_DELAY_REASON_TXT] [varchar](70) NULL,
[DEPARTURE_DELAY_REASON_TXT] [varchar](70) NULL,
[EOSP_SCHEDULE_DT] [datetime] NULL,
[EOSP_ESTIMATE_DT] [datetime] NULL,
[EOSP_ACTUAL_DT] [datetime] NULL,
[EOSP_STATUS_CD] [char](1) NULL,
[ANCHORED_DT] [datetime] NULL,
[PILOT_ON_BOARD_ESTIMATE_DT] [datetime] NULL,
[PILOT_ON_BOARD_ACTUAL_DT] [datetime] NULL,
[PILOT_ON_BOARD_STATUS_CD] [char](1) NULL,
[BOSP_SCHEDULE_DT] [datetime] NULL,
[BOSP_ESTIMATE_DT] [datetime] NULL,
[BOSP_ACTUAL_DT] [datetime] NULL,
[BOSP_STATUS_CD] [char](1) NULL,
[ETA_NEXT_PORT] [datetime] NULL,
[DRAFT_ARRIVAL_FWD_NBR] [numeric](4, 2) NULL,
[DRAFT_ARRIVAL_AFT_NBR] [numeric](4, 2) NULL,
[DRAFT_DEPARTURE_FWD] [numeric](4, 2) NULL,
[DRAFT_DEPARTURE_AFT_NBR] [numeric](4, 2) NULL,
[ROB_ARRIVAL_FO_NBR] [numeric](7, 2) NULL,
[ROB_ARRIVAL_DO_NBR] [numeric](7, 2) NULL,
[ROB_ARRIVAL_GO_NBR] [numeric](7, 2) NULL,
[ROB_ARRIVAL_LSFO_NBR] [numeric](7, 2) NULL,
[ROB_ARRIVAL_LSDO_NBR] [numeric](7, 2) NULL,
[ROB_ARRIVAL_FW_NBR] [numeric](7, 2) NULL,
[ROB_ARRIVAL_BW_NBR] [numeric](7, 2) NULL,
[ROB_DEPARTURE_FO_NBR] [numeric](7, 2) NULL,
[ROB_DEPARTURE_DO_NBR] [numeric](7, 2) NULL,
[ROB_DEPARTURE_GO_NBR] [numeric](7, 2) NULL,
[ROB_DEPARTURE_LSFO_NBR] [numeric](7, 2) NULL,
[ROB_DEPARTURE_LSDO_NBR] [numeric](7, 2) NULL,
[ROB_DEPARTURE_FW_NBR] [numeric](7, 2) NULL,
[ROB_DEPARTURE_BW_NBR] [numeric](7, 2) NULL,
[SUPPLIED_FO_NBR] [numeric](7, 2) NULL,
[SUPPLIED_DO_NBR] [numeric](7, 2) NULL,
[SUPPLIED_GO_NBR] [numeric](7, 2) NULL,
[SUPPLIED_LSFO_NBR] [numeric](7, 2) NULL,
[SUPPLIED_LSDO_NBR] [numeric](7, 2) NULL,
[SUPPLIED_FW_NBR] [numeric](7, 2) NULL,
[REPORT_REMARKS_TXT] [varchar](255) NULL,
[DELETED_FLG] [char](1) NOT NULL,
[LAST_UPDATE_USER_ID] [numeric](10, 0) NOT NULL,
[LAST_UPDATE_DT] [datetime] NOT NULL,
[CREATE_USER_ID] [numeric](10, 0) NOT NULL,
[CREATE_DT] [datetime] NOT NULL,
[EU_ENTRY_PORT_FLG] [char](1) NULL,
CONSTRAINT [PK_MG_VSLVOY_SCHEDULE] PRIMARY KEY CLUSTERED
(
[VSLVOY_SCHEDULE_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
------------------
sample data attached
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.
4th table: MG_VSLVOY_HEADER
----------------------------
USE [MiniGapp]
GO
/****** Object: Table [dbo].[MG_VSLVOY_HEADER] Script Date: 08/04/2011 10:46:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MG_VSLVOY_HEADER](
[VSLVOY_HEADER_ID] [numeric](10, 0) NOT NULL,
[VESSEL_CD] [varchar](10) NOT NULL,
[VOYAGE_NUM] [varchar](12) NOT NULL,
[LEG_CD] [char](1) NULL,
[OPERATOR_CD] [varchar](5) NULL,
[SERVICE_CD] [varchar](10) NOT NULL,
[START_VOYAGE_DT] [datetime] NOT NULL,
[END_VOYAGE_DT] [datetime] NOT NULL,
[SCHEDULE_COMPLETE_FLG] [char](1) NOT NULL,
[DELETED_FLG] [char](1) NOT NULL,
[LAST_UPDATE_USER_ID] [numeric](10, 0) NOT NULL,
[LAST_UPDATE_DT] [datetime] NOT NULL,
[CREATE_USER_ID] [numeric](10, 0) NOT NULL,
[CREATE_DT] [datetime] NOT NULL,
CONSTRAINT [PK_MG_VSLVOY_HEADER] PRIMARY KEY CLUSTERED
(
[VSLVOY_HEADER_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
---------------------------
sample data attached
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.
5th and last table: MG_VSLVOY_PORT_CONTROL
-------------------------------
USE [MiniGapp]
GO
/****** Object: Table [dbo].[MG_VSLVOY_PORT_CONTROL] Script Date: 08/04/2011 10:48:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MG_VSLVOY_PORT_CONTROL](
[VSLVOY_PORT_CONTROL_ID] [numeric](10, 0) NOT NULL,
[VSLVOY_HEADER_ID] [numeric](10, 0) NOT NULL,
[VSLVOY_SCHEDULE_ID] [numeric](10, 0) NOT NULL,
[LOCAL_VOYAGE_NUM] [varchar](12) NULL,
[PORT_SEQUENCE_NBR] [numeric](1, 0) NOT NULL,
[CALLING_PURPOSE_CD] [char](1) NOT NULL,
[DELETED_FLG] [char](1) NOT NULL,
[LAST_UPDATE_USER_ID] [numeric](10, 0) NOT NULL,
[LAST_UPDATE_DT] [datetime] NOT NULL,
[CREATE_USER_ID] [numeric](10, 0) NOT NULL,
[CREATE_DT] [datetime] NOT NULL,
CONSTRAINT [PK_MG_VSLVOY_PORT_CONTROL] PRIMARY KEY CLUSTERED
(
[VSLVOY_PORT_CONTROL_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
-------------------------
sample data attached
August 4, 2011 at 4:41 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 the sample report output attached.
August 4, 2011 at 6:36 am
I'm going to have to take a rain check. If you [re]read the article Jeff reffered to you'll realize that we need insert statements and not excel spreadsheets (which we can't use).
I'm off to bet now. Good luck with this.
August 4, 2011 at 7:05 am
Nice double post.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 4, 2011 at 7:12 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:14 am
Come on kids, kiss and make up. This is supposed to be a professional environement.
August 4, 2011 at 7:17 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 find the sample report output attached.
Ninja, do you know how to convert the data in the tables to an insert using SQL automatically ? I dont know where to go with this ? repenting the day I got myself forced into sql..
August 4, 2011 at 7:21 am
August 4, 2011 at 7:34 am
pwalter83 (8/4/2011)
Ninja, do you know how to convert the data in the tables to an insert using SQL automatically ? I dont know where to go with this ? repenting the day I got myself forced into sql..
Well, since you've already taken the trouble to put the data into spreadsheets, why don't you write a simple formula in Excel that will generate the INSERT statements - one for each row?
John
Viewing 15 posts - 16 through 30 (of 63 total)
You must be logged in to reply to this topic. Login to reply