USE [BMS] GO /****** Object: StoredProcedure [dbo].[sp_SearchParticularsDetails] Script Date: 12-07-2016 11:19:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[sp_SearchParticularsDetails] ( @fromdate datetime, @todate datetime ) as begin declare @columnname as varchar(100) select @columnname=ISNULL(@columnname+',','')+QUOTENAME(Expenses_Name) from (select distinct Expenses_Name from dbo.Expenses) as Expenses_Name select * from ( select dbo.CreditDebit.ID as SLNO,TransactionDate,Particular,Balance,Expenses,Credit_Expenses,Debit_Expenses,','+@columnname FROM DBO.CreditDebit INNER JOIN DBO.CreditExpenses on dbo.CreditDebit.ID=dbo.CreditExpenses.Credit_ID inner join dbo.Expenses on dbo.Expenses.ID=dbo.CreditExpenses.Expenses_ID where dbo.CreditDebit.TransactionDate between @fromdate and @todate ) as details pivot( sum(Expenses) for Expenses_Name in()as pvt end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)