Holidays and Calendar Generation
Create the definition of your holidays and have them available for any year. Create a Calendar including holidays and business/work dates.
2017-12-15 (first published: 2016-02-16)
10,547 reads
T-SQL
2016-02-15
1,462 reads
2016-02-01
1,574 reads
2016-01-28
1,603 reads
Manipulating Filetable Files Programatically
Learn how you can work with FileTable files from T-SQL as an alternative to the drag and drop methods of using Windows Explorer
2019-01-18 (first published: 2016-01-28)
8,912 reads
2016-01-25
1,810 reads
2016-01-21
1,441 reads
2016-01-20
1,500 reads
2016-01-18
1,782 reads
2016-01-12
1,784 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
BCA KCP Santa Telpon/wa:0813.7887.595
BCA KCP Santa Telpon/wa:0813.7887.595.Jl. Wolter Monginsidi No.54, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan,...
BCA KCU VETERAN TLP/WA 083800209966
BCA KCU VETERAN TLP/WA 083800209966 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa...
BCA KCU GALAXY TLP/WA 083800209966
BCA KCU GALAXY TLP/WA 083800209966 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec....
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers