Forum Replies Created

Viewing 15 posts - 796 through 810 (of 4,085 total)

  • RE: Using SUM() In CASE Statement / Best Practices

    It's very difficult to troubleshoot performance problems without an execution plan (preferably the actual rather than estimated).  I did look at your query and see that you had a triangular...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 6, 2018 at 9:29 am

    #2012559

  • RE: Date Field Calculation Logic

    Jeff Moden - Monday, November 5, 2018 5:44 AM

    george_at_sql - Sunday, November 4, 2018 10:04 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 5, 2018 at 11:50 am

    #2012437

  • RE: Group By in a sub query

    solus - Monday, November 5, 2018 7:37 AM

    How would I be able to achieve the results I'm after ? This has had...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 5, 2018 at 7:56 am

    #2012397

  • RE: Group By in a sub query

    solus - Monday, November 5, 2018 3:18 AM

    I'm trying to use the GROUP BY clause in a sub query that's part of...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 5, 2018 at 7:32 am

    #2012391

  • RE: Validate multiple fields and return string with erroronous fields

    Jonathan AC Roberts - Thursday, November 1, 2018 1:36 PM

    drew.allen - Thursday, November 1, 2018 12:16 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 2, 2018 at 12:41 pm

    #2012261

  • RE: Validate multiple fields and return string with erroronous fields

    rjjh78 - Thursday, November 1, 2018 12:05 PM

    hello,  I want to validate multiple fields and create a string listing the fields that...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 1, 2018 at 12:16 pm

    #2012094

  • RE: Unique ID for address field

    laurie-789651 - Thursday, November 1, 2018 8:38 AM

    Try this:

    DROP TABLE #TEST

    CREATE TABLE #TEST ( Account Varchar(20), [Address] Varchar(50) )

    INSERT INTO...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 1, 2018 at 9:31 am

    #2012065

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Wednesday, October 31, 2018 1:30 PM

    This is a rant, too be honest.  Other than syntactical differences, what is different...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 31, 2018 at 2:08 pm

    #2011952

  • RE: Column data type - Msg 207 Invalid column name

    drew.allen - Wednesday, October 31, 2018 8:01 AM

    gjoelson 29755 - Tuesday, October 30, 2018 3:19 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 31, 2018 at 9:12 am

    #2011876

  • RE: Column data type - Msg 207 Invalid column name

    gjoelson 29755 - Tuesday, October 30, 2018 3:19 PM

    drew.allen - Tuesday, October 30, 2018 2:47 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 31, 2018 at 8:01 am

    #2011846

  • RE: File Encoding Conversion

    EMtwo - Tuesday, October 30, 2018 1:50 PM

    Does anyone have a script to convert a file with UTF-8 encoding to UNICODE? Any...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 30, 2018 at 3:16 pm

    #2011770

  • RE: T SQL Question sd.name ?

    ScottPletcher - Tuesday, October 30, 2018 2:24 PM

    FROM sys.databases sd LEFTJOIN sys.database_mirroring dbm

    As noted, a name, "sd", that follows immediately after a table name, "sys.databases", becomes an...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 30, 2018 at 3:11 pm

    #2011768

  • RE: Column data type - Msg 207 Invalid column name

    gjoelson 29755 - Tuesday, October 30, 2018 2:13 PM

    Lynn Pettis - Tuesday, October 30, 2018 1:27 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 30, 2018 at 2:47 pm

    #2011765

  • RE: Column data type - Msg 207 Invalid column name

    The error message is clear:  "Invalid column name...."  The error message also tells you which column name is invalid, but you didn't include that part in your post.  You need...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 30, 2018 at 11:50 am

    #2011737

  • RE: Today's Random Word!

    Jason A. Long - Tuesday, October 30, 2018 10:52 AM

    Ed Wagner - Tuesday, October 30, 2018 8:28...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 30, 2018 at 11:40 am

    #2011732

Viewing 15 posts - 796 through 810 (of 4,085 total)