Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a columns using "Concatenate Load * Inline [Elapsed Days];"
Now I want to subtract how many days between shipment date to registering date.
Please help.
SELECT
HE.[Original Order No_]
,[Internet Order No_]
,HA.[Order Date]
,[Item No_]
,HE.[Bill-to Name]
,RE.[Description]
,[Brand Code]
,RE.[Reason Code]
,HE.[Shipment Date]
,[Quantity]
,[Country]
,HE.[Shipping Agent Code]
,[Comments]
,[Entry No_]
,[Registering Date]
,[Zone Code]
,[Bin Code]
,RE.[Location Code]
,[Replaced_Refunded]
,[Cust__Post Return]
,RE.[User ID]
,[Unit of Measure Code]
,[Gross Weight]
FROM [TBW_BI].[dbo].[Feelunique Trading$Warehouse Returns] as RE
INNER JOIN [TBW_BI].[dbo].[Feelunique Trading$Item] AS IT
ON IT.[No_]=RE.[Item No_]
INNER JOIN [TBW_BI].[dbo].[Feelunique Trading$Sales Invoice Header] AS HE
ON HE.[Order GuID]=RE.[Internet Order No_]
INNER JOIN [TBW_BI].[dbo].[Feelunique Trading$Internet Order Header] AS HA
ON HA.[Order Guid]=RE. [Internet Order No_]
WHERE
HA.[Order Date] >= '2017-01-01T00:00:00.000' AND
HA.[Order Date] <= '2017-01-31T00:00:00.000' ;
load
HE.[Shipment Date],
[Registering Date],
[Registering Date] - [Shipment Date] as [Elapsed Days] FROM [TBW_BI].[dbo].[Feelunique Trading$Sales Invoice Header] ;
Try this:
LOAD *,
[Registering Date] - [Shipment Date] as [Elapsed Days];
SELECT
HE.[Original Order No_]
,[Internet Order No_]
,HA.[Order Date]
,[Item No_]
,HE.[Bill-to Name]
,RE.[Description]
,[Brand Code]
,RE.[Reason Code]
,HE.[Shipment Date]
,[Quantity]
,[Country]
,HE.[Shipping Agent Code]
,[Comments]
,[Entry No_]
,[Registering Date]
,[Zone Code]
,[Bin Code]
,RE.[Location Code]
,[Replaced_Refunded]
,[Cust__Post Return]
,RE.[User ID]
,[Unit of Measure Code]
,[Gross Weight]
FROM [TBW_BI].[dbo].[Feelunique Trading$Warehouse Returns] as RE
INNER JOIN [TBW_BI].[dbo].[Feelunique Trading$Item] AS IT
ON IT.[No_]=RE.[Item No_]
INNER JOIN [TBW_BI].[dbo].[Feelunique Trading$Sales Invoice Header] AS HE
ON HE.[Order GuID]=RE.[Internet Order No_]
INNER JOIN [TBW_BI].[dbo].[Feelunique Trading$Internet Order Header] AS HA
ON HA.[Order Guid]=RE. [Internet Order No_]
WHERE
HA.[Order Date] >= '2017-01-01T00:00:00.000' AND
HA.[Order Date] <= '2017-01-31T00:00:00.000' ;
May be this?
load
HE.[Shipment Date],
[Registering Date],
[Registering Date] - HE.[Shipment Date] as [Elapsed Days] FROM [TBW_BI].[dbo].[Feelunique Trading$Sales Invoice Header] ;
Thank you Sunny.