Forum Replies Created

Viewing 15 posts - 3,151 through 3,165 (of 5,393 total)

  • RE: Getting dates from SQL into Excel in float format

    OK, I think you have to rethink your strategy a bit.

    You have a date column in Excel and you want it to be filled with a date from SQL Server,...

    -- Gianluca Sartori

  • RE: Are the posted questions getting worse?

    GSquared (5/27/2011)


    jcrawf02 (5/27/2011)


    GSquared (5/27/2011)


    Gianluca Sartori (5/26/2011)


    jcrawf02 (5/26/2011)


    Gianluca Sartori (5/26/2011)


    jcrawf02 (5/26/2011)


    Wow, you thought that there were too many other DBAs that were better suited than Brandie? That's not very nice...

    😛

    Funny, but...

    -- Gianluca Sartori

  • RE: Are the posted questions getting worse?

    Roy Ernest (5/27/2011)


    If someone feels insulted by this statement, Sorry. I am an Indian as well and I dont get insulted.

    Ugh! I forgot to add this disclaimer for the Italians....

    -- Gianluca Sartori

  • RE: Getting dates from SQL into Excel in float format

    Dates in SQL Server are stored as float: the integer part represents the date, the fractional part represents the time.

    You could try to cast it as float in the...

    -- Gianluca Sartori

  • RE: Getting dates from SQL into Excel in float format

    Removed. I was wrong.

    Sorry.

    -- Gianluca Sartori

  • RE: Multiple Tables

    It's quite a vague requirement. Can you post:

    1. Table definition (create table sql script)

    2. Sample data (insert into ... values)

    3. Desired output

    Without this information I can only give a vague...

    -- Gianluca Sartori

  • RE: Are the posted questions getting worse?

    Thanks. I will need tons of luck.

    -- Gianluca Sartori

  • RE: Are the posted questions getting worse?

    SQLRNNR (5/26/2011)


    Gianluca Sartori (5/25/2011)


    No way, the Summit is too far and too expensive for me.

    Especially now that I'm moving into freelance consulting.

    Somehow I missed this post yesterday but wondered if...

    -- Gianluca Sartori

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (5/26/2011)


    Gotta love a query that, when executed, complains about a non-existent table but then, when you look at your code, you're not even calling this non-existent table.

    I'm not...

    -- Gianluca Sartori

  • RE: Are the posted questions getting worse?

    David Burrows (5/26/2011)


    jcrawf02 (5/26/2011)


    Actually, your English is better than most of the English-speaking folks, myself included. I should try responding in Italian...

    Io non sarei schizzando senza senso

    😀

    :hehe:

    -- Gianluca Sartori

  • RE: Are the posted questions getting worse?

    jcrawf02 (5/26/2011)


    Gianluca Sartori (5/26/2011)


    jcrawf02 (5/26/2011)


    Wow, you thought that there were too many other DBAs that were better suited than Brandie? That's not very nice...

    😛

    Funny, but you know this is not...

    -- Gianluca Sartori

  • RE: Are the posted questions getting worse?

    jcrawf02 (5/26/2011)


    Wow, you thought that there were too many other DBAs that were better suited than Brandie? That's not very nice...

    😛

    Funny, but you know this is not what I meant....

    -- Gianluca Sartori

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (5/26/2011)


    GilaMonster (5/26/2011)


    Roy Ernest (5/26/2011)


    I have an idea for one of persons who want to go to SQL Pass summit for free (Except air travel). Make list here who...

    -- Gianluca Sartori

  • RE: Does anybody know the list of execution plans which include FULL-TABLE SCAN

    FULL table scan is Oracle terminology.

    In SQL Server you just have "Table Scan", period.

    -- Gianluca Sartori

  • RE: IN Statement multivalue

    I suppose this is a stored procedure, isn't it?

    Then you expect some kind of parameter. If it is a single char parameter, you will have to split it on commas...

    -- Gianluca Sartori

Viewing 15 posts - 3,151 through 3,165 (of 5,393 total)