Курсовая - Базы данных. АИС "Библиотека" / 1

USE [Libr1]
GO
/****** Object: StoredProcedure [dbo].[For_otchet1] Script Date: 04/23/2012 09:09:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Batch submitted through debugger: SQLQuery6.sql|0|0|C:\Users\Miz'AnTRO(p)\AppData\Local\Temp\~vs3692.sql
ALTER procedure [dbo].[For_otchet1]
@_param1 Date,
@_param2 Date
as
begin
select dbo.book.name,dbo.author.surname, COUNT(dbo.book.name) as 'Count' from dbo.vidacha_books
inner join dbo.book on dbo.vidacha_books.id_book=dbo.book.id_book
inner join dbo.author ON dbo.book.author_id = dbo.author.author_id
where dbo.vidacha_books.date>= @_param1 and dbo.vidacha_books.date <= @_param2--+ INTERVAL '0-5' YEAR TO MONTH ))
group by dbo.author.surname,dbo.book.name
end