u can use BULKinsert

select * from table1 where SUBSTRING(table1.column2,1,2) like '%@param1%' or SUBSTRING(table1.column2,1,2)>'%@param2%' use dynamic query

yap it will work

if both the tables having same structure u can use select * from tbDocument union all select * from tbTasks1 where tbTasks1.IsDelete = 0

try java2s.com

i think it is displaying division ,You can convert this vales into varchar in the sql script

Me.txtItemNumber.Text = ddlKeyResultsMeaures.items(ddlKeyResultsMeaures.Selectedindex) try this