Transact-SQL Cookbook
| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]
rankings, importing example readability, normalized data recipes aggregates classes arrays and tables comparing rows printing audit logs online account balancing row-level logging authorization logic, centralizing comparisons cumulative lists duplicates dynamic classification system external data, importing folding tables, importing and general hierarchies, implementing hierarchies aggregation aggregation revised manipulating recursively multilevel operations stepping through import procedure, hiding importing stored procedures and to live system intersections full partial light-bulb factory log-table partitioning logs activity-level logging event reporting snapshots space used undoing changes master records extracting generating online master tables and arrays, joining matrices adding/subtracting comparing for size multiplying printing traces, calculating transposing N values in sets nonaggregated columns permissions changing individual new, AccountPermissions table permission hierarchy, creating Pivot tables priority queues, implementing queues, implementing region boundaries regions in lists regions, limiting size regions, ranking by size runs sequences server push set complement different universes finding missing set size set differences sets, comparing with universe stacks, implementing statistics confidence intervals correlation calculation mean calculation median calculation mode calculation patterns standard-deviation calculation standard-error calculation variance calculation subsets , classifying summarizing set classes temporal data calendar information with durations calendar information with periods calendar printing duration calculation durations, reporting events, excluding nonrecurring events, excluding recurring first and last date of month granularity rules period queries period queries, granularity and periods, available periods, available common periods, continuous temporal values, storing out-of-range records, audit logs deleting recurring events, excluding, recipe reductions, duplicates 2nd selective reduction regions, lists boundaries finding limiting size ranking by size rejected data, buffer tables RemoveProjectsRecursive procedure reports activity log log events restricted snapshots revoking permissions ROLLBACK statement, log-table changes root, hierarchies row-level logging activity-logging comparison recipe rows arrays, comparing Pivot tables tables, defining running aggregate query runs lists
|