Viewing 15 posts - 166 through 180 (of 211 total)
Saravanan
April 20, 2018 at 9:08 am
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...
Saravanan
April 17, 2018 at 9:21 pm
For example: The sentence...
Saravanan
April 16, 2018 at 7:50 pm
Saravanan
April 13, 2018 at 11:02 pm
Saravanan
April 12, 2018 at 9:31 pm
Saravanan
April 11, 2018 at 12:40 am
Saravanan
April 10, 2018 at 11:29 pm
Saravanan
April 7, 2018 at 5:30 am
Saravanan
April 3, 2018 at 5:29 pm
SELECT
Saravanan
April 3, 2018 at 5:03 am
This is not working. It is telling me that From keyword not where expected.
select top...
Saravanan
March 29, 2018 at 9:17 am
Saravanan
March 28, 2018 at 10:18 pm
Saravanan
March 28, 2018 at 12:14 pm
Saravanan
March 28, 2018 at 11:50 am
Saravanan
March 22, 2018 at 1:49 am
Viewing 15 posts - 166 through 180 (of 211 total)