Reputation
386
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 13
Newest
 Organizer
Impact
~8k people reached

Apr
15
comment Rounding Casted Converting Error
Be aware that SQL Server is allowed to try and do this cast even on rows that do not meet the WHERE criteria. Is there any data in the table int hat column that would not cast?
Apr
7
comment How to manage many-to-many relationships when there is also a hierarchy among the many?
Oh, I've only just noticed you're using Access. That will limit things rather, since you don't (I believe) have recursive CTEs available. Given the relatively underpowered nature of your DB, I'd say implement a simple solution in the DB, that possibly allows for inconsistencies, and have your application code maintain the consistency that the DB cannot.
Apr
7
comment How to manage many-to-many relationships when there is also a hierarchy among the many?
... if the former, you could use any of the standard approaches for storing trees in SQL, and the assignment would be against the tree node
Apr
7
comment How to manage many-to-many relationships when there is also a hierarchy among the many?
So with the project | phase | task hierarchy, is it the case that assignment to (eg) a phase automatically connotes assignment to all the contained tasks? Or could an employee be assigned to a phase and just one of the contained tasks?
Mar
27
answered Searching multiple tables in SQL
Mar
25
answered Finding the end of a Relationship chain optimally
Mar
25
comment Efficient way to transpose large categorical column to one-hot table row
So you want to end up with a resultset with ~8000 columns?
Mar
25
comment Why is my Make Table query pasting 0 rows?
The query is coming up with 0 results because, given your data, the join conditions you've specified mean there are no matching rows. It's not going to be easy for us to say whether the problem is with your data or your query. Maybe do a SELECT on just the inner of your two JOINs, and see if that returns the data you expect; then manually examine a SELECT on Doc4.
Mar
3
revised What is causing an INTERSECT to run forever when the individual SELECTs run quickly?
expand title
Mar
3
suggested approved edit on What is causing an INTERSECT to run forever when the individual SELECTs run quickly?
Feb
20
suggested rejected edit on SQL Server's aggregate functions ignore nulls. How do I correct this?
Feb
17
comment Rank function creating duplicate partitions? (two rank 1's for the same key)
Or, if you're happy for SQL Server to completely arbitrarily pick a winner from two identical rows, use ROW_NUMBER rather than RANK.
Nov
28
comment how to compare time slots?
Are all your times always exact minutes?
Nov
28
comment Why is casting a string to DATETIME not accurate to the ms?
@DamienGolding what would you expect SELECT CAST('3.6666666666666666' AS float) to return?
Nov
21
revised Is there any way to use “like” operator during oracle table partitioning
tags, tidy up
Nov
21
revised How can I check for stored procedure consistency across multiples servers
english .
Nov
21
suggested approved edit on How can I check for stored procedure consistency across multiples servers
Nov
21
suggested approved edit on Is there any way to use “like” operator during oracle table partitioning
Nov
13
comment Restoring a SQL Server 2012 database in high availability
Who "advised" you, and why don't you believe them? (note that I'm not saying whether what they said is right or wrong; I don't know)
Nov
12
answered Trigger firing when it shouldn't