I have a query where I join 7 tables (4 of which are aliases).
This results in a resultset where there is a huge amount of redundancy.
Now I wish to map this resultset to 3 object Types.
Is the best method to simply iterate over the resultset and build a Set of
each Type.
Due to the redundancy most attempts to add to the built Sets will fail.
I think this will be quickest since it is one query and the reduncancy won't
affect the disk access.
Re: data type error in my query ... the resultset returned the same value for comments. ... FROM dbo.tblWeblog as W1 LEFT OUTER JOIN dbo.tblUserComments as C ... > If blogID is a unique identifier for rows of tblWeblog, ... If I strip out W.blogComment the query runs fine. ... (microsoft.public.sqlserver.programming)
Re: When do selects execute for multiple resultsets ...SQL Server executes each query and stops when its ... When the first resultset is ... The CommandTimeout is measured from the time you execute the query until the ... (microsoft.public.dotnet.framework.adonet)
refreshing a window ... the query is processed, the results do not come up at the bottom until ...private JTextField output, input, input1, input2, input3; ...ResultSet resultSet;... (comp.lang.java.programmer)
Re: Group By ... If you are looking to do the eqivalent of a GROUP BY in a SELECT query...resultset and issue queries using the QueryADataSet assembly. ... > I could solve this using multiple queries and differnt filters,... (microsoft.public.dotnet.framework.adonet)
