Forum Replies Created

Viewing 10 posts - 31 through 40 (of 40 total)

  • RE: Date error

    GilaMonster (12/29/2010)

    Oracle or SQL Server backend for the report? Your earlier post (http://www.sqlservercentral.com/Forums/Topic1040466-392-1.aspx) was for Oracle.

    It's Oracle. Thanks for your response.

    December 29, 2010 at 2:11 pm

    #1267430

  • RE: Distinct order by

    I got it right its working. Thank you.

    December 29, 2010 at 1:17 pm

    #1267409

  • RE: Date type.

    CREATE TABLE SUBS_TAG

    (

    ACCOUNT NUMBER(12) ...

    December 29, 2010 at 11:21 am

    #1267331

  • RE: Insert into syntax

    andrewd.smith (12/23/2010)

    Sorry. - I just noticed that this is the Access forum. My comment above assumed it was for SQL Server. However, what I said should hopefully be relevant to...

    December 23, 2010 at 1:10 pm

    #1266050

  • RE: Insert into syntax

    andrewd.smith (12/23/2010)

    Don't take those square brackets in the formal syntax description of INSERT in Books Online too literally, but if you insist on using table and column names with spaces...

    December 23, 2010 at 12:05 pm

    #1266037

  • RE: simple Query error

    LutzM (12/22/2010)

    Instead of using SELECT * you'd need to specify each column and use alias column names for the duplicates (like a.ACCOUNT, b.ACCOUNT, a.COD, c.CODE and maybe some more columns).

    The...

    December 22, 2010 at 2:54 pm

    #1265716

  • RE: if else error

    I used DECODE instead of CASE. It's exactly same iif in T-sql.

    Forget to tell you, i have been doing this in Oracle.

    December 21, 2010 at 12:53 pm

    #1265245

  • RE: if else error

    Thank you both guys. That was a silly mistake isn't it.

    December 21, 2010 at 12:15 pm

    #1265226

  • RE: Last run date

    Gianluca Sartori (12/21/2010)

    Last run date is by definition the date the report runs, AKA GETDATE().

    Last run date is when the report was run lastly. Suppose if yesterday i opened the...

    December 21, 2010 at 11:56 am

    #1265216

  • RE: Column split

    Thank you.

    December 21, 2010 at 11:04 am

    #1265204

Viewing 10 posts - 31 through 40 (of 40 total)