Forum Replies Created

Viewing 15 posts - 2,161 through 2,175 (of 2,651 total)

  • RE: Looking for a SQL Statement to populate the TOTAL row in this SQL Server table

    easier does not mean better or correct.

    And as the output is being loaded by a COBOL program what is the exact layout it needs?

    fixed length file?

  • RE: Looking for a SQL Statement to populate the TOTAL row in this SQL Server table

    and most important where is the code you surely have already tried to do to address your requirements.
    As well as the rules and the desired output.

    And that...

  • RE: Looking for a SQL Statement to populate the TOTAL row in this SQL Server table

    you still didn't understand the main issue.

    Most people will not download a file that can contain anything at all.

    DDL and SQL unless extremely big (10K lines...

  • RE: Internal Controls

    In my current (and some of the previous) company we definitely have audit controls.
    Not in all systems (yet) but at least on the core ones.
    so every time someone...

  • RE: Julian Date

    similar results for me 

    As the results I had given before only related to the date part I've also run your code with just the date bit.
    and also...

  • RE: Julian Date

    irehman - Saturday, November 10, 2018 12:46 PM

    frederico_fonseca - Saturday, November 10, 2018 12:37 PM

  • RE: Julian Date

    frederico_fonseca - Saturday, November 10, 2018 12:31 PM

    irehman - Saturday, November 10, 2018 12:19 PM

  • RE: Julian Date

    Jeff Moden - Saturday, November 10, 2018 11:30 AM

    Thanks, Frederico.  Time for some play.

    just in case having a single value was an...

  • RE: Julian Date

    irehman - Saturday, November 10, 2018 12:19 PM

    frederico_fonseca - Saturday, November 10, 2018 9:31 AM

  • RE: Julian Date

    Jeff Moden - Saturday, November 10, 2018 10:48 AM

    Can we see the code you used to generate the test data?  My concern...

  • RE: Julian Date

    Jeff Moden - Saturday, November 10, 2018 9:53 AM

    Cool.  The only thing is that I try to avoid trips through...

  • RE: Julian Date

    one other option (and there are more)

    declare @tbl table
      ( juldate decimal(18, 0)
      , timei float
      )
    insert into @tbl select 118063, 11456
    insert...

  • RE: Are the posted questions getting worse?

    Jeff Moden - Saturday, November 10, 2018 7:05 AM

    Lynn Pettis - Friday, November 9, 2018 3:19...

  • RE: Column names on INNER JOINS

    Error looks quite clear. 
    ----------
    Could not use view or function 'InvoiceTotals' because of binding errors.
    ----------

    one of your view is invalid because the underlying objects changed ...

  • RE: RPC_Out enabled or disabled?

    not quite
    is_linked = 0 - reports the instance settings
    is_linked = 1 - reports the specific linked server settings

    Having the instance rpc_out enabled does not enable it...

Viewing 15 posts - 2,161 through 2,175 (of 2,651 total)