Damn you guys are good. Thanks to all of you..


>From: [Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] RE: help on moving data from on table to another
>Date: Tue, 21 Oct 2003 14:49:59 -0700
>
>insert mytable(cnt1,cnt2,cnt3,mydate)
>select top 1
>(select count(*) from srctbl where col='something1')
>,(select count(*) from srctbl where col='something2')
>,(select count(*) from srctbl where col='something3')
>,getdate()
>from srctbl
>
>
>-----Original Message-----
>From: Perry Gentry [mailto:[Email Address Removed] Tuesday, October 21, 2003 2:24 PM
>To: LazyDBA.com Discussion
>Subject: help on moving data from on table to another
>
>
>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
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Get today's cartoon: http://www.LazyDBA.com
>To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Get today's cartoon: http://www.LazyDBA.com
>To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] 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