no funciona procedure
Publicado por no funciona procedure (1 intervención) el 02/03/2005 22:10:46
DROP PROCEDURE sp_resumvendes
CREATE PROCEDURE sp_resumvendes
@data1 VARCHAR(20) ,@data2 VARCHAR(20)
AS
SELECT a.au_fname,a.au_lname,s.ord_date,SUM(t.price * s.qty) as VENDES
FROM authors a INNER JOIN titleauthor ta ON(a.au_id=ta.au_id)
INNER JOIN titles t ON(ta.title_id=t.title_id)
INNER JOIN sales s ON(ta.title_id=s.title_id)
WHERE DATEPART(YEAR,s.ord_date) BETWEEN @data1 AND @data2
GROUP BY a.au_fname,a.au_lname,s.ord_Date
ORDER BY a.au_fname
DECLARE @dat VARCHAR(20)
DECLARE @dat1 VARCHAR(20)
SET @dat = \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'1993\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'
SET @dat1 = \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'1994\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'
EXECUTE sp_resumvendes ,@dat,@dat1
Pues aki esta y me da este error ke estoy aciend omal
Server: Msg 170, Level 15, State 1, Line 7
Línea 7: sintaxis incorrecta cerca de \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'.
Por cierto el procedure deberia mostrar las ventas de un autor entre dos fechas
CREATE PROCEDURE sp_resumvendes
@data1 VARCHAR(20) ,@data2 VARCHAR(20)
AS
SELECT a.au_fname,a.au_lname,s.ord_date,SUM(t.price * s.qty) as VENDES
FROM authors a INNER JOIN titleauthor ta ON(a.au_id=ta.au_id)
INNER JOIN titles t ON(ta.title_id=t.title_id)
INNER JOIN sales s ON(ta.title_id=s.title_id)
WHERE DATEPART(YEAR,s.ord_date) BETWEEN @data1 AND @data2
GROUP BY a.au_fname,a.au_lname,s.ord_Date
ORDER BY a.au_fname
DECLARE @dat VARCHAR(20)
DECLARE @dat1 VARCHAR(20)
SET @dat = \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'1993\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'
SET @dat1 = \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'1994\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'
EXECUTE sp_resumvendes ,@dat,@dat1
Pues aki esta y me da este error ke estoy aciend omal
Server: Msg 170, Level 15, State 1, Line 7
Línea 7: sintaxis incorrecta cerca de \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\',\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\'.
Por cierto el procedure deberia mostrar las ventas de un autor entre dos fechas
Valora esta pregunta


0