Tag Archives: Correlated

Microsoft SQL Server 2008 SQL Quirk – When Using TOP 1 In Query With Correlated Subquery

I found this quirk in Microsoft SQL Server 2008 T-SQL tonight – thought I’d pass it along to spare you the grief it gave me for nearly 2 hours: SELECT TOP 1 CAST(ad.id_acct_biztax_detail AS INTEGER) AS id_acct_biztax_detail       ,ad.dte_due_taxes       … Continue reading

Posted in Computers and Internet | Tagged , , , , , , , , | Leave a comment