Hello everyone,
I'm preparing to do a bulk update of our t_eaddress table and have tried the following code to add a new e-mail, however, it runs OK but when I try to look at t_eaddress I can't load the table.
USE
[impresario]GO
set
ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo declare
declare
@eaddress_no int
-- get a new address id
Begin
Transaction--insert into t_eaddressinsert [dbo].t_eaddress( eaddress_no, customer_no, eaddress_type, address, start_dt, end_dt, months, primary_ind, inactive, market_ind, alt_signor, mail_purposes, create_loc, created_by, create_dt, last_updated_by, last_update_dt, html_ind)
values
( @eaddress_no, '95265', '9', 'test@youngvic.org', NULL, NULL, 'YYYYYYYYYYYY', 'N', 'N', 'Y', NULL, NULL, 'YVD024', 'gellis', '2011-04-06 12:00:00.000', NULL, NULL, 'Y');
Am I missing something really obvious?
Thanks ever so much for your help
Graeme
Young Vic Theatre
Many thanks everyone,
Your help has been very much appreciated.
Grae