Forum Replies Created

Viewing 15 posts - 586 through 600 (of 911 total)

  • RE: Is there a better way to write a simple query?

    ScottPletcher - Monday, September 17, 2018 3:02 PM

    sgmunson - Monday, September 17, 2018 1:40 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    September 19, 2018 at 11:28 am

    #2006316

  • RE: Multiple Join Behaviour

    NikosV - Friday, September 14, 2018 12:04 PM

    Hi guys,
    I've read 2 or 3 articles on Multiple Joins but I'm still failing...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    September 19, 2018 at 11:07 am

    #2006309

  • RE: Julian Date again ...sorry

    Jeff Moden - Sunday, September 16, 2018 9:29 AM

    jcelko212 32090 - Saturday, September 15, 2018 11:40 AM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    September 16, 2018 at 1:45 pm

    #2005899

  • RE: Julian Date again ...sorry

    Jeff Moden - Saturday, September 15, 2018 11:02 AM

    jcelko212 32090 - Thursday, September 13, 2018 4:31 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    September 15, 2018 at 11:40 am

    #2005874

  • RE: Julian Date again ...sorry

    To maintain my image as a pedantic poster, the yyyy-ddd display format Is called the ordinal date in ISO standards. The Julian date is used by astronomers and is a pretty big number,...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    September 13, 2018 at 4:31 pm

    #2005693

  • RE: Case statement with multiple values returned

    cory.hedstrom - Friday, August 31, 2018 9:59 AM

    you might want to look at this article
    https://www.red-gate.com/simple-talk/sql/t-sql-programming/state-transition-constraints/

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    September 13, 2018 at 2:59 pm

    #2005689

  • RE: Does a check constraint with UDF has performance impact on Query?

    krishnaroopa - Tuesday, September 11, 2018 11:57 PM

    >> We have a Master [sic] table that has a primary key with two columns...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    September 13, 2018 at 2:49 pm

    #2005687

  • RE: Dynamic creating indexes

    Sababa - Tuesday, September 11, 2018 12:36 PM

    We don't have there any clustered indexes and there are no primary or unique. Only...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    September 11, 2018 at 7:50 pm

    #2005355

  • RE: Rewrite query

    PiMané - Tuesday, September 11, 2018 12:20 PM

    >> Is there another way of writing this query without first having to get the...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    September 11, 2018 at 7:45 pm

    #2005354

  • RE: need help on Derived table

    saptek9 - Friday, September 7, 2018 11:05 AM

    I have table named family with familyid,totalcount,adultcount,childcount

    now i need to create derive table with following...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    September 10, 2018 at 10:05 am

    #2005109

  • RE: How to Generate a common unique column for multiple views

    Naidu PK - Friday, August 31, 2018 2:36 PM

    >> I created 3 different views and I need a common column to join...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    September 2, 2018 at 9:53 am

    #2004226

  • RE: Compute & Rollup

    kd11 - Sunday, August 26, 2018 12:07 PM

    This statement will produce:  Select EmpID, Yr, sum(Sales)as Sales from Sales Group by EmpId, Yr With...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    August 28, 2018 at 11:35 am

    #2003669

  • RE: Prevent duplicates in a table

    andycadley - Monday, August 27, 2018 12:32 PM

    If you want it as an output format, fine but 99% of non programmers won't...

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    August 27, 2018 at 1:39 pm

    #2003519

  • RE: Prevent duplicates in a table

    TomThomson - Monday, August 27, 2018 11:13 AM

    andycadley - Friday, August 24, 2018 11:03 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    August 27, 2018 at 11:58 am

    #2003494

  • RE: EXCEPT

    drew.allen - Monday, August 27, 2018 10:08 AM

    jcelko212 32090 - Sunday, August 26, 2018 2:11 PM

    Please post DDL and follow ANSI/ISO standards when asking for help. 

    August 27, 2018 at 10:44 am

    #2003473

Viewing 15 posts - 586 through 600 (of 911 total)