Papillon, you don't have to use dynamic sql in your solution...

Performance could be a problem in Papillon's solution if the table is large....

I don't think this will perform very well. Considering the data below. Your loop is iterated 10 times, and Sergiy's loop (and my loop) only 3 times.

set nocount on

go

create table...

...Sorry, I misunderstood... 

Replace the last part by

select

adrid,

adrpart

from @AdressParts

order by

adrid,

case when id % 10 in (1,2) then 0 else 1 end,

case when id %...

If there are no errors in your data (i.e each field contains 9 commas and the first two entries in your list are always positive integers), and if I understand what you...

Thanks for posting the results of your test....

The @Student table is from govinn's post. It is a table variable and not a "real" table in order to avoid changing the table structure of the database when testing the query (I guess)....

You need to stress which ScreenId's and RoleId's are connected. In your first XML, you have 4 ScreenId's and 4 RoleId's describing one Screens entity, with no clear relation between...

Been thinking some more....

If you insist on the XML format (which I still think you shouldn't), I believe that the following will work:

CREATE...

I think you should consider changing your XML a bit. As things are now, it is hard to connect screenid and roleid. Instead try the following (where related screenid's and...

I was a little puzzled why Govinn's query didn't work. Then I realised that this could be because your table has more columns than you have stated above - a unique...

Oups, you're right. But the min should be correct....

Or better. What happens if you try

Select

count(D.EventID),

sum(CoverChrgAmt),

sum(PayDetail.PaymntAmt),

December 9, 2005 at 5:10 am