Viewing 3 posts - 1 through 3 (of 3 total)
Hi,
This will solve you problem.
SELECT
ESPENSE_BY,
EXPENSE,
SUM(PRICE)
FROM
TABLE_NAME -----use table name
GROUP BY
ESPENSE_BY,EXPENSE
March 15, 2013 at 3:35 am
#1597400
use select case for this issue.
March 15, 2013 at 3:23 am
#1597393
your simple way of doing this is :-
select cast(month(GETDATE()) as varchar(2))+'/'+cast(day(GETDATE()) as varchar(2))+'/'+cast(year(GETDATE()) as varchar(4))
March 15, 2013 at 1:46 am
#1597371