Viewing 5 posts - 1 through 5 (of 5 total)
Miles Neale (8/2/2012)
Chris - could you post also the schema of any indexes on those tables?
Sorry, How would I show this?
August 2, 2012 at 12:48 pm
Miles Neale (8/2/2012)
Chris - could you post also the schema of any indexes on those tables?
Again, forgive my skill level here. What is the best way to show this?
August 2, 2012 at 12:47 pm
Here are the table schemas
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Customer](
[CustID] [int] NOT NULL,
[DealerID] [int] NOT NULL,
[Distance] [int] NULL,
[SSN] [nvarchar](11) NULL,
[Last] [nvarchar](50) NULL,
[First] [nvarchar](30) NULL,
[Address] [nvarchar](60) NULL,
[City] [nvarchar](35)...
August 2, 2012 at 10:37 am
What is the best way to give you this information? As far as the schema and clustering? I have never created and clusters before.
Sorry for my limited knowledge here.
August 2, 2012 at 9:29 am
Here is how my tables look now.
Customer
CustIDDealerIDFirstLast
1100BillJones
2100Mary Smith
3100JimBell
1133SteveClamp
2133FrankTom
1200JaneFoster
DealerIDCustIDMailIDMailDate
1001F22.1231247/1/2012
1002F22.1231247/1/2012
1331C16.1123237/3/2012
2001S15.4345526/30/2012
I am joining these 2 tables based on DealerID and CustID. The powers that be here at my office want the customer table...
August 2, 2012 at 9:13 am
Viewing 5 posts - 1 through 5 (of 5 total)