Viewing 15 posts - 166 through 180 (of 210 total)
I don't know whether cast is better or convert is better.
CAST (SUM(Principal1) AS DECIMAL(5,2) ) + CAST ( SUM(BankInterest) AS DECIMAL(5,2)) + CAST(SUM(TAltrate) as DECIMAL(5,2) AS Amount
or
CAST (SUM(Principal1) + SUM(BankInterest) + SUM(TAltrate) + SUM(PanaltyCharge) AS DECIMAL(5,2))
Above query gives almost similar results/value...
April 17, 2018 at 9:21 pm
For example: The sentence...
April 16, 2018 at 7:50 pm
April 13, 2018 at 11:02 pm
April 12, 2018 at 9:31 pm
April 11, 2018 at 12:40 am
April 10, 2018 at 11:29 pm
April 3, 2018 at 5:29 pm
SELECT
April 3, 2018 at 5:03 am
This is not working. It is telling me that From keyword not where expected.
select top...
March 29, 2018 at 9:17 am
March 28, 2018 at 12:14 pm
March 28, 2018 at 11:50 am
March 22, 2018 at 1:49 am
Viewing 15 posts - 166 through 180 (of 210 total)