103 reputation
5
bio website tckspress.blogspot.com
location Prague, Czech Republic
age
visits member for 2 years, 4 months
seen 14 hours ago
TenCoKaciStromy

My hobby projects:
MS Office Wrapper for .NET

Oct
8
awarded  Popular Question
Sep
24
awarded  Autobiographer
Jun
21
awarded  Scholar
Jun
21
awarded  Editor
Jun
21
accepted Self blocking session
Jun
21
revised Self blocking session
added solution
Jun
20
awarded  Supporter
Jun
19
comment Self blocking session
Thanks for moving the question. This is propable much better site to ask. I changed the the TVP to the varbinary(max) and created clr function which accept varbinary(max) and returns the guids in table form. Its faster than spliting text. Now its in production I must wait some time for collecting results. I have not good experience with subselects because of performance. Joins made us much better performance. However, if change from TVP to varbinary(max) will not help, I'll try you solution. Thank's a lot for your concern. Your advices are best I found on the net.
Jun
18
asked Self blocking session