TWIN MODULE - Dyncraft

eBom vs mBom 

SELECT distinct * FROM [DataStage].[dbo].[CUMEBOM_LOADING] as CL where CL.LineSeqNbr='T0890F0' and CL.ChassisNbr='790040';

select * from EWI_DataWarehouse.dbo.OpenJITs as OJT where OJT.LineSeqNbr ='T0890F0';

select * from EWI_DataWarehouse.dbo.OpenJITs as OJT where OJT.ItemID ='M86-6301-127106';

SignalR

--ALTER DATABASE SignalR SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;

SELECT is_broker_enabled FROM sys.databases WHERE name = 'SignalR';

CREATE TABLE [dbo].[ToolInfo](

[ToolID] [int] IDENTITY(1,1) NOT NULL,

[ToolName] [nvarchar](50) NOT NULL,

[Status] [bit] NOT NULL,

[SequenceNo] [nchar](10) NULL,

 CONSTRAINT [PK_ToolInfo] PRIMARY KEY CLUSTERED 

(

[ToolID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[ToolInfo] ON 

GO

INSERT [dbo].[ToolInfo] ([ToolID], [ToolName], [Status], [SequenceNo]) VALUES (1, N'tool1', 0, N'1         ')

GO

INSERT [dbo].[ToolInfo] ([ToolID], [ToolName], [Status], [SequenceNo]) VALUES (2, N'tool44', 1, N'1         ')

GO

INSERT [dbo].[ToolInfo] ([ToolID], [ToolName], [Status], [SequenceNo]) VALUES (3, N'tool3', 1, N'2         ')

GO

INSERT [dbo].[ToolInfo] ([ToolID], [ToolName], [Status], [SequenceNo]) VALUES (4, N'tool4', 1, N'2         ')

GO

SET IDENTITY_INSERT [dbo].[ToolInfo] OFF

GO

update ToolInfo set ToolName='tool44'

where ToolID=2