Viewing 15 posts - 511 through 525 (of 911 total)
Please post DDL and follow ANSI/ISO standards when asking for help.
January 25, 2019 at 1:39 pm
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
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
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
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
Please post DDL and follow ANSI/ISO standards when asking for help.
January 18, 2019 at 3:17 pm
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
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
| UserShiftID |
Please post DDL and follow ANSI/ISO standards when asking for help.
January 16, 2019 at 12:38 pm
Please post DDL and follow ANSI/ISO standards when asking for help.
January 16, 2019 at 11:35 am
Please post DDL and follow ANSI/ISO standards when asking for help.
January 15, 2019 at 1:46 pm
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
Please post DDL and follow ANSI/ISO standards when asking for help.
January 15, 2019 at 6:58 am
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
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
Viewing 15 posts - 511 through 525 (of 911 total)