Comments by sansharam

sansharam 14-Jul-15 0:11am View

Sorry all

i found my mistake
I had to copy all dlls to bin directory at the root
i did copied all dlls at a seperate directory/bin in the root directory
now I copied all dlls and files to the bin directory in the root.... now problem solved

I thought some one may be helped by my answer...............

Regards
Santosh Sharma

sansharam 4-Jul-15 9:40am View

checked it and it seems all rightly done
while adding reference Local copy is true so dll is in bin folder
Path is also the same.

sansharam 9-Jul-13 11:50am View

Deleted

I tried with this code but unable to get the required result as there is a problem with date comparison

'DECLARE @t TABLE (SlNo INT IDENTITY (1, 1) NOT NULL, Date DATETIME, Session VARCHAR(30), TotalMembers INT, TotalLitres DECIMAL(8, 2), Amount DECIMAL(8, 2), GTFat DECIMAL(8, 2), GTPrice DECIMAL(8, 2), GTAmount DECIMAL(8, 2), PnL DECIMAL(8, 2)); INSERT INTO @t (Date, Session, TotalMembers, TotalLitres, Amount)
 SELECT Cast(Date as date), Session, Count(MemberCode), Sum(Litres), Sum(Amount) FROM myTable Where Col1 = 'P' and Date between '2013-07-01' and '2013-07-09' GROUP BY Cast(Date as Date), Session Order By Cast(Date as date)

declare @maxcount int,@loop int
declare @cr money,@dr money

set @loop =1
select @maxcount= MAX(SlNo )
from @t

while(@loop <= @maxcount) begin
    Update @t Set GTFat = (Select Fat From mTran Where Date=Date and Session=Session and Col1='GT'),
    GTPrice=(Select Price From mTran Where Date=Date and Session=Session and Col1='GT')
    set @loop = @loop + 1
end

SELECT *
FROM @t
order by Cast(Date as date)'

Comments by sansharam (Top 3 by date)