SQL: Turn a Date Range into a List of Dates

Posted by Justin on May 25, 2010 in Programming

I’m working on a project today that deals with date ranges being stored in SQL Server. Imagine a row in a table with a starting and an ending date. My desired output is to transform each single row into several, one for each date within the given date range.
Read more…

Tags: cte, recursive, sql

WebControl with embedded stylesheet rendering at design time

Posted by Justin on Feb 20, 2009 in Programming

I have a working solution to the embedded image in an embedded stylesheet problem, but I would appreciate any suggestions for improvement. This does its own substitution of the CSS file in the Designer class for the IDE. Transparency in PNGs don’t work so far, however. I’ll post some of the code here, but a full example solution is available for download. I’d love to hear comments on this. Thank you! Read more…

Tags: ASP.NET, C#, Programming

Stack Overflow

Comment by JustinStolle on Nerddinner inserting longitude and latitude to database MVC
@brien, did my answer help? […]
Answer by JustinStolle for Nerddinner inserting longitude and latitude to database MVC
Look in Scripts/NerdDinner.js for this block of code: //If we've found exactly one place, that's our address. //lat/long precision was getting lost here with toLocaleString, changed to toString if (NerdDinner._points.length === 1) { $("#Latitude").val(NerdDinner._points[0].Latitude.toString()); $("#Longitude").val(NerdDinner._po […]
Answer by JustinStolle for Why is my selected value showing up twice in a dropdownlist (asp.net mvc)
The Html.DropDownList() method accepts an optionLabel string parameter, the text of which is inserted at the top of the dropdown list (with an empty value). It doesn't necessarily have anything to do with which item of the list is selected. You could create a SelectList using your MyList and specify a selected value (http://msdn.microsoft.com/en-us/libr […]

Justin Stolle

SQL: Turn a Date Range into a List of Dates

WebControl with embedded stylesheet rendering at design time

Stack Overflow

Twitter

Meta