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:
Comments (Atom)