> INSERT INTO mytbl(Mydata, mydata2)
> VALUES ('some data', 'some more data')
>
> SELECT SCOPE_IDENTITY()

> insert into mytable (SequenceNumber, Field2, Field3)
> select max(SequenceNumber)+1 as SequenceNumber from transactiontable,
> 'Text for field 2', 'Text for field 3'

On Fri, 23 Feb 2007 10:35:24 +0100, "Bandit" <bandit@norge.no> wrote:

>However - for later use - is it possible to combine sub-queries with actual
>input in the way I tried? What is the correct way to do this?
>
>> insert into mytable (SequenceNumber, Field2, Field3)
>> select max(SequenceNumber)+1 as SequenceNumber from transactiontable,
>> 'Text for field 2', 'Text for field 3'

"Bandit" <bandit@norge.no> wrote in message
news:uo82FDuVHHA.4764@TK2MSFTNGP05.phx.gbl...
>I have made a query to add a record with increasing sequence numbers, and
>it seems to work properly.
>
> insert into mytable (SequenceNumber)
> select max(SequenceNumber)+1 as SequenceNumber from transactiontable
>
> PROBLEM 1
> --------------
>
> However I also need to add some data to the other fields in the record,
> directly in the query:
>
> insert into mytable (SequenceNumber, Record2, Record3)
> select max(SequenceNumber)+1 as SequenceNumber from transactiontable,
> 'Text for record 2', 'Text for record 3'
>
> However, I do not understand how to do this. Any input is appreciated!
>
> PROBLEM 2
> --------------
>
> If possible, I would also like the query to return the value inserted into
> the SequenceNumber field of the current record.
>
>
>
> Bandit
>
>
>
>
>
>
>