I often come across the need for the following functionality in the Date object in javascript. I believe these are basic functionality that should have been there, but then who cares!! anyone can extend these. So in a series of blogs i will be extending the Date object using the javascript prototype :-)
| Functionality | Sample |
| Date.AddDay | Date.AddDays Javascript |
While developing the software for backoffice tour operators, we came across the need to display hierarchical data with knockout.js. Let us consider the following sample situation:
We need to display the features of our software for tour operators in a tree structure as shown below.
While developing the web application for tour operators @ syneity, we felt the need to move off from the combo box to something better. So here we will be designing the mockup for the same. We have identified the following states for this control.
| Sl. | State | Details |
| 1 | Initial | No data is selected |
| 2 | Typing | Data is being entered into the control |
| 3 | Selected | An item is selected from the search result |
| 4 | Add | User needs to enter a new value, one that is not there in the search result |
With the release of our Software for tour operators and the purchase of the same by a few operators, we felt the need to automate our release process. Our requirements in a nut shell:
“Take the latest version from our SVN repository, build it, run the scripts on the database and upload the build output to the website”
Nice, but then how do we do this??
That is what i am looking for….. will update with my findings..
Sql server Merge is a great tool as mentioned in my earlier blog. In this blog, i have a better example of using sql server 2008 merge.
If Not Exists(select * from sys.tables where name = 'TestTable')
Create Table TestTable(Id Int, SerialNo Int, Notes Varchar(50))
Declare @Tbl Table(SerialNo Int, Notes Varchar(50))
begin tran
Insert into TestTable(Id, SerialNo, Notes)
Values(1, 1, 'shouldnot be affected')
Insert into TestTable(Id, SerialNo, Notes)
Values(1, 2, 'shouldnot be affected')
Insert into TestTable(Id, SerialNo, Notes)
Values(2, 1, 'to-delete')
Insert into TestTable(Id, SerialNo, Notes)
Values(2, 2, 'to update')
Insert into @Tbl(SerialNo, Notes)
values(3, 'to insert')
Insert into @Tbl(SerialNo, Notes)
values(2, ' updated value')
select * from TestTable
Declare @Id Int = 2
Merge TestTable as Target
Using @Tbl as Source
On Target.Id = @Id And Target.SerialNo = Source.SerialNo
When Matched Then Update Set Target.Notes = Source.Notes
When Not Matched By Target Then Insert(Id, SerialNo, Notes)
Values(@Id, SerialNo, Notes)
When Not Matched By Source And Target.Id = @Id Then Delete
;
-- all items with id 1 must be present
select * from TestTable
rollback
