Forum Replies Created

Viewing 15 posts - 541 through 555 (of 911 total)

  • RE: Looping Through Data

    irehman - Tuesday, December 18, 2018 7:52 AM


    Hello, I'm new to SQL.

    This is what I'm trying to do. 
    If Caller...

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

    December 19, 2018 at 10:29 am

    #2016858

  • RE: The Wild Developers of SQL Server like Wildcards

    The ANSI ISO standards have a predicate for this! SIMILAR TO is based on the POSIX version of grep, which means the wildcards are keywords bracketed by colons. We picked it based on...

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

    December 19, 2018 at 9:36 am

    #2016840

  • RE: Merge Tables with SQL Query Request

    carlton 84646 - Tuesday, December 18, 2018 5:35 AM

    You might want to read the front of every SQL forum. Instead of posting...

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

    December 19, 2018 at 9:21 am

    #2016837

  • RE: add to variable in case statement

    Sailor - Thursday, November 29, 2018 11:37 AM

    >> I want to add to a variable in a case state_codement: <<

    There is no...

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

    November 29, 2018 at 7:21 pm

    #2015036

  • RE: Inserting a new row into a table using a cursor

    ThomasRushton - Wednesday, November 28, 2018 5:40 AM

    gvoshol 73146 - Wednesday, November 28, 2018 5:22 AM

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

    November 28, 2018 at 8:26 am

    #2014809

  • RE: Inserting a new row into a table using a cursor

    Jeff Moden - Monday, November 26, 2018 3:04 PM

    jcelko212 32090 - Monday, November 26, 2018 12:02 PM

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

    November 27, 2018 at 7:44 am

    #2014650

  • RE: Relation table

    >> I have a [JOB] table that may reference multiple objects (by integer ID) each stored in a different table <<

    singular table name? This tells us you have...

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

    November 26, 2018 at 2:01 pm

    #2014573

  • RE: Sorting Data while using a Subquery

    Tables are not sorted, by definition. Queries return tables, by definition. Well, actually that’s not true. I could do a query to produce a non-table by not including a key....

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

    November 26, 2018 at 1:43 pm

    #2014572

  • RE: Inserting a new row into a table using a cursor

    josetur12 - Saturday, November 24, 2018 11:36 AM

    >> .. insert a row for all employees with out the 'Gift Card" row...

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

    November 26, 2018 at 12:02 pm

    #2014561

  • RE: Inner joins

    SQL Guy 1 - Monday, November 19, 2018 11:17 AM

    I cannot speak for Microsoft, but I certainly hope they never drop the...

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

    November 22, 2018 at 7:06 pm

    #2014371

  • RE: Give integer value to column based on sort

    gideon.e - Thursday, November 22, 2018 7:49 AM

    I want to write a sql statement to achieve the following and need some help.
    I...

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

    November 22, 2018 at 6:41 pm

    #2014369

  • RE: How to study the layout of a database?

    ben.brugman - Tuesday, November 20, 2018 5:26 AM

    jcelko212 32090 - Sunday, November 18, 2018 3:39 PM

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

    November 20, 2018 at 10:28 am

    #2014118

  • RE: How to study the layout of a database?

    I think it’s an excellent question 🙂, and I wish more people would ask it. The first obvious question is “what the heck is this thing supposed to do?”...

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

    November 18, 2018 at 3:39 pm

    #2013912

  • RE: Joining tables using OR condition

    jeffshelix - Thursday, November 15, 2018 2:56 PM

    Please don't use SELECT * in production code. I also hope you know table is...

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

    November 18, 2018 at 10:56 am

    #2013904

  • RE: Creating a Stored Procedure with Loop and If statement into a new table

    roy.hoult - Saturday, November 10, 2018 1:48 PM

    I think you really need to step back and get...

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

    November 18, 2018 at 10:49 am

    #2013903

Viewing 15 posts - 541 through 555 (of 911 total)