Evo primera. Script za kreiranje tabela:
Code:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Tabela_koja_se_puni](
[Datum] [datetime] NULL,
[Mesto] [char](20) NULL,
[Stanje] [char](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Tabela_kojom_se_puni](
[Datum] [datetime] NULL,
[Mesto] [char](20) NULL,
[Stanje] [char](10) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Slogovi u tabeli Tabela_koja_se_puni su:
2009-05-13 00:00:00.000 Beograd NULL
2009-05-16 00:00:00.000 Nis NULL
2009-05-13 00:00:00.000 Nis NULL
2009-05-13 00:00:00.000 Subotica NULL
2009-05-16 00:00:00.000 Subotica NULL
2009-05-16 00:00:00.000 Beograd NULL
Slogovi u tabeli Tabela_kojom_se_puni:
2009-05-12 00:00:00.000 Beograd 21
2009-05-12 00:00:00.000 Nis 22
2009-05-12 00:00:00.000 Subotica 23
2009-05-15 00:00:00.000 Beograd 31
2009-05-15 00:00:00.000 Nis 32
2009-05-15 00:00:00.000 Subotica 33
Upit treba da za prvi slog (2009-05-13 00:00:00.000 Beograd NULL) nadje u drugoj tabeli slog koji ima max datum koji je manji od 2009-05-13 i kome je Mesto Beograd i da prepise njegovo stanje tj. naci ce slog: 2009-05-12 00:00:00.000 Beograd 21 i upisati stanje 21 umesto null. I tako za svaki red.