Oracle To SQL Server SQL Conversion

Hi,

I've got a couple of snippets of code that I am not sure how to convert. Any thoughts?

Thanks,

Steve

====================================

Select
to_char(AM_VEST_YEAR0, 'FM999,999,999,999,990') ||'|'||
to_char(AM_VEST_YEAR1, 'FM999,999,999,999,990') ||'|'||
to_char(AM_VEST_YEAR2, 'FM999,999,999,999,990') ||'|'||
to_char(AM_VEST_YEAR3, 'FM999,999,999,999,990') ||'|'||
to_char(AM_VEST_YEAR4, 'FM999,999,999,999,990') ||'|'||
to_char(AM_VEST_YEAR5, 'FM999,999,999,999,990') as data_row


=====================================

from
VEST_SCHED,
(select to_date('31-DEC-'||to_char(to_number(to_char(sysdate, 'yyyy'))+1), 'dd-mon-yyyy') as max_date
from dual) b,
(select to_date('1-JAN-'||to_char(to_number(to_char(sysdate, 'yyyy'))+1), 'dd-mon-yyyy') as min_date
from dual) c
where
OPTS_CANC < '1' and
VEST_DT BETWEEN c.min_date AND b.max_date and
emplid = '[CURRENT_EMPLID]'
group by
emplid, GRANT_NUM