Building calendar table using MTVF
This script is a small extension to this excellent article
http://www.sqlservercentral.com/articles/calendar/145206/
2019-10-04 (first published: 2017-02-21)
1,363 reads
This script is a small extension to this excellent article
http://www.sqlservercentral.com/articles/calendar/145206/
2019-10-04 (first published: 2017-02-21)
1,363 reads
Calculates total length of services for a employee. Calculates( addition or subtraction) two internships in form of yy.mm.dd
2019-10-04 (first published: 2016-10-03)
472 reads
2019-10-04 (first published: 2016-10-03)
798 reads
This script serves to display the content of the waiting resource. It is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.
2019-10-04 (first published: 2017-02-21)
925 reads
The Resource name is most important information in the blocked process report.
The purpose of this script is to decode this information.
The script is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCLR.
2019-10-04 (first published: 2017-02-20)
1,598 reads
Transform your query result into an Excel file using this technique.
2018-03-05
7,033 reads
2017-07-07
1,088 reads
This article shows a few techniques with SQLCLR to to transform a query result into HTML.
2017-06-05
3,781 reads
This article shows a few techniques that help in capturing deleted records.
2016-12-19
12,176 reads
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Hi everyone! I've been working with a Fargate app recently and I've managed to...
Comments posted to this topic are about the item Coding Magic Values
Hello Good Morning, I have three Tables, Assume Table1, Table2, Table3 these three tables...