I HAVE SP TO GET RESULTS 3 COLUMN:
USE [CHManager]
GO
/****** Object: StoredProcedure [dbo].[sp_TinhGiaVon] Script Date: 10/16/2014 09:10:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_TinhGiaVon]
@LocID nvarchar(10) =NULL,
@TuNgay date =NULL,
@DenNgay date =NULL
--@MaKho nvarchar(10) OUT,@MaHang nvarchar(20) OUT,@Gia float OUT
as
BEGIN
--declare @MK nvarchar(10),@MH nvarchar(20),@gia float
Select h.MaKho, h.MaHang,SUM(THANHTIEN)/SUM(QTY) as PRICE from (
select n.MaKho,dtl.MaHang,dtl.TenHang,SUM(dtl.SoLuong) as QTY,SUM(dtl.ThanhTien) as THANHTIEN,SUM(dtl.GiamTien)as GIAMTIEN from PhieuNhapSi n INNER JOIN CT_PNSi dtl
on n.Ma_PNSi = dtl.ID AND n.MaKho = dtl.MaKho
AND N.NgayNhap BETWEEN @TuNgay AND @DenNgay
GROUP BY n.MaKho,dtl.MaHang,dtl.TenHang
UNION
sele ...
Go to the complete details ...