Fishwrench.com

Excel array formulas… I nearly forgot about this bad-boys. Good thing I remembered how to use them, or I would be doing a lot of cutting and pasting at this late hour on a Friday. I was tasks with finding the Median for a range of numbers based on specific criteria. I had length-of-employment ranges [...]

Having trouble figuring out what the row terminator is for what appears to be .csv file but is actually Unix? Use the following:

ROWTERMINATOR = ’0x0a’

Looking for a way to find the first day of last month, this month, or next month? The following sql queries make it easy.

Open the sql Snippet

So, you’ve installed Wordpress and Buddypress on your site. Things look great, but you get a 404 page not found error every time you make a new post. The problem is in the pluggables.php file found in the wp-includes directory of your Wordpress install. There is some code that newer versions of IIS won’t play [...]

I developed for years in Access and finally made the leap to SQL. One item that took me quite awhile to figure out was the command to use in place of the Access nz function. Access junies know that nz() will treat a Null value as 0 so MyField can be used for calculations. Yikes! There [...]

So, someone has asked you for a list of records from your database, but they want a random pull. In your access days, you would have simply used:

No such luck in SQL. Doing something similar there would give you the same randomly generated number for each row. [...]

Much of the data I work with on a daily basis has to be grouped by months that span any number of years. Because I’m crossing multiple years, I can’t simply group by month and call it good. I also need a year designation. At the same time, I want my date field to be formatted [...]

An easy way to add a a print button to an asp.net page is to use javascript. The following script will add a default print button that will open the Windows print dialogue box and ultimately print the web page being viewed. <input type=”button” id=”btnPrint” onclick=”window.print ()” value=”Print”> You can also use a custom print button by [...]

To calculate age in an access query, use the DateDiff function. DateDiff("yyyy",,Date()) “yyyy” tell the function you want to calculate the difference between two dates in years. is your column name containing the date of birth. If your column name is ‘Birthday’, then use here. Date() tells Access to grab today’s date. DateDiff() can be used [...]

I’ve been making the transition from Access to SQL and finding that some function don’t exist in SQL, or at least not as how they appear in Access. If you’re looking to group by hour in SQL, use the following function:

GROUP BY datapart(hh,yourcolumnname)

Happy grouping!

So, someone has asked you for a list of records from your database, but they want a random pull. In your access days, you would have simply used: Code: SELECT *, RND(MyMemberID) FROM tblMyTable ORDER BY RND(MyMemberID) No such luck in SQL. Doing something similar there would give you the same randomly generated number for [...]

To find the beginning of today (removing the time component from a datetime column), use the FLOOR function in combination with CAST: Code: SELECT CAST(FLOOR(CAST(getdate() AS float)) AS datetime) This will convert the date to a decimal (float) format, drop the decimal portion, and then cast it again as a datetime. Yahoo – date only; no [...]