Forum Replies Created

Viewing 15 posts - 826 through 840 (of 911 total)

  • RE: Need counts of orders by month and year

    meichmann - Wednesday, June 14, 2017 12:02 PM

    I'm thinking of using an if statement with case statements [CASE is an expression in SQL] but...

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

    June 15, 2017 at 10:08 am

    #1946980

  • RE: Things to consider while creating new table for an application

    Jackson89 - Saturday, June 3, 2017 11:25 PM

    No, this is not a table. By definition, a table must have a key and...

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

    June 13, 2017 at 2:32 pm

    #1946659

  • RE: And/OR logic in SQL

    Look up De Morgan's laws in any book on logic.

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

    June 6, 2017 at 3:23 pm

    #1945710

  • RE: Best way to handle a table-based queue?

    Sam-263310 - Tuesday, June 6, 2017 9:53 AM

    QUESTION: Which method is better? (you decide what "better" means)

    Have you considered using the create sequence...

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

    June 6, 2017 at 3:21 pm

    #1945708

  • RE: Cursor removal

    >> I have a store proc that uses cursor to update table with 5 million records [sic]. It's extremely slow and expensive. <<

    actually, it’s worse than that. It...

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

    May 30, 2017 at 8:15 pm

    #1944666

  • RE: Multiple Values for Single Parameter in User Defined Function

    wweraw25 - Wednesday, May 24, 2017 1:57 PM

    Something like below:

    Exec dbo. Sp_Number '1,2,3,4,5'

    Result Set
    1       USA   Chicago
    2       UK...

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

    May 26, 2017 at 9:33 am

    #1944345

  • RE: Check multiple condition in sql query

    devesh.hassani - Wednesday, May 24, 2017 1:50 AM

    Why did you fail to post DDL? Your vague narrative is not a  good design. This is a...

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

    May 25, 2017 at 11:20 am

    #1944230

  • RE: Check multiple condition in sql query

    devesh.hassani - Wednesday, May 24, 2017 1:50 AM

    Why did you fail to post DDL? Your vague narrative is not a  good design. This is a...

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

    May 25, 2017 at 11:20 am

    #1944229

  • RE: How can I identify employee records with the same hire and term dates?

    jcelko212 32090 - Thursday, May 25, 2017 11:08 AM

    NineIron - Wednesday, May 24, 2017 6:05 AM

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

    May 25, 2017 at 11:09 am

    #1944227

  • RE: How can I identify employee records with the same hire and term dates?

    NineIron - Wednesday, May 24, 2017 6:05 AM

    The table has employee data. EmployeeID, HireDate, TermDate. Some records have the same EmployeeID and the Hire...

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

    May 25, 2017 at 11:08 am

    #1944226

  • RE: To Delete / Truncate / Drop & Create

    RonKyle - Tuesday, May 23, 2017 8:17 AM

    That isn't a natural key. It is using a surrogate key from another system.

    We may have...

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

    May 23, 2017 at 10:36 am

    #1943846

  • RE: To Delete / Truncate / Drop & Create

    RonKyle - Tuesday, May 23, 2017 8:17 AM

    That isn't a natural key. It is using a surrogate key from another system.

    We may have...

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

    May 23, 2017 at 10:36 am

    #1943845

  • RE: To Delete / Truncate / Drop & Create

    RonKyle - Thursday, May 18, 2017 7:08 AM

    I'd enjoy seeing a realistic example of when a natural key for an employees...

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

    May 21, 2017 at 3:06 pm

    #1943489

  • RE: Heap vs Clustered Wildcard Search

    josh-1127203 - Tuesday, May 16, 2017 10:21 AM

    Please read a book on RDBMS. The identity column is not a column! It's...

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

    May 18, 2017 at 12:16 pm

    #1943179

  • RE: To Delete / Truncate / Drop & Create

    stephen.plant - Monday, May 15, 2017 6:52 AM

    TheSQLGuru - Monday, May 15, 2017 5:51 AM

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

    May 15, 2017 at 1:34 pm

    #1942614

Viewing 15 posts - 826 through 840 (of 911 total)