1
Answer

Using Date and Time

Mohammadali

Mohammadali

12y
1.2k
1
How do I calculate 365 days from the last application is started?

If I use the system. User may change it back and forth

1.
What software will not work for a lock

Software should
be calculated after 365 days in office have all been closed and a message will be new offices and again How do I calculate 365 days have passed and the new offices should be created?

Answers (1)
1
varsha dodiya

varsha dodiya

NA 415 42.8k 10y
i solved it 

Select Cast(SUM((O_ttotal + P_vatto) * (P_totdis / 100)) As Decimal(9,2)) As TotalDiscount From PRO_BILL
0
varsha dodiya

varsha dodiya

NA 415 42.8k 10y
@Abrar that i also know, in this way i get two answers i want the whole total of (A+B+C) not (A+B) and C
0
Khan Abrar Ahmed

Khan Abrar Ahmed

NA 5.8k 200k 10y
HI, when you are using the aggregate sql function then you have to define the group by clause.

like 
cmd = new SqlCommand("Select (SUM(P_ttotal)+SUM(P_vatto)* (P_totdis)/100) as dis  from PRO_BILL group by P_totdis", conn);