I would have to say the first option. Multiple datasets. I'm confused myself :/

Sorry I don't know how to provide a table structure. How may I do this?

In section 5, it shows 3 sets of codes each for each block which displays in the screen shot. i need a loop so that i don't have to make...

basically from the #proxylog_count_2 table. it displays clientusernames in a certain order. each block contains a different username. starting from number 1 in that table. i need it to loop...

right here it has 3 blocks. i need it to display 10 of them. from the first data in #proxylog_count_2 then get the 2nd and third, etc.

the code above only...

Can you tell me what the "a" and "b" stand for? and what the purpose of cross apply is?

Sorry I hope I can clarify better.

#ProxyLog_count_2 is ordered by counts.

there are 2 columns in proxylog_count_2, ClientUserName and counts. but i only want to display ClientUserName

so i use this.

Select...

Oh, it would be ordered by counts desc

Select ClientUserName, DestHost, count(DestHost) counts from #ProxyLog_record

where ClientUserName =(Select top 1 ClientUserName from #ProxyLog_count_2) Group by ClientUserName, DestHost order by counts desc

I have...