Unfortunate Ending of the Saying … Jack of All Trades
I work with data from a system that stores values as arrays or extents. In 2008, I created a CLR function to expose the C# split command. I tried several iteration with loops in T-SQL, etc. overtime, I have noticed the CLR as being a bit of a memory hog.Â
I found this possible solution : [...]
FROM http://www.sqlservercentral.com/articles/SSRS/69257/
Michael Davis has published this article and RDL files
on SQLServerCentral.com. Just happened to read the email, today.
SSRS is a powerful tool, but the ReportServer tool lacks some administrative reporting. Micahel Dais has done a great job filling in that gap!
Searching Google about Cursors in t-SQl might get this result http://www.jackdonnell.com/articles/SQL_CURSOR.htm. Here is an alternative
Good Explanantion and usage examples of the Except and Intersect Operators in SQL 2005 ( 2008).
SSRS Date Formating reference.. Thanks Thavash!!! You are a Rock Star!
Proper case T-Sql User Defined Function on Jeff’s SQL Server Blog – This simply attempts to capitalize the first letter of each word for the string passed in. Use it to help clean up some pre-existing data, but don’t use it as a way of presenting your data that is stored improperly since it isn’t exact.
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « May | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | |||