X
xyzer
SQL below ... the "notes" field is the field being truncated. Any ideas? When I view the table without joining it to my other query, the notes are nottruncated. thanks.
INSERT INTO [JH-Post Install Work 5a Table] ( [Sub Problem ID], [Job End Date Month], [Job End Date Year], [Entered by], [Ticket Number], [End Date], UserCode, Notes, Service_Ticket_Id, Installer, Note_id, Employee_Code, Job_Code, Customer_Site_Id, Ticket_Number, Business_Name, GE1_Description, GE2_Short, Problem_Id, Problem_Code, Creation_Date, Dispatch_Time, Departure_Time, Arrival_Time, [Dispatch Tag], [Arrival Tag], [Departure Tag], [CreationYear], [Creation Month] )
SELECT [JH-Post Install Work 4].Sub_Problem_Id, DatePart("m",[End_Date]) AS[Job End Month], DatePart("yyyy",[End_Date]) AS [Job End Year], [JH-Post Install Work 4].Entered_By, [JH-Post Install Work 4].[Ticker Number], [JH-Post Install Work 4].End_Date, dbo_SV_Service_Ticket_Notes.UserCode,
dbo_SV_Service_Ticket_Notes.Notes,
[JH-Post Install Work 4].Service_Ticket_Id, [JH-Post Install Work 4].Installer, [JH-Post Install Work 4].Note_id, [JH-Post Install Work 4].Employee_Code, [JH-Post Install Work 4].Job_Code, [JH-Post Install Work 4].Customer_Site_Id, [JH-Post Install Work 4].Ticket_Number, [JH-Post Install Work 4].Business_Name, [JH-Post Install Work 4].GE1_Description, [JH-Post Install Work4].GE2_Short, [JH-Post Install Work 4].Problem_Id, [JH-Post Install Work 4].Problem_Code, [JH-Post Install Work 4].Creation_Date, IIf([Dispatch_Time]=#12/30/1899#,[Creation_date],[Dispatch_Time]) AS Dispatch, IIf([Departure_Time]=#12/30/1899#,[Creation_date],[Departure_Time]) AS Departure, IIf([Arrival_Time]=#12/30/1899#,[Creation_date],[Arrival_Time]) AS Arrival, IIf([Dispatch_Time]=#12/30/1899#,"Not yet Dispatched","Has Dispatched") AS[Dispatch Tag], IIf([Arrival_Time]=#12/30/1899#,"Has not arrived","Has arrived") AS [Arrival Tag], IIf([Departure_Time]=#12/30/1899#,"Has not departed","Has departed") AS [Departure Tag], [JH-Post Install Work 4].[Creation Year], [JH-Post Install Work 4].[Creation Month]
FROM [JH-Post Install Work 4] LEFT JOIN dbo_SV_Service_Ticket_Notes ON [JH-Post Install Work 4].Service_Ticket_Id = dbo_SV_Service_Ticket_Notes.Service_Ticket_Id;
INSERT INTO [JH-Post Install Work 5a Table] ( [Sub Problem ID], [Job End Date Month], [Job End Date Year], [Entered by], [Ticket Number], [End Date], UserCode, Notes, Service_Ticket_Id, Installer, Note_id, Employee_Code, Job_Code, Customer_Site_Id, Ticket_Number, Business_Name, GE1_Description, GE2_Short, Problem_Id, Problem_Code, Creation_Date, Dispatch_Time, Departure_Time, Arrival_Time, [Dispatch Tag], [Arrival Tag], [Departure Tag], [CreationYear], [Creation Month] )
SELECT [JH-Post Install Work 4].Sub_Problem_Id, DatePart("m",[End_Date]) AS[Job End Month], DatePart("yyyy",[End_Date]) AS [Job End Year], [JH-Post Install Work 4].Entered_By, [JH-Post Install Work 4].[Ticker Number], [JH-Post Install Work 4].End_Date, dbo_SV_Service_Ticket_Notes.UserCode,
dbo_SV_Service_Ticket_Notes.Notes,
[JH-Post Install Work 4].Service_Ticket_Id, [JH-Post Install Work 4].Installer, [JH-Post Install Work 4].Note_id, [JH-Post Install Work 4].Employee_Code, [JH-Post Install Work 4].Job_Code, [JH-Post Install Work 4].Customer_Site_Id, [JH-Post Install Work 4].Ticket_Number, [JH-Post Install Work 4].Business_Name, [JH-Post Install Work 4].GE1_Description, [JH-Post Install Work4].GE2_Short, [JH-Post Install Work 4].Problem_Id, [JH-Post Install Work 4].Problem_Code, [JH-Post Install Work 4].Creation_Date, IIf([Dispatch_Time]=#12/30/1899#,[Creation_date],[Dispatch_Time]) AS Dispatch, IIf([Departure_Time]=#12/30/1899#,[Creation_date],[Departure_Time]) AS Departure, IIf([Arrival_Time]=#12/30/1899#,[Creation_date],[Arrival_Time]) AS Arrival, IIf([Dispatch_Time]=#12/30/1899#,"Not yet Dispatched","Has Dispatched") AS[Dispatch Tag], IIf([Arrival_Time]=#12/30/1899#,"Has not arrived","Has arrived") AS [Arrival Tag], IIf([Departure_Time]=#12/30/1899#,"Has not departed","Has departed") AS [Departure Tag], [JH-Post Install Work 4].[Creation Year], [JH-Post Install Work 4].[Creation Month]
FROM [JH-Post Install Work 4] LEFT JOIN dbo_SV_Service_Ticket_Notes ON [JH-Post Install Work 4].Service_Ticket_Id = dbo_SV_Service_Ticket_Notes.Service_Ticket_Id;