-
SQL Update
can anyone tell me why i get the error
'SQL command not properly ended'
this sql was lifted directly from a Sybase database and seems to work OK there
update billing_update_items
set archive_flag = p_flag
from billing_update_items, dummy_billings_dets
where billing_update_items.service_id = p_service
and billing_update_items.class_id = p_class
and billing_update_items.update_type = 1
and billing_update_items.billing_det_id = dummy_billings_dets.id
and dummy_billings_dets.txs_date >= p_start_date
and dummy_billings_dets.txs_date <= p_end_date
and archive_flag <> p_flag;
COMMIT;
tia
mark.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|