converting oracle script to SQL server 2005 script

[iitt2007]

Hi I am newbie. I need to translate the following Oracle script to SQL Server 2005 script.

I will appreciate your help and feedback.
Thanks a lot in advance.

-----------------------------------------------------------------------------------------------------------
test_reporting/here4fun@test_P ROD
SET NEWPAGE NONE;
SET SPACE 0;
SET LINESIZE 181;
SET PAGESIZE 0;
SET ECHO OFF;
SET FEEDBACK OFF;
SET HEADING OFF;
SET UNDERLINE OFF;
SET FLUSH OFF;
SET MARKUP HTML OFF;
COLUMN AGT_CD NOPRINT;
COLUMN PROC_DT NOPRINT;
SPOOL OFF;
SET COLSEP ',';
spool d:\test.txt;
select chr(34)||'Produ cer'||chr(34)|| ','||
chr(34)||'Commi ssion Type'||chr(34)| |','||
chr(34)||'Adjus tment Type'||chr(34)| |','||
chr(34)||'Proce ss Date'||chr(34)| |','||
chr(34)||'Divis ion'||chr(34)|| ','||
chr(34)||'Line of Business'||chr( 34)||','||
chr(34)||'Polic y Number'||chr(34 )||','||
chr(34)||'Produ cer Share'||chr(34) ||','||
chr(34)||'NAFYC '||chr(34)||',' ||
chr(34)||'Plan Code'||chr(34)| |','||
chr(34)||'Polic y Branch'||chr(34 )||','||
chr(34)||'Produ ct'||chr(34) ||','||
chr(34)||'Gen Date'||chr(34) "A",
'00000' "AGT_CD",
'0000/00/00' "PROC_DT"
from dual
union all
SELECT trim(chr(34)||A AC_AGT_CD||chr( 34))||','||
trim(chr(34)||A AC_COMM_TYPE||c hr(34))||','||
trim(chr(34)||A AC_ADJ_TYPE||ch r(34))||','||
trim(chr(34)||t o_char(AAC_PROC _DT,'RRRR/MM/DD')||chr(34))| |','||
trim(chr(34)||A AC_FASAT_DIVISI ON||chr(34))||' ,'||
trim(chr(34)||A AC_FASAT_LOB||c hr(34))||','||
trim(chr(34)||A AC_POL||chr(34) )||','||
trim(to_char(AA C_SHARE,'999999 990.99'))||','| |
trim(to_char(AA C_WEIGHTED_AFYC ,'999999990.99' ))||','||
trim(chr(34)||A AC_PLAN_CD||chr (34))||','||
trim(chr(34)||A AC_BRCH_CD||chr (34))||','||
trim(chr(34)||A AC_FASAT_PRODUC T||chr(34))||', '||
trim(chr(34)||t o_char(AAC_GEN_ DT,'RRRR/MM/DD')||chr(34))" A",
AAC_AGT_CD "AGT_CD",
to_char(AAC_PRO C_DT,'RRRR/MM/DD') "PROC_DT"
FROM
Database.VTABLE
WHERE
(
(AAC_COMM_TYPE = 'FYC'
OR AAC_ADJ_TYPE IN ('FAC01', 'FAC02', 'FAC04', 'FAC09', 'FAC10', 'FAC35', 'FAC38', 'FAC59', 'FAC60'))
AND AAC_FASAT_DIVIS ION IN ('I', 'G')
AND AAC_WEIGHTED_AF YC != 0
AND ( ( AAC_PROC_DT ) > (to_date(Concat ((to_number(to_ char(sysdate,'Y YYY')) - 1),'-12-31'),'YYYY/mm/dd')) )
)
ORDER BY AGT_CD, PROC_DT;
spool off;
exit;