how to convert?

[Gebes-Menyut]

dear all,

I already download tsql2mysql and run it from windows command like this:

c:\tsql2mysql <a.sql> b.sql

the result is b.sql with 0 size. is that command is correct?

thanks,
Diwa

[Erik Wetterberg]

What does a.sql look like?

[Gebes-Menyut]

This is the sample of script that I'll convert to:

--- Begin ---
SET NOCOUNT ON
DECLARE @HASIL FLOAT0
DECLARE @HSLTMP1 FLOAT0, @HSLTMP2 FLOAT0, @HSLTMP3 FLOAT0, @HSLTMP4 FLOAT0, @HSLTMP5 FLOAT0
DECLARE @HSLTMP6 FLOAT0, @HSLTMP7 FLOAT0, @HSLTMP8 FLOAT0, @HSLTMP9 FLOAT0, @HSLTMP10 FLOAT0
DECLARE @HSLTMP11 FLOAT0, @HSLTMP12 FLOAT0, @HSLTMP13 FLOAT0, @HSLTMP14 FLOAT0, @HSLTMP15 FLOAT0
DECLARE @HSLTMP16 FLOAT0, @HSLTMP17 FLOAT0, @HSLTMP18 FLOAT0, @HSLTMP19 FLOAT0, @HSLTMP20 FLOAT0
DECLARE @TGL1 DATETIME, @TGL2 DATETIME

--DECLARE @BULANTAHUN VARCHAR06
--SELECT @BULANTAHUN='200503'

SELECT @HASIL=0
SELECT @HSLTMP1=0, @HSLTMP2=0, @HSLTMP3=0, @HSLTMP4=0, @HSLTMP5=0
SELECT @HSLTMP6=0, @HSLTMP7=0, @HSLTMP8=0, @HSLTMP9=0, @HSLTMP10=0
SELECT @HSLTMP11=0, @HSLTMP12=0, @HSLTMP13=0, @HSLTMP9=14, @HSLTMP15=0
SELECT @HSLTMP16=0, @HSLTMP17=0, @HSLTMP18=0, @HSLTMP19=14, @HSLTMP20=0

--Cari tanggal awal dan akhit periode berdasarkan bulantahun
SELECT @TGL1=FIRSTDATE, @TGL2=LASTDATE
FROM MSTPERIODE
WHERE BULANTAHUN=@BULANTAHUN

CREATE TABLE #HPPRpt(NOCOGS Varchar(5) null, AMOUNT1 Float null, AMOUNT2 Float NULL)
CREATE CLUSTERED INDEX AA ON #HPPRpt(NOCOGS)

--COGS(82)
INSERT INTO #HPPRpt(NOCOGS,AMOUNT1,AMOUNT2)
SELECT '82',SUM(FG_RPC), SUM(FG_RPC) FROM CA WHERE BULANTAHUN=@BULANTAHUN

--COGS(54)
INSERT INTO #HPPRpt(NOCOGS,AMOUNT1,AMOUNT2)
SELECT '54',
SUM(BAHAN+HALF+AFALAN+SUSUT+RAWAT+LISTRIK+STEAM+PAYROLL+OH_LAIN+OPNAME+COOKOIL+OV+BHN_RPC+HF_RPC+FG_RPC),
SUM(BAHAN+HALF+AFALAN+SUSUT+RAWAT+LISTRIK+STEAM+PAYROLL+OH_LAIN+OPNAME+COOKOIL+OV+BHN_RPC+HF_RPC+FG_RPC)
FROM CA
WHERE LEFT(ACC_NO,3) IN ('141','142','143') AND ITEM_NO NOT LIKE '%ABC%' AND BULANTAHUN=@BULANTAHUN

--- End ---

Is there any wrong code? This one of my stored procedure reside on MyDatabase.

Any help is appreciated.

thanks,
Diwa

[Erik Wetterberg]

This is not a stored procedure, there is no 'create procedure' statement, so it will not be converted.

Regards

Erik

[Jason Rudland]

I have the same problem. Here is my input sql:

CREATE procedure getdifference
as
begin
    DECLARE @Fiscal_id int
    DECLARE @start_date datetime

    SELECT     @Fiscal_id=FISCAL_ID,@start_date = START_DATE
    FROM     CEL_FA_FISCAL_YEAR
    WHERE    getdate() BETWEEN START_DATE AND END_DATE

    create table #tempTable
    (
        id int primary key identity,
        party_id bigint,
        reference_amount decimal(21,3),
        current_balance decimal(21,3)
    )
   
    insert into #tempTable (party_id, reference_amount)
    select     party_id, sum(referance_amount) as ref_amount
    from    cel_fa_partyageing
    group by party_id
   
    update #tempTable  set current_balance = (
        SELECT ISNULL(op.AMOUNT,0)+( isnull((SUM(ISNULL(TRANSD.DEBIT_AMOUNT,0))-SUM(ISNULL(TRANSD.CREDIT_AMOUNT,0))),0)) as total
        FROM     CEL_FA_OPENING_BALANCES op
        inner join CEL_FA_TRANS_D TRANSD on op.ACCOUNT_ID = transd.PARTY_ID
        INNER JOIN CEL_FA_TRANS_H FTH
            ON TRANSD.TRANSACTION_ID = FTH.TRANSACTION_ID AND FTH.POSTED = 1 AND FTH.CANCELED = 0 AND FTH.REVERTED = 0
       
        WHERE
        TRANSD.PARTY_TYPE = 'C'
        AND FTH.TRANS_DATE BETWEEN @start_date AND getdate()
        and #tempTable.party_id = op.account_id
        group by op.account_id,op.AMOUNT
        having ISNULL(op.AMOUNT,0)+( isnull((SUM(ISNULL(TRANSD.DEBIT_AMOUNT,0))-SUM(ISNULL(TRANSD.CREDIT_AMOUNT,0))),0)) <> 0
    )
   
    select party_id,isnull(reference_amount,0)as ref_amount,isnull(current_balance,0)as curr_bal,isnull(reference_amount,0) - isnull(current_balance,0)as diff from #tempTable
    where isnull(reference_amount,0) <> isnull(current_balance,0)

    drop table #tempTable

end

any ideas?

Thanks

Jason

[Erik Wetterberg]

Try adding a GO on a separate line at the end of the procedure.

Erik