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...
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...
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...
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...
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...
March 29, 2019 at 2:06 pm
Name
User ID
How many days...
March 27, 2019 at 5:19 pm
March 16, 2019 at 1:50 pm
Sreepathi1987 - Thursday, February 26, 2015 8:02 AM
You have used a classic adjacency list model for your hierarchy. This is not the...
March 15, 2019 at 10:47 am
briancampbellmcad - Wednesday, March 13, 2019 9:50 AM
>> I have thousands of social security numbers I need to trim to leave only...
March 14, 2019 at 1:44 pm
Create a table with all...
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,...
March 10, 2019 at 12:38 pm
Viewing 15 posts - 466 through 480 (of 911 total)