Code:
create VIEW racuni1
WITH SCHEMABINDING
AS SELECT dbo.proizvodi.ID, dbo.proizvodi.ime, dbo.proizvodi.cijena, SUM(dbo.racuni.kolicina) AS Expr1,
SUM(dbo.racuni.kolicina * dbo.proizvodi.cijena) AS Expr2
FROM dbo.racuni INNER JOIN
dbo.proizvodi ON dbo.racuni.ID_proizvodi = dbo.proizvodi.ID
group by dbo.proizvodi.ID, dbo.proizvodi.ime, dbo.proizvodi.cijena
GO
create VIEW racuni1
WITH SCHEMABINDING
AS SELECT dbo.proizvodi.ID, dbo.proizvodi.ime, dbo.proizvodi.cijena, SUM(dbo.racuni.kolicina) AS Expr1,
SUM(dbo.racuni.kolicina * dbo.proizvodi.cijena) AS Expr2
FROM dbo.racuni INNER JOIN
dbo.proizvodi ON dbo.racuni.ID_proizvodi = dbo.proizvodi.ID
group by dbo.proizvodi.ID, dbo.proizvodi.ime, dbo.proizvodi.cijena
GO
kad probam ovo izvršiti
Code:
create UNIQUE CLUSTERED INDEX ix_bbb ON racuni1(ID)
GO
create UNIQUE CLUSTERED INDEX ix_bbb ON racuni1(ID)
GO
dobijem grešku
Cannot create index on view 'marko.dbo.racuni1' because its select list does not include a proper use of COUNT_BIG. Consider adding COUNT_BIG(*) to select list.
u čemu griješim?
našao sam odgovor , molim moderatora da obriše temu
[Ovu poruku je menjao mmix dana 15.07.2009. u 08:50 GMT+1]