msi

You can't insert values in a number of tables with single statement. Use a statement for each table, By the way, where name = 'A' I suppose.

A few methods: [sql-ex.ru](http://www.sql-ex.ru/help/select17.php)

You can't work with datetime data type in the same manner as with character data types. If you need what have asked, try this: select regdate,description,machine_id,machine_nm,status from iris_log.dbo.tb_log_info where convert(varchar(10), regdate, 120) like '%-23%' [URL="http://sql-ex/help/select9.php#dtime"]Functions Transact-SQL handling datetime data types[/URL]

[code=sql]select * from emp where (empid=1234 and 1=1); select * from emp where (empid=1234 and 1=2);[/code]

select *,(select value1 from table2 where value2=(select max(value2) from table2 t2 where t2.value2<= t1.IncrementedNumber)) from table1 t1 You can get good practice in SQL at [URL="http://www.sql-ex.ru/"]SQL Exercises[/URL]