Aggregating Correlated Sub-Queries
Every now and then you may attempt to calculate an aggregate function -- such as SUM() -- on a correlated subquery, only to encounter the following error:
2007-10-29
4,862 reads
Additional Articles
Data is at the Heart of Enterprise-Wide BI and DW, Part 3
My online series of articles has been focused on the need for businesses to "get serious" about their approach to developing an enterprise business intelligence (BI) and data warehousing (DW) capability. When pursuing this capability it is important to adopt a holistic view, followed by disciplined investment and execution.
2007-10-26
2,267 reads
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 9
Learn how to use PowerShell in conjunction with SMO to Generate an SQL Server Script.
2007-10-26
2,873 reads
Celko on SQL: Natural, Artificial and Surrogate Keys Explained
SQL programming guru Joe Celko offers a classification scheme and advice on using the right keys.
2007-10-25
3,595 reads
SQL Server 2005 Express Edition - Part 8 - XCopy Deployment
Part 8 of our series provides an overview of User Instance model (also known as “Run As Normal User” or simply RANU) and automatic database connectivity, which serve as two primary enablers for XCopy deployment, facilitating distribution of single-user databases.
2007-10-25
1,766 reads
Working with Time Spans and Durations in SQL Server
What is the best way to return the "duration" of an event in SQL, given the start and end datetime values? How can we add up these durations to return grand totals? What data types should be used to return this data to our clients? How do we handle overflows, such as when hours go over 23 or minutes total up to over 59? Are there any T-SQL functions or other techniques that are useful in these scenarios?
2007-10-24
4,455 reads
Featured Blog: BACKUP LOG WITH NO_LOG
From one of the SQL Server 2005 storage engine lead developers comes this look at the impact of using the NO_LOG and TRUNCATE_ONLY options.
2007-10-24
3,313 reads
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 8
This installment illustrates how to use PowerShell in conjunction with SMO to display object properties of all SQL Server Objects.
2007-10-23
2,594 reads
Maximizing Attribute Relationship Aggregations in Changing Dimensions
When designing your SQL Server 2005 Analysis Services (SSAS) dimensions and related attributes—appropriately called attribute relationships—you should consider how changes in your dimension data will affect the underlying dimension aggregations and, in turn, processing and query performance.
2007-10-22
951 reads
Problem connecting to SQL Server 2000 Analysis Services?
Connecting to SQL Server 2000 Analysis Services could lie in the memory settings. Get possible problems and solutions to connect to Analysis Services server.
2007-10-22
2,033 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
BCA KCU DARMO Telp/Wa:0817.839.777
CSO BCA 0817839777 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur...
BCA KCU JEMBER Telp/Wa:0817.839.777
CSO, BCA. 0817839777 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates,...
BCA KCU INDRAPURA Telp/Wa:0817839777
CSO BCA : 0817839777 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers