Wednesday, October 21, 2009

Copy Some Rows From Table1 to Table2 SqlServer

I am doing a one-time combining 2 separate legacy database tables that contain some of the same info but also additional different info into one new SqlServer table. I am also copying some but not all of that additional data.

So I am inserting some of the columns from each table into some of the columns in the new table.

If all the columns in table2 are going to be inserted into table1 and the column names are the same I can:

insert into table1 (Detail, Unitname, Sortorder) select * from table2

if there is a change in column name change:

insert into table1 (Detail, Unitname , Sortorder) select facilabbr as Detail, Unitname , Sortnum as Sortorder from table2

Tuesday, October 13, 2009

Javascript Function using RegEx Regular Expression

I need to check client side if a DropDownList.SelectedItem.Value is any of the following: 1,3,9,17,or 15.


Rather than use a clumsy if statement, I do this by seeing if the value will match a Regular Expression:

      function taskChange() {
var task = $get("ddlTest");
var RegExp = "(^1$^3$^9$^17$^15$)" ;
if (RegExp.match(task.value))
{
// A value of 1,3,9,17,or 15 was selected
               // do whatever 
           }
else
{
//Some other value was selected
                // do whatever
}
}