Multi Column Sub Query Support - by Imran Shaikh

Status : 

 


12
1
Sign in
to vote
ID 288772 Comments
Status Active Workarounds
Type Suggestion Repros 2
Opened 7/23/2007 10:47:33 PM
Access Restriction Public
Primary Feedback Item 299231

Description


Still there is no support for multicolumn sub queries....

e.g. in oracle....

Select * from CallDetails where (CustomerID, ProductID) IN (Select CustomerID, ProductID from CustomerGroups Where GroupID=1)

I was in big trouble when converting queries of oracle financials when I was creating Reporting Server on SQL2005, in Oracle Financials it doesnt have one column primary keys.... almost in all the tables multicolumn primary keys.... same scenario i need to handle when developing ETL and Reporting Layer for Convergys.... Geneva Billing System....

Scenario is difficult when joining 10...15 tables to retrieve data and almost 3...5 of them needs a sub query support with multi column sub queries... it takes a lot of time to convert.....

Sign in to post a comment.
Posted by Umachandar [MSFT] on 3/23/2010 at 2:03 PM
Hi,
I have resolved this feedback item as duplicate of one below:

https://connect.microsoft.com/SQLServer/feedback/details/299231/add-support-for-ansi-standard-row-value-constructors?wa=wsignin1.0

--
Umachandar, SQL Programmability Team
Posted by Erland Sommarskog on 8/18/2008 at 3:10 PM
Note that the query could be written as

SELECT * FROM CallDeatils CD
WHERE EXISTS (SELECT *
                             FROM    CustomerGroups CG
                             WHERE CG.CustomerID = CD.CustomerID
                                 AND CG.ProductID = CD.ProductID)

There are other situations where the need for row constructors is more compelling, though.
Posted by Michael [MSFT] on 12/14/2007 at 4:56 PM
Thanks for your feedback. We are looking into adding such functionality in a future release. Until then a work around to rewrite the query explictly to use a join syntax is recommended.

Best regards
Michael