Browse by Tags

What's That in 1940 Dollars?

As you probably know by now, I just blog up whatever happens to catch my attention at any given time (hence the title). Today I saw a newspaper report that compared the value of money from the 1940's to today. So I says to myself, "Self, where do they get these numbers from?" After a little...

Posted to Pseudo-Random (Weblog) by Mike C on 07-20-2005
Reading Text Files Into Tables

A while back, someone asked me how to read a text file and store it in a table in SQL Server. Here's a short script that reads a text file into a Temp Table, then performs a SELECT to return all the rows in the table as a resultset that can be accessed from VB.NET or C#.NET via a SqlDataReader or...

Posted to Pseudo-Random (Weblog) by Mike C on 07-19-2005
Calculating Floating Holidays

This is a follow-up to the calculating Easter entry I posted yesterday. In this one we calculate "floating holidays", such as Thanksgiving (U.S.) and Memorial Day. Once again we need to use the udf_modulo function we created in the last entry. This function calculates the "true modulus"...

Posted to Pseudo-Random (Weblog) by Mike C on 07-17-2005

Page 1 of 1 (3 items)

SQLServerCentral.com