Forum Replies Created

Viewing 15 posts - 331 through 345 (of 626 total)

  • RE: A Call for Articles

    jeffrey yao (4/25/2016)

    I would "shamelessly" (due to a bit of interest conflict as an SSC author before) suggest that SSC needs to greatly increase the payment for published articles. At...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 26, 2016 at 2:20 pm

    #1874797

  • RE: Are the posted questions getting worse?

    GilaMonster (4/26/2016)

    Rumor has it that Lucas was pretty disappointed by the direction as well.

    Considering how his vision of the prequels turned out, I'm kinda happy with his disappointment tbh.

    ^This

    Great visionary...Bad...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 26, 2016 at 11:54 am

    #1874737

  • RE: Are the posted questions getting worse?

    Speaking of Kylo throwing a tantrum...

    https://youtu.be/s74breoNAKc

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 26, 2016 at 11:29 am

    #1874713

  • RE: Are the posted questions getting worse?

    jeff.mason (4/26/2016)

    I just want to know more about Rey. For me the biggest triumph of the new movie was the painting of three solid new main characters that I...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 26, 2016 at 8:16 am

    #1874637

  • RE: Are the posted questions getting worse?

    BLOB_EATER (4/26/2016)

    Anybody know who / what that giant sith/alien lord was in the latest Star wars film? (Which I watched 2 nights ago whilst wearing my jabba the hut mask).

    Well...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 26, 2016 at 8:11 am

    #1874633

  • RE: Are the posted questions getting worse?

    It's interesting to see all the idioms from different languages that mean the same thing.

    Wish I could remember one from my native tongue but it's been almost lost on me...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 25, 2016 at 12:07 pm

    #1874332

  • RE: Default Value RAND issue

    An interesting method I've used before is to use NEWID() in ORDER BY.

    In this example I select the 6 winning numbers of the next lotto draw!

    WITH MyNumbers (n) AS

    (

    ...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 25, 2016 at 9:20 am

    #1874274

  • RE: How toGet column name with changing value in SQL-server

    saroj9958 (4/22/2016)

    HI all,

    I think I should be more clear on the question

    here is the situation

    EngineerPostalCodeFTEFieldWorkEfficiencyAllowCMDistrictNameAllowPMSCENARIOid

    100234BE0.01.01 District Wallony ...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 25, 2016 at 8:08 am

    #1874245

  • RE: How toGet column name with changing value in SQL-server

    Here is an example of the kind of stuff you can do if you with minimal changes to your existing table. I am by no means saying this is...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 21, 2016 at 1:52 pm

    #1873776

  • RE: How toGet column name with changing value in SQL-server

    saroj9958 (4/19/2016)

    No there is not any date-time column. only numerice value or string value is changing.:-)

    Well that appears to be a fundamental flaw with your design. How would you...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 19, 2016 at 7:36 am

    #1873064

  • RE: Unable to load DLL 'sqltoolsnativehelpers.dll': This program is blocked by Group Policy.

    This doesn't seem like an SQL issue, sounds like you have some sort of Software Restriction Policy in place. You'll likely have to contact whomever is responsible for GPO's...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 18, 2016 at 7:57 am

    #1872761

  • RE: SQL Help Please

    jsalzm1 (4/18/2016)

    Thanks guys, I and a few classmates figured it out.

    Luis, you don't need to be so rude. I actually have a great job lined up and I am...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 18, 2016 at 7:44 am

    #1872751

  • RE: How toGet column name with changing value in SQL-server

    saroj9958 (4/15/2016)

    Hi Drew,

    In my table approx 53 column is there I need to find out the trend value is changing where, So the main problame is I need the name...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 18, 2016 at 7:37 am

    #1872748

  • RE: How toGet column name with changing value in SQL-server

    As Drew mentioned this is generally not a good idea. If you tell us what problem you are really trying to solve we might be able to suggest an...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 15, 2016 at 8:01 am

    #1872360

  • RE: Help with PIVOT

    Luis Cazares (4/11/2016)

    yb751 (4/11/2016)

    Pretty cool technique I learnt from Luis. 😉

    You just made my day 🙂

    I learned this concatenation method from Wayne Sheffield, which he explains it in here: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    And...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    April 11, 2016 at 9:21 am

    #1871178

Viewing 15 posts - 331 through 345 (of 626 total)