Hi, I have a sql query that has two parts 1) Which calls a stored proc and populates the data in the temp table (using openXML function) 2) The other part of sql that joins with this table and the result set Currently when i execute the stored proc it returns me the two result set. But it should return only me the second result set no...
Hi All, I want to do something like this... SELECT DISTINCT T1.* FROM T1 INNER JOIN T2 ON T2.ID1 = T1.ID1 INNER JOIN T3 ON T3.ID2 = T2.ID2 --FOLLOWING CAN BE ADDED MULTIPLE TIMES (LOOPS IN C#?) INNER JOIN T2 AS T2A ON T3.ID2 = T2A.ID2 INNER JOIN T1 AS T1A ON T1A.ID1 = T2A.ID1 --END MULTI WHERE T1.ID1 = 1 AND T3.ID3 = 2 AND T3.ID4 = ...
Hi, I have a specific inner join that establishes a join on a PAIR of columns in one join clause. My understanding, that I want to clarify about Hibernate, is that it allows joins only if you give it control of the many-to-one and one-to-many relationships. That's unfortunate, if true, because it sure would be nice to just have hibern...