-
ThePuiu
-
-
-
Joined on 02-14-2007
-
Oradea
-
db_owner
-
-
|
Determinare stoc la data...
Am nevoie de ajutor la conceperea unei interogari qsl prin care sa pot determina stocul de marfa la o anumita data. Tabelele care intra in aceasta problema au urmatoarele caracteristici:
CREATE TABLE [dbo].[INTRARI](
[ID] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
[NRDOC] [decimal](18, 0) NULL,
[DATA] [smalldatetime] NULL,
[TIP] [nvarchar](10) COLLATE Romanian_CI_AS NULL,
[ID_FURNIZOR] [decimal](18, 0) NULL,
[VALOARE] [numeric](18, 2) NULL,
[TVA] [numeric](18, 2) NULL,
[ID_USER] [decimal](18, 0) NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[INTRARI_DETAIL](
[ID] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
[ID_INTRARI] [decimal](18, 0) NULL,
[PRODUS] [nvarchar](50) COLLATE Romanian_CI_AS NULL,
[COD] [nvarchar](50) COLLATE Romanian_CI_AS NULL,
[ UM ] [nvarchar](10) COLLATE Romanian_CI_AS NULL,
[CANTITATE] [numeric](18, 2) NULL,
[PRET_IN] [numeric](18, 2) NULL,
[PRET_OUT] [numeric](18, 2) NULL,
[STOC] [numeric](18, 2) NULL,
[TVA] [numeric](18, 2) NULL,
) ON [PRIMARY]
CREATE TABLE [dbo].[IESIRI](
[ID] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
[TIP] [nvarchar](50) COLLATE Romanian_CI_AS NULL,
[NRDOC] [decimal](18, 0) NULL,
[DATA] [smalldatetime] NULL,
[ID_CLIENT] [decimal](18, 0) NULL,
[PLATA] [decimal](18, 0) NULL,
[TERMENPLATA] [smalldatetime] NULL,
[CURS_VALUTAR] [money] NULL,
[ID_USER] [decimal](18, 0) NULL,
[VALOARE] [numeric](18, 2) NULL,
[TVA] [numeric](18, 2) NULL,
) ON [PRIMARY]
CREATE TABLE [dbo].[IESIRI_DETAIL](
[ID] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
[ID_IESIRI] [decimal](18, 0) NULL,
[ID_INTRARI] [decimal](18, 0) NULL,
[TEMPORARA] [bit] NULL,
[ UM ] [nvarchar](10) COLLATE Romanian_CI_AS NULL,
[CANTITATE] [numeric](18, 2) NULL,
[PRET] [numeric](18, 2) NULL,
[TVA] [numeric](18, 2) NULL,
) ON [PRIMARY]
CREATE TABLE [dbo].[PARTENERI](
[ID] [decimal](18, 0) IDENTITY(1,1) NOT NULL,
[TIP] [bit] NULL,
[NUME] [nvarchar](80) COLLATE Romanian_CI_AS NULL,
[CF] [nvarchar](50) COLLATE Romanian_CI_AS NULL,
[J] [nvarchar](50) COLLATE Romanian_CI_AS NULL,
[BANCA] [nvarchar](50) COLLATE Romanian_CI_AS NULL,
[CONT] [nvarchar](50) COLLATE Romanian_CI_AS NULL,
[LOCALITATEA] [nvarchar](50) COLLATE Romanian_CI_AS NULL,
[REPREZENTANT] [nvarchar](50) COLLATE Romanian_CI_AS NULL,
) ON [PRIMARY]
Conectarea logica a tabelelor este ceva de genul:
SELECT * FROM dbo.INTRARI_DETAIL INNER JOIN
dbo.INTRARI ON dbo.INTRARI_DETAIL.ID_INTRARI = dbo.INTRARI.ID INNER JOIN
dbo.IESIRI INNER JOIN
dbo.IESIRI_DETAIL ON dbo.IESIRI.ID = dbo.IESIRI_DETAIL.ID_IESIRI ON dbo.INTRARI_DETAIL.ID = dbo.IESIRI_DETAIL.ID_INTRARI INNER JOIN
dbo.PARTENERI ON dbo.INTRARI.ID_FURNIZOR = dbo.PARTENERI.ID
Ce vreau sa obtin in urma interogarii: denumirea produsului si stocul curent aferent la o data X, grupat pt produse cu acelasi nume si pret.
Eu nu reusesc sa obtin un rezultat corect  . Multumesc tuturor care vin cu o idee sau chiar o rezolvare!
|
|