Select max(orgid) as MaxOrgID from dorganization Insert Into dOrganization (Orgid,OrganizationName, Phone, Extension, Division, FaxNumber, TimeZone, Address1, EmailName, GeoServiceID, Address2, Hotline, City, StateOrProvince, URL, PostalCode, Country, GraphicURL, Profile, Times, Visitor_Id, UpdateStatus) Values (#neworgid#, '#form.OrganizationName#', '#FinalPhoneNumber#', '#form.Extension#', '#form.Division#', '#FinalFaxNumber#', '#form.TimeZone#', '#form.Address1#', '#form.EmailName#', #form.GeoServiceID#, '#form.Address2#', '#FinalHotline#', '#form.City#', '#form.StateOrProvince#', '#form.URL#', '#form.PostalCode#', '#form.Country#', '#form.GraphicURL#', '#form.Profile#', '#currdate#', #userdate#, '1')