The name 'avail_seq' is illegal in this context

#11

On Sep 23, 12:50*pm, Bret_Halford <b... (AT) sybase (DOT) com> wrote:

Quote:

Write it without the VALUES keyword:

*insert into test_table (avail_seq) select COALESCE(MAX(avail_seq), 0)
+ 1 FROM test_table

That worked - thanks!

#12

On Sep 23, 12:50*pm, Bret_Halford <b... (AT) sybase (DOT) com> wrote:

Quote:

Write it without the VALUES keyword:

*insert into test_table (avail_seq) select COALESCE(MAX(avail_seq), 0)
+ 1 FROM test_table

That worked - thanks!

#13

On Sep 23, 12:50*pm, Bret_Halford <b... (AT) sybase (DOT) com> wrote:

Quote:

Write it without the VALUES keyword:

*insert into test_table (avail_seq) select COALESCE(MAX(avail_seq), 0)
+ 1 FROM test_table

That worked - thanks!

#14

On Sep 23, 12:50*pm, Bret_Halford <b... (AT) sybase (DOT) com> wrote:

Quote:

Write it without the VALUES keyword:

*insert into test_table (avail_seq) select COALESCE(MAX(avail_seq), 0)
+ 1 FROM test_table

That worked - thanks!

#15

On Sep 23, 12:50*pm, Bret_Halford <b... (AT) sybase (DOT) com> wrote:

Quote:

Write it without the VALUES keyword:

*insert into test_table (avail_seq) select COALESCE(MAX(avail_seq), 0)
+ 1 FROM test_table

That worked - thanks!

#16

On Sep 23, 12:50*pm, Bret_Halford <b... (AT) sybase (DOT) com> wrote:

Quote:

Write it without the VALUES keyword:

*insert into test_table (avail_seq) select COALESCE(MAX(avail_seq), 0)
+ 1 FROM test_table

That worked - thanks!

#17

On Sep 23, 12:50*pm, Bret_Halford <b... (AT) sybase (DOT) com> wrote:

Quote:

Write it without the VALUES keyword:

*insert into test_table (avail_seq) select COALESCE(MAX(avail_seq), 0)
+ 1 FROM test_table

That worked - thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

comp.databases.sybase comp.databases.sybase