RE: [OT] Calling SQL gurus..

[Tony Butler <lists@xxxxxxx>]

Leave off the brackets around the select bit and you're away in SQL
Server....
Quoting aashram <groups@xxxxxxx>:

> 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/
>
>
>