All, I have a new table with four columns.
1st column is count95
2nd column is count NT
3rd coulmn is countXP
4th column is date

I want to populate the new table with a select count(*) from an existing
table where OSType = 'windows 95' and so on. I want to populate all fields
at the same time and then put current date (10/21/2003) in the date field.
Could someone help me with the syntax. I know what I want to do, but I'm
having a hell of a time figuring out how to lay in out.
I hope this makes sense.

Thanks

_________________________________________________________________
Add MSN 8 Internet Software to your current Internet access and enjoy
patented spam control and more. Get two months FREE!
http://join.msn.com/?page=dept/byoa

MS Sql Server LazyDBA home page