The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[OT] Calling SQL gurus..


  • To: ukha_d@xxxxxxx
  • Subject: [OT] Calling SQL gurus..
  • From: "kinchyuk" <alex@xxxxxxx>
  • Date: Thu, 07 Aug 2003 11:42:11 -0000
  • Mailing-list: list ukha_d@xxxxxxx; contact ukha_d-owner@xxxxxxx
  • Reply-to: ukha_d@xxxxxxx

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



Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.