Forum Replies Created

Viewing 15 posts - 6,961 through 6,975 (of 8,755 total)

  • RE: Query to split difference (number of nights) between 2 dates into respective "Month" column

    Lynn Pettis (9/23/2014)

    Eirikur Eiriksson (9/23/2014)

    Try this for a size

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    ;WITH SAMPLE_DATA ([ID number],DateOfArrival,DateOfDeparture)

    AS (SELECT * FROM (VALUES

    (2031,'2014-03-20','2014-03-26')

    ,(1056,'2014-04-29','2014-05-03')

    ...

    September 24, 2014 at 11:58 am

    #1747939

  • RE: SQL SERVER Comma Separated values XML PATH

    Firstly, Using 8K limited functions will of course truncate larger values, does your production data exceed that limit? Secondly, please comply to Chris's request on DDL, sample and output.

    😎

    September 24, 2014 at 11:54 am

    #1747938

  • RE: Error creating diagrams in management studio ( sqòl server 2012)

    graziano.montagna (9/23/2014)

    Solution failed.

    Now I installed a new istance and the error is the same

    only a variation "SQLEditors" is the last word

    Quick question, do you have the option of...

    September 24, 2014 at 11:46 am

    #1747935

  • RE: Geometric Median / Weiszfeld's algorithm

    Quick question, how accurate does this have to be? The reason for asking is that one can do a good approximation using the spatial data type methods and functions, happy...

    September 24, 2014 at 11:39 am

    #1747933

  • RE: Seems like my SQL database is corrupted

    Quick suggestion, gracefully power down the system, reboot using a good recovery distro such as backtrack, gparted etc., DON'T mount the drives but use dd_rescue to image the drive or...

    September 24, 2014 at 11:32 am

    #1747932

  • RE: Import access database

    sistemas_casinomnes (9/24/2014)

    Hello, I need to create a job that import an access database.

    Does exist a command that I can use to do that?

    Thanks

    Viky

    Quick thought, I've found that using the import/export...

    September 24, 2014 at 11:22 am

    #1747927

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    stefan.mulder (9/24/2014)

    Great stuff!

    but as to Jeff's notes on collation: we do need a function that can handle compound delimiters, e.g. [|;] or [","] as in David Data's case of...

    September 24, 2014 at 11:12 am

    #1747922

  • RE: Supported spatial data formats

    OCTom (9/24/2014)

    What is a Lorry?

    Tom

    A Lorry be a wagon that can carry lots o' gold and precious

    😎

    September 24, 2014 at 11:10 am

    #1747921

  • RE: Supported spatial data formats

    Rune Bivrin (9/24/2014)

    I'm currently hiring. I'd like to know which 9% selected the CHTM option:hehe:

    You will have no joy thar, they be already walkin' t' plank

    September 24, 2014 at 11:07 am

    #1747920

  • RE: Supported spatial data formats

    Louis Hillebrand (9/24/2014)

    I need to import from CHTM data format, any suggestions? 😉

    You must take it t' t' witchcraft Island, thar be an old beauty thar which has t' power...

    September 24, 2014 at 11:05 am

    #1747918

  • RE: Supported spatial data formats

    Vimal Lohani (9/23/2014)

    uff, what a question, so concentration required.

    my (70-461) preparation, helped me to solve this.

    Aim for t' main sail, and go for t' treaaye map, then it be easy

    😎

    September 24, 2014 at 11:03 am

    #1747916

  • RE: Supported spatial data formats

    Hany Helmy (9/23/2014)

    I read the first 2 options, then decided to google it as I have no idea, no previous experience on this, found nothing useful, then went back, read...

    September 24, 2014 at 11:01 am

    #1747914

  • RE: Supported spatial data formats

    sestell1 (9/24/2014)

    Arrrrr.... it be a shame ta not be postin' this question on September 19!

    Me aim was set on that glorious day, sadly yet anothar broadside missed.

    😎

    September 24, 2014 at 10:58 am

    #1747913

  • RE: Supported spatial data formats

    TomThomson (9/24/2014)

    Given the 6th option, it is extremely obvious what the correct answer is - so thanks for the effortless points.

    However I was a little suspiciious about the no transformation...

    September 24, 2014 at 10:54 am

    #1747911

  • RE: t-sql 2012 give column name and format date field

    Try this out for a size. Note, the statement you have doesn't do any formatting, in literal terms it means "convert into smalldatetime from a source that has 101 format.

    😎

    USE...

    September 24, 2014 at 10:13 am

    #1747896

Viewing 15 posts - 6,961 through 6,975 (of 8,755 total)