Forum Replies Created

Viewing 15 posts - 3,751 through 3,765 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/23/2015)

    Hey, guys, we have a language conversion question over here. Can anyone assist with this?

    I'm sure this is just a typical PEBKAC. 😀

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 23, 2015 at 6:47 am

    #1841692

  • RE: Get count of last consecutive rows with 0 value

    I wouldn't actually use a join.

    Instead just use a condition to get values after the last non zero value. In order to do that, you need to figure how...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 23, 2015 at 6:45 am

    #1841691

  • RE: Convert UTF 8 text to NVARCHAR in SQL Server

    I'm not sure what's the problem. SQL Server will handle unicode characters just fine.

    --Do a direct select

    SELECT N'????'

    --Using a table

    CREATE TABLE #HindiText( myString nvarchar(10));

    --Insert into...Select

    INSERT INTO #HindiText SELECT N'????';

    SELECT *...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 23, 2015 at 6:31 am

    #1841683

  • RE: Help with a case statement

    You're comparing the same value (Dyn_Assessments.field_name) twice and expecting it to have different values, which won't happen because it compares row by row.

    I'm not sure about the rules to work...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2015 at 2:15 pm

    #1841464

  • RE: Pieces of SQL code stored in table

    It's popular when there's no DBA that can bring people to reason. Other than that, it's hard to see something so convoluted.

    I remember a horror story about an implementation...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2015 at 1:54 pm

    #1841459

  • RE: Calculating student age as of one of two reference dates

    I'm not sure if I should have read all the replies before, but this seems like a good option. I started by using a CASE for each column, but this...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2015 at 12:26 pm

    #1841437

  • RE: Query to find Median isn't working with duplicates?

    Can you post DDL and sample data that we can actually use? Your solutions use 3 columns and you only showed one.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2015 at 11:03 am

    #1841418

  • RE: Partition Table vs Archive Performance Considerations

    Partitioning tables is a great tool to manage the archiving process for large tables. However, this is something that has to be well planned and consider all the needs and...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2015 at 7:52 am

    #1841369

  • RE: Today's Random Word!

    anthony.green (11/20/2015)

    Ed Wagner (11/20/2015)

    anthony.green (11/20/2015)

    djj (11/20/2015)

    anthony.green (11/20/2015)

    djj (11/20/2015)

    Shooting

    Range

    Rover

    curiosity

    Learning

    Improvement

    Home

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2015 at 7:41 am

    #1841363

  • RE: Committing Work

    It actually should work with previous versions as well. Documentation for SQL Server 2000 includes it, but I couldn't test on anything older than 2008R2.

    https://technet.microsoft.com/en-us/library/aa258231(v=sql.80).aspx

    It's weird that this is so...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 20, 2015 at 7:39 am

    #1841360

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (11/19/2015)

    Luis Cazares (11/19/2015)

    I feel excluded.

    How come?

    😎

    You left my method out

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 19, 2015 at 2:35 pm

    #1841182

  • RE: Are the posted questions getting worse?

    I feel excluded.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 19, 2015 at 1:52 pm

    #1841169

  • RE: Case Statement Subquery to Set a bit value

    You missed the relationship between the inner and the outer query.

    select Item

    ,(Case

    When Exists(SELECT t.Item

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 19, 2015 at 1:01 pm

    #1841155

  • RE: Update, Insert and Delete slowly changing table

    I believe that you need to give us more detail. Why is it being slow? Is it the query to generate the source data? Or just writing the table to...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 19, 2015 at 12:54 pm

    #1841154

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/19/2015)

    Bah. I thought I was being clever, but I have an error I can't find.

    I made the code work by adding 4 characters in different parts of the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 19, 2015 at 12:24 pm

    #1841141

Viewing 15 posts - 3,751 through 3,765 (of 8,731 total)