Not sure if this is what Brett had in mind, but in SQL Server Management Studio Express, I selected the table, right-clicked and selected "Script Table as > CREATE to > New Query Editor Window", and then copied and pasted the results below:USE [maineinns_staging]GO/****** Object: Table [dbo].[MaineInnMembers] Script Date: 08/25/2010 14:31:45 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[MaineInnMembers]( [ID] [int] NOT NULL, [PropertyName] [nvarchar](255) NULL, [Designation] [nvarchar](255) NULL, [Innkeeper] [nvarchar](255) NULL, [Address] [nvarchar](255) NULL, [City] [nvarchar](255) NULL, [State] [nvarchar](255) NULL, [Zip] [nvarchar](255) NULL, [Phone1] [nvarchar](255) NULL, [Phone2] [nvarchar](255) NULL, [Fax] [nvarchar](255) NULL, [Email] [nvarchar](255) NULL, [Web] [nvarchar](255) NULL, [Region] [nvarchar](255) NULL, [Rooms] [int] NULL, [Suites] [int] NULL, [Cottages] [int] NULL, [SingleRoom] [nvarchar](255) NULL, [DoubleRoom] [nvarchar](255) NULL, [Suite] [nvarchar](255) NULL, [Cottage] [nvarchar](255) NULL, [Alt_Locale1] [nvarchar](50) NULL, [Alt_Locale2] [nvarchar](50) NULL, [Description] [nvarchar](max) NULL, [Enhanced_Description] [nvarchar](max) NULL, [MeetingFacilities] [int] NULL, [CreditCards] [nvarchar](255) NULL, [Pets] [bit] NOT NULL, [Restaurant] [bit] NOT NULL, [WheelchairUnit] [bit] NOT NULL, [TDD] [bit] NOT NULL, [VisualSystem] [bit] NOT NULL, [Openperiod] [nvarchar](255) NULL, [IndoorPool] [bit] NOT NULL, [OutdoorPool] [bit] NOT NULL, [Childcare] [bit] NOT NULL, [AirConditioning] [bit] NOT NULL, [FitnessCenter] [bit] NOT NULL, [Movies] [bit] NOT NULL, [CableTV] [bit] NOT NULL, [Lounge] [bit] NOT NULL, [Dataports] [bit] NOT NULL, [Transportation] [bit] NOT NULL, [Whirlpool] [bit] NOT NULL, [HotTub] [bit] NOT NULL, [Kitchenettes] [bit] NOT NULL, [AgencyCommission] [bit] NOT NULL, [Fireplaces] [bit] NOT NULL, [Laundry] [bit] NOT NULL, [RoomService] [bit] NOT NULL, [agriculturalfairs] [bit] NOT NULL, [amusementparks] [bit] NOT NULL, [antiquing] [bit] NOT NULL, [bicycling] [bit] NOT NULL, [birding] [bit] NOT NULL, [boatcruises] [bit] NOT NULL, [canoeing] [bit] NOT NULL, [xcskiing] [bit] NOT NULL, [fishing] [bit] NOT NULL, [golfing] [bit] NOT NULL, [hiking] [bit] NOT NULL, [hunting] [bit] NOT NULL, [islands] [bit] NOT NULL, [kayaking] [bit] NOT NULL, [lighthouses] [bit] NOT NULL, [musmshistsites] [bit] NOT NULL, [music] [bit] NOT NULL, [scenicbyways] [bit] NOT NULL, [shopping] [bit] NOT NULL, [snowmobiling] [bit] NOT NULL, [statenatlpark] [bit] NOT NULL, [summeryouthcamp] [bit] NOT NULL, [whalewatching] [bit] NOT NULL, [whtwtrrafting] [bit] NOT NULL, [windjammer] [bit] NOT NULL, [airport] [bit] NOT NULL, [highspeed] [bit] NOT NULL, [wifi] [bit] NOT NULL, [spaonsite] [bit] NOT NULL, [spanearby] [bit] NOT NULL, [WorldResID] [nvarchar](50) NULL, [EnhancedListing] [bit] NOT NULL, [Image1] [nvarchar](50) NULL, [Image2] [nvarchar](50) NULL, [InnLinkID] [nvarchar](50) NULL, [InnLinkURL] [nvarchar](50) NULL, [beachnearby] [bit] NOT NULL, [lakenearby] [bit] NOT NULL, [marinanearby] [bit] NOT NULL, [oceannearby] [bit] NOT NULL, [tenniscourtsnearby] [bit] NOT NULL, [beachclose] [bit] NOT NULL, [lakeclose] [bit] NOT NULL, [marinaclose] [bit] NOT NULL, [oceanclose] [bit] NOT NULL, [tenniscourtsclose] [bit] NOT NULL) ON [PRIMARY]
As you can see, this really doesn't seem like the most sensible way to handle the data. Any advice appreciated. 
schema question
Posted - 2010-08-02 : 14:57:57
