Reputation
438
Top tag
Next privilege 500 Rep.
Access review queues
Badges
6 14
Newest
 Yearling
Impact
~16k people reached

Dec
15
comment Moving SQL Server database to a new disk while online
You're getting downvotes because you're not answering the question. There's only one server in the situation under discussion.
Nov
19
comment Determine Which Parameters Passed Into Stored Procedure
The obvious answer is that if you care about this, don't use default values?
Nov
5
comment Is there a way that I can merge the following update queries into one?
@ypercube fair points. Your own answer would of course be welcome...
Nov
4
comment Is there a way that I can merge the following update queries into one?
I'm guessing you can work out the third line then. The IN expression in the WHERE clause in Julien Vavasseur's answer should improve performance, if there's a lot of data to consider.
Nov
4
answered Is there a way that I can merge the following update queries into one?
Oct
21
awarded  Yearling
Oct
2
comment Fact Table with day grain that has many records that don't change
"which is getting a bit excessive" - a bit excessive for what? An organisation in a financial arena that has 14 million accounts probably has a bit of cash knocking around for db storage; why not use it?
Sep
30
comment Order by in SP with input param
"I also don`t want to [etc]" - why not?
Sep
22
comment modelling grocery orders, that can be split into multiple short orders
I don't have time to give a full answer, so I'll just offer: New table OrderPart that contains 1..n records per Order.
Sep
11
revised Cannot find either column “dba” or the user-defined function or aggregate “schema.functionName”, or the name is ambiguous
code formatting
Sep
11
suggested approved edit on Cannot find either column “dba” or the user-defined function or aggregate “schema.functionName”, or the name is ambiguous
Aug
4
awarded  Constituent
Jul
28
awarded  Caucus
Jul
1
awarded  Notable Question
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