Viewing 15 posts - 466 through 480 (of 911 total)
>> We have a table that contains “SHIFT CODES”, where each shift code is defined by, you know, a code… and by “time boundaries”. For example, shift code 1ST is...
Please post DDL and follow ANSI/ISO standards when asking for help.
April 26, 2019 at 9:49 pm
You just run into one of the problems with the way time is modeled in Microsoft SQL Server. We talk about time in many different ways. When I'm talking about...
Please post DDL and follow ANSI/ISO standards when asking for help.
April 19, 2019 at 4:24 pm
>> I currently have two tables: <<
where is the DDL for these two tables? You expect us to write the DDL for you because you feel you're so privileged? What...
Please post DDL and follow ANSI/ISO standards when asking for help.
April 17, 2019 at 5:41 pm
In the future, would you mind following the basic netiquette that has been in effect for over 30 years on SQL forums? You’ve made an incredible number of common errors...
Please post DDL and follow ANSI/ISO standards when asking for help.
April 14, 2019 at 2:01 am
Please look at the following article:
https://www.red-gate.com/simple-talk/sql/t-sql.../state-transition-constraints/
instead of doing the attribute splitting that tables for different kinds of cases, you should be using one table that...
Please post DDL and follow ANSI/ISO standards when asking for help.
March 29, 2019 at 2:06 pm
Name
User ID
How many days...
Please post DDL and follow ANSI/ISO standards when asking for help.
March 27, 2019 at 5:19 pm
Please post DDL and follow ANSI/ISO standards when asking for help.
March 16, 2019 at 1:50 pm
Please post DDL and follow ANSI/ISO standards when asking for help.
March 15, 2019 at 11:51 am
Please post DDL and follow ANSI/ISO standards when asking for help.
March 15, 2019 at 11:46 am
Please post DDL and follow ANSI/ISO standards when asking for help.
March 15, 2019 at 11:40 am
Sreepathi1987 - Thursday, February 26, 2015 8:02 AM
You have used a classic adjacency list model for your hierarchy. This is not the...
Please post DDL and follow ANSI/ISO standards when asking for help.
March 15, 2019 at 10:47 am
Please post DDL and follow ANSI/ISO standards when asking for help.
March 14, 2019 at 8:19 pm
briancampbellmcad - Wednesday, March 13, 2019 9:50 AM
>> I have thousands of social security numbers I need to trim to leave only...
Please post DDL and follow ANSI/ISO standards when asking for help.
March 14, 2019 at 1:44 pm
Create a table with all...
Please post DDL and follow ANSI/ISO standards when asking for help.
March 14, 2019 at 1:32 pm
Saurabh.D - Friday, March 8, 2019 6:07 PMWhat is the fastest way to calculate the median
At one time in the SQL world,...
Please post DDL and follow ANSI/ISO standards when asking for help.
March 10, 2019 at 12:38 pm
Viewing 15 posts - 466 through 480 (of 911 total)