1
vote
2answers
147 views

select values must match the number of insert columns

I have the following query... ive checked and rechecked the types and number of values in both the insert into and the select statements. I can't figure out what is wrong. insert into ...
1
vote
1answer
66 views

variables used in inner queries

im trying to build a query that has something like this select id, (select top 1 create_date from table2 where table1id = t1.id and status = 'success') ...