Home Forums SQL Server 2008 Working with Oracle Convert date format in SQL sever report(BIDS) with Oracle date format RE: Convert date format in SQL sever report(BIDS) with Oracle date format

  • during the passed days, I tried many times. However it still doesn't work for me.

    The error message said: ORA-00900: invalid SQL statement

    It looks like I may not declare the variable or parameter right, or may not put them in the right place.

    Such as can I mix the SQL statement with all other inside the qurey build window or not?

    Thanks!