Re: [OT] Calling SQL gurus..

["kinchyuk" <alex@xxxxxxx>]

Thanks guys, got it sorted now!

Alex

--- In ukha_d@xxxxxxx, Tony Butler <lists@a...> wrote:
> Leave off the brackets around the select bit and you're away in SQL
Server....
> Quoting aashram <groups@a...>:
>
> > in oracle and I suspect in standard sql
> > you just do this
> >
> >
> > INSERT INTO table2 (field1,field2,field3)
(SELECT 'abc',value1,value2 FROM
> > table1 WHERE value3 = 'xyz')
> >
> >
> > -----Original Message-----
> > From: kinchyuk [mailto:alex@xxxxxxx...]
> > Sent: Thu 07/08/2003 12:42
> > To: ukha_d@xxxxxxx
> > Cc:
> > Subject: [ukha_d] [OT] Calling SQL gurus..
> >
> >
> >
> > 	Hi,
> >
> > 	I'm trying to do a SQL insert on MS SQL 2000 that does a
select query
> > 	to insert a couple of fields in the record. Something like:
> >
> > 	SELECT value1,value2 FROM table1 WHERE value3 = 'xyz'
> > 	INSERT INTO table2 (field1,field2,field3) VALUES ('abc',
(value1 from
> > 	select),(value2 from select))
> >
> > 	Help!
> >
> > 	Alex
> >
> >
> >
> > 	** UKHA2004 BE THERE! ** - start planning now.
> >
> > 	http://www.automatedhome.co.uk
> > 	Post message: ukha_d@xxxxxxx
> > 	Subscribe:  ukha_d-subscribe@xxxxxxx
> > 	Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
> > 	List owner:  ukha_d-owner@xxxxxxx
> >
> > 	Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ** UKHA2004 BE THERE! ** - start planning now.
> >
> > http://www.automatedhome.co.uk
> > Post message: ukha_d@xxxxxxx
> > Subscribe:  ukha_d-subscribe@xxxxxxx
> > Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
> > List owner:  ukha_d-owner@xxxxxxx
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >