ALTER PROC sp_Basket
AS
BEGIN
DELETE FROM dbo.Basket WHERE DATEDIFF(hour, CreatedDate, getdate()) > 24
END
GO
Frågan#1
Hejsan!
Jag har suttit med ett problem som jag dock ej har funnit en lösning på än. Jag har skapat en lagrad procedur som ska ta bort produkter som har lagrats i databasen (SS 2005) mer än 24 timmar. Dock får jag bara upp ett felmeddelande som lyder
"Msg 147, Level 15, State 1, Procedure sp_Basket, Line 4
An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.
"
ALTER PROC sp_Basket
AS
BEGIN
DELETE FROM dbo.Basket WHERE CreatedDate In
(SELECT RowId FROM dbo.Basket WHERE DATEDIFF(hour, min(CreatedDate), getdate()) > 24)
END
GO