public static string GetExceptionDetailsRecursively(Exception e) { StringBuilder sb = new StringBuilder(); while (e != null) { sb.Append("Inner :"); sb.Append(e.Message); sb.Append("\t"); e = e.InnerException; } return sb.ToString(); }
Monday, March 11, 2013
Get Exception details recursively
How to get all notes comma separated group by customer
SQL Query - How to get all notes comma separated group by customer
NoteKey | CustomerKey | Note | LastEditedTime |
---|---|---|---|
1 | 18736673 | Accout access error, Contact Technical team. | 01/02/2013 |
SELECT n1.CustomerKey, (SELECT ','+ n2.Note+ ' Last Edited Time:' + convert(varchar(26),n2.LastEditedTime) FROM Note n2 WHERE n1.CustomerKey= n2.CustomerKey ORDER BY CustomerKey, Note FOR XML PATH('')) AS CustNote FROM Note n1 Group By n1.CustomerKey
Subscribe to:
Posts (Atom)