CREATE TABLE [dbo].[RashodL_CurDate](
	[ralID]      [bigint]   NOT NULL,
	[ralCurDate] [datetime] NOT NULL CONSTRAINT [DF_RashodL_CurDate_ralInDate]  DEFAULT (getdate()),
	[usID]       [smallint] NOT NULL,
 CONSTRAINT [PK_RashodL_CurDate] PRIMARY KEY CLUSTERED 
    ([ralID] 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]

CREATE NONCLUSTERED INDEX [IX_RashodL_CurDate_usID] ON [dbo].[RashodL_CurDate]
  ([usID] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 99) ON [PRIMARY]

ALTER TABLE [dbo].[RashodL_CurDate]  WITH CHECK ADD  CONSTRAINT [FK_RashodL_CurDate_RashodL] FOREIGN KEY([ralID]) REFERENCES [dbo].[RashodL] ([ID])
    ON DELETE CASCADE
ALTER TABLE [dbo].[RashodL_CurDate] CHECK CONSTRAINT [FK_RashodL_CurDate_RashodL]

ALTER TABLE [dbo].[RashodL_CurDate]  WITH CHECK ADD  CONSTRAINT [FK_RashodL_CurDate_Users] FOREIGN KEY([usID]) REFERENCES [dbo].[Users] ([ID])
ALTER TABLE [dbo].[RashodL_CurDate] CHECK CONSTRAINT [FK_RashodL_CurDate_Users]

DECLARE @shID  tinyint = 1;
SELECT RashodL.ID As ralID, ralNomer, otAPB, otName, RashodL.usID, ISNULL(RashodL.usIDPlat, 0) AS usIDk
    FROM RashodL WITH(noLock)
        INNER JOIN RashodL_CurDate ON RashodL.ID = RashodL_CurDate.ralID
        INNER JOIN   Otdel WITH(noLock) ON RashodL.otID = Otdel.ID
WHERE RashodL.shID = @shID;