Viewing 9 posts - 436 through 445 (of 445 total)
You' d better be more specific. For example if you need all rows from T1 plus some rows of T2 which are some way related to T1 it may...
February 20, 2014 at 2:56 am
Rows aren't MSSS securables which could be arguments of GRANT /REVOKE privileges. So you need your own dictionary or whatever storage to keep, grant, revoke privileges you need. So you...
February 20, 2014 at 2:40 am
Good work .
Considering performance gain I'd make some query optimization first. Looks like CTE may be a bit shorter, eliminating join which is only needed at final...
January 9, 2014 at 2:02 am
Hardly can imagine adding UNIQUE on a column just becase the column takes part in some join.
February 20, 2012 at 5:26 am
Adam Machanic (1/31/2011)
...Next, a unique constraint on the employee column, so that the same employee can't appear in the hierarchy twice under different managers...
This is correct for tree-like hierarchy only,...
February 1, 2011 at 2:06 am
WITH GroupMembers (Bottom, Child, ParentGroup, Level, hierarchypath)
AS
(
-- Anchor member definition
SELECT g.child as Bottom, g.child, g.parent, 0 AS Level, convert(varchar(max), g.child + '->' + g.parent) AS hierarchypath...
January 31, 2011 at 2:41 am
Ron,
I suggest you follow Jeff's advice and play with indexes.
NULLs may really affect execution plan.
November 29, 2007 at 12:54 am
A bit late, but i should mention one can find this design in many ERPs.
Just thing of 1000 or unkwnown and growing number of FKs.
November 28, 2007 at 1:13 am
Number type field value 0 is quite common real value.
I hardly can imagine how to tell the difference between 'real' 0 and 'NULL' 0.
November 28, 2007 at 12:51 am
Viewing 9 posts - 436 through 445 (of 445 total)