Forum Replies Created

Viewing 15 posts - 46 through 60 (of 167 total)

  • RE: Live Long and Prosper

    Thanks for starting this thread.

    I was in high school when this show was in prime time and Mr Spock was who I wanted to be (besides Jim Hendrix, Carlos Santana,...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (2/26/2015) John Hurt - terrific and terrifying performance as dinky alien's first baby meal.

    Check out John Hurt as Caligula in the series I, Claudius. That's where I...

  • RE: Small Leadership

    You can lead and influence just by being competent and approachable.

  • RE: Total space used per table

    Thank you 🙂

  • RE: Bandwidth usage control

    I know it’s been driving you all nuts so I’m posting what I believe to be the cause of this issue for the sake and benefit of humanity.

    I’ll...

  • RE: Outpacing Change

    Is there some kind of irony at work here? The subject being that lawmakers don’t understand technology well enough to deal with the problems it brings and the dearth...

  • RE: Starting a New Job

    Things I learned to do when I’m new on the job from a non-technical perspective:

    •Shut up, listen, and try to ascertain the culture. Paying attention to what is considered...

  • RE: What is the "same query"?

    This is an excellent question. Simple example that teaches a very important point.

  • RE: Interrupt Me, I'm Stagnating

    Everything is easier to deal with when you know it is your own choice.

    +1000

    Develop your skills when you can. Don't wait until you have to.

    It's also nice...

  • RE: Why “3653.0 and 36524.0”?

    Slight omission on my part. I said "4 character number" to imply that it must be a character type and not a numeric. If you give a an actual 4...

  • RE: Why “3653.0 and 36524.0”?

    The code exploits what many consider to be a "fault" of the date/time data-types. If you present the functions with a 4 character number, T-SQL will treat it as a...

  • RE: Why “3653.0 and 36524.0”?

    Quick joke, 36524 is the number of versions Jeff needs to upgrade on his old test box

    Hopefully he'll see this

  • RE: Why “3653.0 and 36524.0”?

    SELECT CAST(0 AS DATETIME)

    Will give you 1/1/1900, the RAND(CHECKSUM(NEWID()))*3653.0 basically give you a 10 year date range from that so between1/1/1900 and 1/2/1910, then adding 36524 adds 100 years to...

  • RE: Please vote for the "built in Tally Table" function.

    I didn't put anything in this thread until today but I "voted" for this about two weeks ago..

    God, I love Tally tables....

  • RE: PIVOT

    Luis Cazares (8/25/2014)


    jshahan (8/25/2014)


    sestell1 (8/25/2014)


    Does anyone actually use the PIVOT operator?

    I find it so limited that I almost always roll my own using GROUP BY and CASE.

    I like PIVOT because...

Viewing 15 posts - 46 through 60 (of 167 total)