Forum Replies Created

Viewing 15 posts - 3,991 through 4,005 (of 7,484 total)

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (10/26/2012)


    WayneS (10/25/2012)


    Anyone still alive out here? 3 days with no comments... that has to be a record for The Thread.

    Some malware has reduced my time for looking...

  • RE: Linked Server shows table but does not retrieve data

    naqib_bs (10/27/2012)


    3. this is the version:

    Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise...

  • RE: timestamp

    harri.reddy (10/27/2012)


    thanks for clarification, what i need is once is get data from file, i need to store what date and time it came

    in my sql server table.

    do i need...

  • RE: What are reading now?

    I tend to have several books going at one.

    Currently reading:

    Historias de Cronopios y de Famas (mainly the stories in it that I didn't read before; it's quite...

  • RE: Are the posted questions getting worse?

    SQLRNNR (10/26/2012)


    Brandie Tarvin (10/26/2012)


    We're all DBAs. Aren't we supposed to love Full Text Search?

    @=)

    um sure

    it's a love/hate relationship right?

    maybe more of a hate/abhorrence relationship, perhaps?

  • RE: Are the posted questions getting worse?

    WayneS (10/25/2012)


    Anyone still alive out here? 3 days with no comments... that has to be a record for The Thread.

    Some malware has reduced my time for looking at the thread...

  • RE: SELECT (Transact-SQL)

    Nice clean question.

    But maybe a little too easy. If one assumes that T-SQL has the sort of consistent syntax that most programming languages have, then only the second and...

  • RE: PARSENAME

    Revenant (10/25/2012)


    Thanks for a nice question. BTW, reversal of the order is a frequent pitfall for people who are parsing IPs and do not read the doc carefully enough.

    Yes, it...

  • RE: Five percent rounded down

    mhtanner (10/24/2012)


    For the record, a rewording of the required algorithm is 'give one free for every 'whole lot' of 20 they have'.

    In the meanwhile, I have re-coded it to to...

  • RE: Five percent rounded down

    palotaiarpad (10/24/2012)


    My problem is, that the first expression evaluates to 105, and if i cast the 105 to int it should remain 105 and not less.

    No, it doesn't evaluate to...

  • RE: Five percent rounded down

    Nice question.

    The trick of adding 0.000000001 to the multiplicand might work sometimes, but it isn't the best way to handle this.

    Until someone introduces proper modern floating point into SQL (which...

  • RE: Duplicate Foreign Key

    Nice amusing question.

    The number isn't actually unlimited, though - the constraint metadata takes up space in filestore, and the limit on filestore for SQLServer is something less than 17.2 billion...

  • RE: While loop

    Toreador (10/23/2012)


    honza.mf (10/12/2012)


    Right. Who cares?

    The bank of course, so they have transactions properly implemented (we must hope).

    In the UK at least, such processes work entirely in the bank's favour. Transaction...

  • RE: A Software Warranty

    roger.plowman (10/22/2012)


    1) They're too busy to beta test software.

    2) They're not too busy to call and complain.

    3) They don't remember you have to sleep.

    4) 18/7/365 on call sucks unless...

  • RE: Changing Identity Columns

    crussell-931424 (10/22/2012)


    The effective result is different for a table that has had records from a table that has never had any records. Don't know why. It just is.

    Not quite -...

Viewing 15 posts - 3,991 through 4,005 (of 7,484 total)