Forum Replies Created

Viewing 15 posts - 511 through 525 (of 910 total)

  • RE: What is Alternative of numbered_procedures?

    parviz.vakili - Friday, January 18, 2019 11:20 PM

    Hi every body

    I use numbered_procedures because of versioning purpose. (Notice: versioning means version of live...

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

    January 25, 2019 at 1:13 pm

    #2020161

  • RE: Year By Months -Columns

    The problem here is that you don't quite understand how tables work. Columns are supposed to be attributes. But a year- month is not an attribute; it's a measurement of...

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

    January 24, 2019 at 2:41 pm

    #2020036

  • RE: Determining a Start Date within a subset of a group

    jim.powers - Thursday, January 17, 2019 11:50 AM

    I have a result set that I need to apply grouping within. However, the...

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

    January 23, 2019 at 12:58 pm

    #2019863

  • RE: Where condition for fiscal year

    The last time I looked, the GAAP had over 157 different fiscal years. The best way to do this is to set up a calendar table that maps your fiscal...

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

    January 18, 2019 at 3:21 pm

    #2019427

  • RE: Match vertical records to next greater date to find datediff

    brandon 94807 - Wednesday, January 16, 2019 2:58 PM

    I would do this differently. The viewing is an event and should be the...

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

    January 18, 2019 at 3:17 pm

    #2019425

  • RE: SQL Assignment - Join 2 Tables

    Would you mind saving us the trouble of reading your mind and posting some DDL? It would also help if we had some sample data to work with.

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

    January 18, 2019 at 2:53 pm

    #2019421

  • RE: Number of employees active per date

    astrid 69000 - Thursday, January 17, 2019 1:20 PM

    Your simple table is very badly done. You don't know about current data types....

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

    January 18, 2019 at 2:48 pm

    #2019420

  • RE: T-SQL Multiple Rows into One Row

    SQL Espo - Wednesday, January 16, 2019 11:16 AM

    I have the following rows

    UserShiftID

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

    January 16, 2019 at 12:38 pm

    #2019133

  • RE: cte Coding... Need the case statement to get this to work

    drew.allen - Tuesday, January 15, 2019 2:07 PM

    jcelko212 32090 - Tuesday, January 15, 2019 1:46 PM

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

    January 16, 2019 at 11:35 am

    #2019127

  • RE: cte Coding... Need the case statement to get this to work

    drew.allen - Tuesday, January 15, 2019 9:50 AM

    jcelko212 32090 - Tuesday, January 15, 2019 9:21 AM

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

    January 15, 2019 at 1:46 pm

    #2019000

  • RE: cte Coding... Need the case statement to get this to work

    First of all, there is no such thing as a case statement in SQL. We have a case expression, which returns a single scalar value. But more than that, your...

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

    January 15, 2019 at 9:21 am

    #2018948

  • RE: count by fiscal quarter

    Papil - Monday, January 14, 2019 5:48 AM

    A useful idiom is a report period calendar. It gives a name to a range...

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

    January 15, 2019 at 6:58 am

    #2018928

  • RE: Recursive Parent Child Same Table

    Jackie Lowery - Friday, December 28, 2018 11:53 AM

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

    January 2, 2019 at 11:30 am

    #2017781

  • RE: Is it possible to Filter out Columns in Select statement?

    tom 69406 - Friday, December 21, 2018 9:24 AM

    Can you afford to buy a book on basic RDBMS? You have missed the...

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

    January 2, 2019 at 10:44 am

    #2017772

  • RE: trigger blues no primary key

    fizzleme - Thursday, December 27, 2018 11:12 AM

    I'm converting a database to SQL server from SQL Anywhere.   The tables use a trigger...

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

    December 30, 2018 at 3:59 pm

    #2017622

Viewing 15 posts - 511 through 525 (of 910 total)