http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/7499.aspxWed, 12 Aug 2009 07:01:50 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7499crestinul0http://sqlserver.ro/forums/thread/7499.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7499<P><BLOCKQUOTE><div><img src="http://sqlserver.ro/Themes/default/images/icon-quote.gif"> <strong>Diana:</strong></div><div>@dumos: You're welcome... @crestinul: nu-i chiar asa...</div></BLOCKQUOTE></P> <P>Se poate face la nivel de TSQl asa ceva <img src="http://sqlserver.ro/emoticons/emotion-1.gif" alt="Smile" /> adica sa-ti poti defini propria ta functie agregata?</P>http://sqlserver.ro/forums/thread/7495.aspxTue, 11 Aug 2009 16:58:26 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7495Diana0http://sqlserver.ro/forums/thread/7495.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7495@dumos: You're welcome... <br />@crestinul: nu-i chiar asa...http://sqlserver.ro/forums/thread/7493.aspxTue, 11 Aug 2009 15:59:47 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7493crestinul0http://sqlserver.ro/forums/thread/7493.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7493Nu am citit linkul dar cred ca se refera la o functie agregata in CLR care sa faca concatenarea de stringuri ,oricum alta solutie nu vad bine mai putin cea cu cursoruri care e super greoaiehttp://sqlserver.ro/forums/thread/7492.aspxTue, 11 Aug 2009 13:12:23 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7492dumos0http://sqlserver.ro/forums/thread/7492.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7492- din acel link am studiat mai multe solutii, pe cea cu CLR nu am reusit sa o implementez, imi da urmatoarea eroare la compilare: "Using the generic type 'System.Collections.Generic.List' requires '1' type arguments" <br />in momentul initializarii: "private List values;" <br /> <br />- am mai gasit aceeasi solutie implementata cu StringBuilder in loc de List care nu da erori la adresa: <br />"http://www32.brinkster.com/srisamp/sqlArticles/article_44.htm" - al doilea exemplu. <br /> <br />Inca odata multumesc, linkul a fost foarte utilhttp://sqlserver.ro/forums/thread/7489.aspxTue, 11 Aug 2009 07:12:24 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7489dumos0http://sqlserver.ro/forums/thread/7489.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7489Multumesc, foarte util linkul, destul de multe solutii prezentate acolo :)http://sqlserver.ro/forums/thread/7488.aspxMon, 10 Aug 2009 17:52:45 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7488Diana0http://sqlserver.ro/forums/thread/7488.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7488http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/http://sqlserver.ro/forums/thread/7487.aspxMon, 10 Aug 2009 13:53:06 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7487dumos0http://sqlserver.ro/forums/thread/7487.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7487Salut, <br /> <br />Pt a fi mai usor inteles o incep direct cu exemplul: <br />- am un tabel care are 2 coloane A si B de tip nvarchar <br />- datele din tabel: <br />------------------------------- <br />A B <br />xxx1 yyy1 <br />xxx1 yyy2 <br />xxx1 yyy3 <br />xxx2 jjj <br />------------------------------- <br />- printr-un select as dori sa obtin urmatoarea informatie: <br />------------------------------- <br />xxx1 yyy1,yyy2,yyy3 <br />xxx2 jjj <br />------------------------------- <br />Multumesc