Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 15,381 total)

  • RE: Using Stuff

    Luis Cazares (9/9/2015)

    Do you realize that the STUFF function is not the one concatenating the rows? The stuff function is only replacing the first character (a comma) with an empty...

    September 9, 2015 at 12:57 pm

    #1825518

  • RE: Using Stuff

    sharonsql2013 (9/9/2015)

    I want to see output as

    Excel Dave,Ken 15

    Help me here. Is this one column? You need to put a little effort into this.

    September 9, 2015 at 12:49 pm

    #1825513

  • RE: Using Stuff

    sharonsql2013 (9/9/2015)

    I am trying to get the 3 rows in the below in one line. with all 3 names separated by ","

    create table #Product

    (

    Application Varchar(50),

    ...

    September 9, 2015 at 12:40 pm

    #1825511

  • RE: Order of preference in a case statement

    cory.bullard76 (9/9/2015)

    Sean, I'm getting an invalid column error on 'GrantColumn' and 'PartDColumn'

    Ummm....that would be because I have no clue what columns value you want. I have no idea what your...

    September 9, 2015 at 12:18 pm

    #1825506

  • RE: Order of preference in a case statement

    cory.bullard76 (9/9/2015)

    Wouldn't your case statement error out do the columns in the Then portion containing columns that don't exist?

    HUH??? How can columns not exist for some rows? I will ask...

    September 9, 2015 at 10:57 am

    #1825481

  • RE: Get the Identity Column value when the update statement fails.

    biscribbler (9/9/2015)

    My current proc updates(updates using joins of two or three tables) millions of records as per the condition provided for each department.

    However, when the proc fails it writes to...

    September 9, 2015 at 10:45 am

    #1825475

  • RE: Order of preference in a case statement

    cory.bullard76 (9/9/2015)

    Sean, I want the data in a single column

    IT IS in a single column. That is what the case expression is used for. Look at the code I posted,...

    September 9, 2015 at 10:43 am

    #1825474

  • RE: session hang and resource issues(CPU/memory wait) when trying to do a big work load

    Grant Fritchey (9/9/2015)

    Fair warning though, a shocking number of vendors are really horrible at SQL Server.

    Gosh Grant the way you say that makes me think you have the opinion that...

    September 9, 2015 at 10:34 am

    #1825471

  • RE: Order of preference in a case statement

    cory.bullard76 (9/9/2015)

    I'm not explaining it clear enough. I want it to populate the same column. If it's Commercial give me that BINNO.....if the patient doesn't have Commercial....populate that...

    September 9, 2015 at 10:32 am

    #1825470

  • RE: TRUNCATED Column value at MS SQL 2008

    subscriptionemail (9/9/2015)

    😀 yes, I have realized that it is really ridiculous, and a customer will not give a lot of time to read everything at the column 😉 ...

    September 9, 2015 at 10:31 am

    #1825469

  • RE: TRUNCATED Column value at MS SQL 2008

    subscriptionemail (9/9/2015)

    Hi,

    Is there a way to adjust the value for that?

    Let's say I need to increase it up to 100,000?

    Thanks a lot.

    No you can't set it to 100,000 in...

    September 9, 2015 at 10:01 am

    #1825457

  • RE: Order of preference in a case statement

    cory.bullard76 (9/9/2015)

    Thanks...That's what I thought at 1st. But, it's pulling the BINNO for Grant instead of Commercial when I use that. I want Commercial 1st if they have...

    September 9, 2015 at 9:59 am

    #1825454

  • RE: session hang and resource issues(CPU/memory wait) when trying to do a big work load

    ying.wang (9/9/2015)

    Hello,

    we have gotten feedback from application vendor saying that it is not a application bug but it is depened on the server capacity and different environment. Some copmanies can...

    September 9, 2015 at 9:57 am

    #1825453

  • RE: Error with application side

    Aatish Patel (9/9/2015)

    thanks all. have tried all and still looking around to resolve this. If any more info please let me know

    We can't provide you any more info. We both...

    September 9, 2015 at 9:55 am

    #1825452

  • RE: Error with application side

    Aatish Patel (9/9/2015)

    Hi,

    thanks for looking into this. so by: There is likely a deny connect permission for that user.... do you mean need to look into active directory for...

    September 9, 2015 at 9:52 am

    #1825450

Viewing 15 posts - 2,356 through 2,370 (of 15,381 total)