Useful Dates: The Many Uses of Date Tables
Brandon Galderisi brings us a new article that looks at how a table of dates can be useful in a SQL Server application.
2008-12-17
12,188 reads
Brandon Galderisi
The Numbers Table
Having a table of just numbers can be very handy, and it doesn't necessarily take up much space in your database. New author Brandon Galderisi brings us a short tutorial on setting this up.
2008-11-24
10,541 reads
Blogs
Daily Coping 29 Sep 2022
By Steve Jones
Today’s coping tip is to avoid saying “I should” and make time to do...
How to Calculate Compound Rate in Power BI
Recently I had an interesting use case where I had to a compound calculation...
Daily Coping 28 Sep 2022
By Steve Jones
Today’s coping tip is let go of other people’s expectations of you. I think...
Forums
PASS Data Community Summit
Who's going to PASS Data Community Summit this year? It's been quite a while...
SAP S/4HANA and Microsoft Azure SQL integration and ETL DELTA Process
By Surendra Kumar Reddy Koduru
In this Article I’m going to demonstrate the heterogenous systems integration and building the...
Get addresses that match list of customers
Let's say i have a table with columns: cus_no, address, city, state, zip. How...
Ask SSC