Forum Replies Created

Viewing 15 posts - 241 through 255 (of 26,487 total)

  • Reply To: Are the posted questions getting worse?

    Jeff Moden wrote:

    To add to what Grant has stated, I agree that "new" voices are a bonus on any forum but I have seen some "new" people come in with some...

    January 30, 2020 at 3:50 am

    #3721450

  • Reply To: SSC Fantasy Football 2019

    Should setup the place holder for the SSCFFL 2020 season.  I will be back!

     

    January 29, 2020 at 10:38 pm

    #3721399

  • Reply To: Extract date from String

    parmsivan.kannan wrote:

    DECLARE @Text nvarchar(250) = '\\ABC.dns.com\file_path1\filepath2\inc_files_20200122.xls'

    SELECT SUBSTRING(REVERSE(@Text),CHARINDEX('.',REVERSE(@Text))+1,CHARINDEX('_',REVERSE(@Text))-CHARINDEX('.',REVERSE(@Text))-1)

    This is much simpler and does not require the use of REVERSE: SELECT LEFT(RIGHT(@Text,12),8);

     

    January 27, 2020 at 5:24 pm

    #3720701

  • Reply To: Extract date from String

    Jeff Moden wrote:

     SELECT LEFT(RIGHT(@Text,12),8);

    Simple and to the point.  I would put a comment with it to explain what is being so that someone with less SQL knowledge...

    January 26, 2020 at 3:47 am

    #3720416

  • Reply To: Recruitment question

    I took the time to look at the posing on ZipRecruiter and to me it seems rather vague as to what you are looking for in a candidate.  I have...

    • This reply was modified 5 years, 7 months ago by Lynn Pettis.

    January 26, 2020 at 3:42 am

    #3720415

  • Reply To: Why is this query slow?

    You could also put it in a zip file and upload that to the site.

     

    January 17, 2020 at 10:38 pm

    #3716450

  • Reply To: Why is this query slow?

    Jonathan AC Roberts wrote:

    Another option is to use dynamic SQL. For any input parameters that are null the AND clause could be removed. For example, if @PatientID were null you could remove...

    January 16, 2020 at 8:41 pm

    #3716130

  • Reply To: Why is this query slow?

    First, this is a catch all query.  If either of the variables @PatientID or @CareProviderID are null you want to return all rows of data for PatientID and/or CareProviderID.

    There is...

    January 16, 2020 at 8:25 pm

    #3716124

  • Reply To: Why is this query slow?

    Would help if you posted the actual execution plan, not a picture of the graphic.  There isn't a lot of information available from the picture.  Also seeing the code would...

    January 16, 2020 at 6:47 pm

    #3716083

  • Reply To: Max function and indexes

    A question to be answered is this: How wide is each row of data?  This will impact the number of rows of data in each data page.  The fewer rows...

    January 16, 2020 at 6:25 pm

    #3716069

  • Reply To: Max function and indexes

    ScottPletcher wrote:

    Jeff Moden wrote:

    ScottPletcher wrote:

    Given that the table had no index at all, I didn't think in this case that making the clus index unique was necessary, particularly to the extent...

    January 16, 2020 at 4:51 pm

    #3716046

  • Reply To: Python Map

    MESONMARCUS wrote:

    Lynn Pettis, the difference in genetic structure between humans and chimps is around 4%. The pickyness of evolution is what gave rise to humans. One error in one line...

    January 16, 2020 at 4:24 pm

    #3716035

  • Reply To: Max function and indexes

    Craig Smith wrote:

    Thanks everyone.  I have added a clustered primary key in our test environment but can't compare the performance as the configuration is totally different.  When I do the 300...

    January 16, 2020 at 7:02 am

    #3715891

  • Reply To: Rendering in XML ?

    jbalbo wrote:

    Hi

    So here is some sample code for the first 15 fields

    and attached  is a sample of the entire XML

    Thanks

    SELECT People.[First Name],
         ...

    January 16, 2020 at 6:58 am

    #3715889

  • Reply To: Rendering in XML ?

    jbalbo wrote:

    Sorry for being SO vague, just wasn't sure what to ask....

    So the XML, I posted was part  of a layout I received for data to send on a monthly...

    January 15, 2020 at 9:33 pm

    #3715804

Viewing 15 posts - 241 through 255 (of 26,487 total)