rTraction

Viewing posts by: Greg Smith

Multiple Months Vertically – jQuery UI Datepicker [Update]

June 2, 2011

Written by | 1 Comment



After reading iHostage comment numberOfMonths: [3, 1] I realized that the jQuery UI Team had in fact provided a mechanism for showing multiple months vertically; the documentation just didn’t immediately convey that to me ;)

Specifying numberOfMonths: [3,1] will show 3 months in 1 column (verically).

Thanks jQuery UI Team for such awesome controls and iHostage for letting me know about my oversight ;)

The jQuery UI Datepicker is an awesome tool, but I discovered recently that it lacks a feature that I needed…showing multiple months vertically.

I decided to see if I could bend it to my will using CSS and some JavaScript. Using Firebug I was able to figure out what styles needed to be overridden and was able to get the result I was after. I give the jQuery and jQuery UI teams a lot of credit for writing VERY flexible libraries!
Read the rest of this entry »

Storing the Return Value of a Dynamic SQL Statement

May 25, 2011

Written by | No Comments



Sometimes when writing Stored Procedures we need to store the return value from a Dynamic SQL Statement in a variable for use later on in the Stored Proc. sp_executesql is the tool for the job.

Lets say for example that we need to store an ID value from a table whose value is dynamic.


DECLARE @tableName VARCHAR(30)
DECLARE @ID UNIQUEIDENTIFIER


Read the rest of this entry »