I done

;with WeekTable(i,Week,Day,NoWeeK,NoDay,Total) as (

select 1, 1, 1, 4, 7, 28

union all

select i+1,

...

i done it ...

just a small change

here

, convert(varchar(500), [pd].[sort_column] + '-' + case [cd].[TRNType] when 'S' then convert(varchar,cd.Sort_Order)+ '2S' when 'A' then '1A' end...

This is my Solution with cursor

ALTER procedure [dbo].[SP_Get_F_PEriod_Log]

@cid bigint

as

create table #my_log (periodid bigint,[Open] varchar(100),[Close] varchar(100),Reopen varchar(100))

declare @periodid bigint

declare my_cur cursor for

select distinct Periodid from Tabl_Period_Log where companyid=@cid

open my_cur

fetch next...

hi ..

i solved my self

Declare @Date as DateTime = '03/01/2012'

Declare @Columns as Varchar(100) = '['+CAST(@Date as Varchar)+']' + ',' +'['+ CAST( dateadd(day,1,@Date) as Varchar) +']'

print...

hi yes i have variable number of till..

which i am getting in variable ... using

count statement from other table...

Hello

I am Able To do..

By Using That Query

select pu.Supplier_ID,pa.Purchase_ID,pa.Paid_amt

into #temp1

from tbl_Purchase pu

inner join

tbl_pur_Child pa

on

pu.Purchase_id =pa.Purchase_ID

select Supplier_ID,sum(paid_amt) as Paid from #temp1 group by Supplier_ID

Hi..

When I am Using Ur Same Query .. Or My Query in this Set of Data My Result Not Meet My Requirement

INSERT INTO [dnm] VALUES(5,5,0,'G','Expenditure')

INSERT INTO [dnm] VALUES(14,5,5,'S','Goods for...

This I Was Try To Do...

Thanks To every One.. For give useful suggestion...

ALTER procedure [dbo].[ShowHierarchy]

@Root int

as

DECLARE @ACID int, @ACName varchar(500),@ACType varchar(50),@ACType1 varchar(50)

...

But in front end i can't rearrange this data....

for this i again need recursion..

so this is more time consuming....

But in front end i can't rearrange this data....

for this i again need recursion..

Yes..

Actually I am Getting All my result....

But is not showing in format which i want...

i want first show group

then subgroup

then subgroup account if there is any

Then other sub sub group...

Please Help me On this Problem....

In That Case This Will Not Give Full Result

Its Only Give

----Group1--

--------SubGroup11--

------------AC11--

------------AC12--

--------SubGroup12--

Thanks ... its HelpFul to me....

i tried with all outer join ...

but its not working...