Forum Replies Created

Viewing 15 posts - 406 through 420 (of 5,590 total)

  • RE: Store long values to be used in "IN" statement in separate table?

    kwashington (7/14/2015)

    I have several reports that are looking for a code within a certain set of codes or ranges. The specific list of codes to be including is...

    July 14, 2015 at 9:11 am

    #1812358

  • RE: Help with query logic

    cory.bullard76 (7/14/2015)

    I'm writing a query and in this query I want it to pull patients that must have one specific insurance, but list any insurance they have....not just the one...

    July 14, 2015 at 9:08 am

    #1812355

  • RE: Are the posted questions getting worse?

    Jeff Moden (7/14/2015)

    Lynn Pettis (7/13/2015)

    OMG! How does Silver Spoon keep his job? Member of ssc for over 10 years and can't seem to do the simplest tasks without running...

    July 14, 2015 at 9:03 am

    #1812350

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/14/2015)

    I know that an OP posted a question with the following error:

    Cannot create a row of size 8071 which is greater than the allowable maximum row size of...

    July 14, 2015 at 9:02 am

    #1812349

  • RE: Syntax Error IS NULL

    Welsh Corgi (7/13/2015)

    I can copy and paste but not the whole line when I try and scroll.

    Could you please place the code outside of the CQL Code Tag?

    Thanks.:-)

    It might be...

    July 14, 2015 at 8:51 am

    #1812342

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/14/2015)

    Steve Jones - SSC Editor (7/13/2015)

    Brandie Tarvin (7/11/2015)

    Kind of irked this morning. Found out this morning that the SQL Saturday call for speakers in Orlando closed after only...

    July 14, 2015 at 8:48 am

    #1812341

  • RE: "Reuse" parameters in SQL query

    mattsynco (7/12/2015)

    Im writing a query and I have to use "?" as parameters. "?" will represent two things. StartDate parameter and an EndDate parameter. I know they go in order...

    July 13, 2015 at 8:24 am

    #1811996

  • RE: Syntax Error IS NULL

    Welsh Corgi (7/13/2015)

    What is wrong with the following Statement?

    update #tmpTotals set StateCount = (Select ISNULL Sum(DayCount),0) from #tmpTotals t where Loss_state = #tmpTotals.Loss_State )

    You're missing the "(" after ISNULL

    July 13, 2015 at 8:05 am

    #1811984

  • RE: Are the posted questions getting worse?

    GilaMonster (7/13/2015)

    Yes, yes, yes, yes!!!!!!!!

    Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony

    Awesome Gail. Congratulations.

    What's your next step?

    July 13, 2015 at 5:15 am

    #1811916

  • RE: Get Prior Max of Quantity

    What version of SQL does this need to work for? (You're posting in a SQL 2005 forum... is this correct?)

    July 10, 2015 at 4:30 pm

    #1811783

  • RE: Help with Forming SUb queries

    It looks like you aliased this to be "p". Change "PR" to "p" in the above script. (I was basing this solely off of what you had said)

    July 10, 2015 at 3:50 pm

    #1811777

  • RE: Help with Forming SUb queries

    shezi (7/10/2015)

    I have hard coded a DAte (6/22/2015 12:00:00 AM) inside DateDiff to get the last friday date. I want to put a Pr.DATE instead. This I think needs...

    July 10, 2015 at 3:15 pm

    #1811769

  • RE: Cast timestamp to string

    ctaylor 79909 (7/10/2015)

    PROBLEM DESCRIPTION:

    I have a problem where I use a batch file to call a MS SQL Script to write query results to a text file that uses...

    July 10, 2015 at 3:10 pm

    #1811767

  • RE: tab character in query results

    How are you getting the results from SQL into Notepad?

    If you are doing a copy/paste from SSMS, and your SSMS results are set to go to a grid, then there...

    July 9, 2015 at 8:05 am

    #1811323

  • RE: Query Performance tuning for cursor

    Junglee_George (7/9/2015)

    Ok..I agree with Wayne. Please help me in get rid of the cursor by alternate code.

    I am new to this set based approach, removing the cursor.

    Well, you're going to...

    July 9, 2015 at 7:52 am

    #1811316

Viewing 15 posts - 406 through 420 (of 5,590 total)