Forum Replies Created

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

  • 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...

  • RE: RPC_Out enabled or disabled?

    select name, is_rpc_out_enabled
    from sys.servers
    where is_linked = 1

    if is_linked = 0 that is the instance itself

  • RE: is it possible to create table on the fly while importing flat file? BIDS 2008.

    not with standard SSIS methods

    Depending on the file you can however use a C# script to parse the file and create the table yourself.
    With bulk insert (T-SQL)...

  • RE: Filtered non-clustered index showing filters for one person but not for another person

    I've seen this happen before - on 2008 R2.
    It was possible to generate the table and the index, but the filter definition would not be generated depending on the...

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