Forum Replies Created

Viewing 15 posts - 4,066 through 4,080 (of 14,953 total)

  • RE: Mathematical Theory (controversy!)

    toddasd (6/7/2011)


    Richard Warr (6/6/2011)


    toddasd (6/6/2011)


    Answer this: do you consider this to be true: 1/3 = 0.333...?

    No, however that is the only way you can represent 1/3 as a decimal.

    That's a...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Using SSIS for FTP and Email

    SSIS has a built-in FTP task operator. It won't work with SFTP ("Secure" FTP), but if it's vanilla FTP, it should be able to do what you need. ...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Career Change

    Talk to some tech recruiters in your area. BI is a HOT field to break into, but you'll be competing with people with a lot more technical experience at...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Multiple double quotes in a csv

    And, of course, it can have commas in the text too, can't it?

    I think I'd build a custom import engine for this. Any of the various .NET languages should...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Decimal with Leading Zero

    I was trying to be humorous, but apparently I missed. Sorry about that.

    If you absolutely have to have a string in a specific format, you'll want to define the...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

    Does this return more than one row in some/all cases?

    select NumericValue from ClientSettings where Setting like 'PushMaxCustomerRank'

    If so, you'll get that error message, because you really haven't told SQL Server...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Decimal with Leading Zero

    markanderson (6/7/2011)


    On sort of the same front, why is it when you define a field as decimal(6,6), which means that we only want data on the right side of the...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Duplicate

    patla4u (6/7/2011)


    I want my output based on acct_id

    But the account ID is the same (two records have 1, two records have 2).

    You have two rows with an account ID of...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (6/7/2011)


    GSquared (6/7/2011)


    GilaMonster (6/7/2011)


    Now I can look forward to working on fun, interesting, complex stuff (like automating an entire SQL environment from scratch, designing nasty-complex systems for forecasting) rather...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    GilaMonster (6/7/2011)


    Now I can look forward to working on fun, interesting, complex stuff (like automating an entire SQL environment from scratch, designing nasty-complex systems for forecasting) rather than producing lists...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: TSQL

    opc.three (6/7/2011)


    The real issue was the missing ?'s in your previous post.

    Now that I can easily believe! Won't be the first, nor the last, time that I missed those....

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Roy Ernest (6/7/2011)


    SQLRNNR (6/7/2011)


    Roy Ernest (6/7/2011)


    That was fun to watch. I still have some pics of the kilt on my phone.

    You gonna be wearing a kilt or something similar...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Mathematical Theory (controversy!)

    mtillman-921105 (6/7/2011)


    GSquared (6/7/2011)


    mtillman-921105 (6/6/2011)


    And you may be assuming too much if you think math and philosophy are separate subjects. Math is a language for expressing a subset of philosophy.

    Actually GSquared,...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Mathematical Theory (controversy!)

    Steve Jones - SSC Editor (6/7/2011)


    GSquared (6/7/2011)


    Steve, when you originally envisioned SSC, did you imagine it would end up having debates on the meaning of "philosophy" and the definitions of...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: TSQL

    opc.three (6/7/2011)


    Every iteration done inside the "for each" proc is done on an independent thread so you need to use a global temp table or a permanent table. Try it...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 15 posts - 4,066 through 4,080 (of 14,953 total)