Click here to Skip to main content
15,891,253 members

Comments by irfanansari (Top 169 by date)

irfanansari 4-Nov-20 15:38pm View    
sir you are best thanks a lot always be happy
irfanansari 30-Sep-19 10:32am View    
i am so sorry aarti you are best one who teaching me a lot you are first one who helping me a lot really i am deep of heart thanks full of you i am new learner and actually i am creating a website ERP base application in asp.net i am not big expert first application website i am making by helping bootstrap css and vb.net asp.net. Aarti this is my first experience any person helped me continuously reply me all my question i am again thanks full for you i am From Pakistan I Pray For You Allah Give You Success In Your Life
Aarti if you believe me and if you not mind then would you like to give me your any contact as i personally take help from you please
thanks a lot
irfanansari 30-Sep-19 7:30am View    
sir thanks a lot just please can you help tell what is i here mean and work its for learning for me thanks

(select sum(Qty) from inv where VouDt< i.VouDt) as OpnQty

i.VouDt what is mean of i here ?
irfanansari 30-Sep-19 7:21am View    
yes sir thanks a lot sir i have a use full query which i got thanks a lot for helping me

select sum(case when ddate < '2019-09-02'
then credit end) -
sum(case when ddate < '2019-09-02'
then debit end)[Opening Balance],
sum(case when ddate <= '2019-09-03'
then credit end) -
sum(case when ddate <= '2019-09-03'
then debit end)[Closing Balance] from tt
irfanansari 30-Sep-19 5:58am View    
sir ok i have a -1 as closing date 2012-04-01 ok and opening balance null ok understandable
then 201-04-02 become last closing balance -1 will be opening -1 it is ok and qty 1
then how it is closing balance -2 it can be 0 or null as closing because -1+1=0 as closing balance
2012-04-03 opening balance is OK 0 and closing -1 why if qty 1
opeing is 0 and qty 1 then closing must be 1 but on 2012-04-03 closing -1 ??????