Mahmoud Gamal Taha MahmoudGamlTaha

A distilled list of open-source CRM software

	-- ================================================
	-- Template generated from Template Explorer using:
	-- Create Procedure (New Menu).SQL
	--
	-- Use the Specify Values for Template Parameters
	-- command (Ctrl-Shift-M) to fill in the parameter
	-- values below.
	--
	-- This block of comments will not be included in
	-- the definition of the procedure.

	-- ================================================
	-- Template generated from Template Explorer using:
	-- Create Procedure (New Menu).SQL
	--
	-- Use the Specify Values for Template Parameters
	-- command (Ctrl-Shift-M) to fill in the parameter
	-- values below.
	--
	-- This block of comments will not be included in
	-- the definition of the procedure.

	USE [AmnDb003]
	GO

	/**** Object: StoredProcedure [dbo].[materialsMoveReptest] Script Date: 5/11/2017 10:20:22 AM ****/
	SET ANSI_NULLS ON
	GO

	SET QUOTED_IDENTIFIER ON
	GO

	void MatsMoveReport::DefineReport(CReportDefinition& rd)
	{
	auto view = make_shared<CReportView>(L"");
	auto grid = make_shared<CGridVisualization>(Main_Result);

	grid->Columns.Add(LibResStr(IDS_MATERIALNAME, CostRepLib));
	grid->Columns.Add(LibResStr(IDS_UNIY, CostRepLib));
	grid->Columns.Add(LibResStr(IDS_GRPNAME, CostRepLib));

	view->Visualizations.Add(grid);

	alter proc materialsMoveReptest @billType uniqueidentifier =0x0 ,@billGuid uniqueidentifier =0x0,
	@matGuid uniqueidentifier =0x0,@grpGuid uniqueidentifier=0x0,
	@store_guid uniqueidentifier =0x0
	as
	begin
	-- helper tables
	CREATE TABLE #materials( [GUID] uniqueidentifier,secure int );
	CREATE TABLE #stores( [StGuid] uniqueidentifier,secure int );
	CREATE TABLE #bills( [GUID] uniqueidentifier,secure int,ReadPriceSec int,UnpostedSec int );
	CREATE TABLE [#grpDetails2] ([StoreGuid] UNIQUEIDENTIFIER, [Security] INT, [stName] NVARCHAR(256));