Order of joins - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Order of joins

Author

Topic

memarcie
Yak Posting Veteran

91 Posts

Posted - 2006-10-03 : 09:01:32

Does the order of joins matter in a query? If so, how should I determine the best order to join the tables?

Thanks,
Marcie

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-03 : 09:07:14

I think the query processor will do that for you.

Peter Larsson
Helsingborg, Sweden

pootle_flump

1064 Posts

Posted - 2006-10-03 : 09:08:14

Not really apart from for readability. Start with the "core" or inner table and work your way to the peripheral ones. I prefer all my inner joins first, then onto derived tables and then outer joins. I am also now a convert to the "No Right Join" coven as preached (I think) by Dr Cross Join.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-10-03 : 09:11:59

i'm in the General Fribble's camp on joins.
Right joins can be usefull especially with right merge joins: smallTable right merge join LargeTable on ...
Left joins are preferable.
Order of joins matters if you use join hints.

Go with the flow & have fun! Else fight the flow

blog thingie: http://weblogs.sqlteam.com/mladenp

pootle_flump

1064 Posts

Posted - 2006-10-03 : 09:20:44

Oh dear - does memarcie know what he\ she is in for....

Consider any absolute I ever post to be auto-caveated with *apart from circumstances where the opposite is true.

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2006-10-03 : 09:44:53

i remember reading the "Right Joins" discussion. It got a bit heated

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=71521

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-10-03 : 09:59:22

i didn't mean that one.

I remember starting a thread about a query i had once using a left join
and arnold suggested i use a right merge join. cut the time from 2 minutes to 1.5 seconds. I'm eternaly gratefull.
If it helps i know it was before Peter the Saint (Peso) came along.

Go with the flow & have fun! Else fight the flow

blog thingie: http://weblogs.sqlteam.com/mladenp

memarcie
Yak Posting Veteran

91 Posts

Posted - 2006-10-03 : 11:13:09

Here is the query I'm running. I want to see if I can reduce the run time


 
SELECT  
  	a.CLAIM, a.PROD_TYPE, a.CLM_TYPE,a.TAX_ID, a.client_id,
	a.PROV_NUM,a.NET_NUM,a.DEAL_REC,a.UPIN,
	a.PPO,a.INS_SSN,b.serv_date, a.UB_BTYPE,a.PROC_DATE,
	a.REC_DATE,a.PROC_TIME,a.DATEIN,a.DATEOUT,
	UPPER(a.ENTEREDBY) AS ENTEREDBY,a.DEAL_TYPE,
	a.dup as master_dup,a.SS,a.PHY_NUM,
	a.ACCIDENT,
	 a.time_stamp AS time_stamp,
	a.ediout,a.Deleted as master_deleted,
	UPPER(a.last_modified_by) AS last_modified_by,
	ISNULL(a.version, 0) AS VERSION,
	a.siteid,a.send_date_ah,a.origclaim,
	a.autoprice,a.nonnetwork,b.CHARGE,
	
        (CASE WHEN  b.price = 0 THEN b.charge ELSE b.price end) as repriced_amt,
	cast((case WHEN  b.charge > 0 THEN((charge - price)/ charge *100)else 0.0 END)as numeric) as variance_perc,
	(case WHEN  b.charge > 0 THEN((charge - price))else 0.0 END)as variance_amt,
	b.time_stamp  AS DETAIL_TIME_STAMP,
	b.idnum,	b.Deleted as detail_deleted,b.repriced,
	b.dup as detail_dup,b.Code,
	b.units,
	aa.addr_num,
	RTRIM(aa.addr_addr1) AS addr_addr1,
	RTRIM(aa.addr_addr2) AS addr_addr2,
	RTRIM(aa.addr_city) AS addr_city,
	RTRIM(aa.addr_state) AS addr_state,
	RTRIM(aa.addr_zip) AS addr_zip,
	RTRIM(aa.addr_count) AS addr_count,
	a.tpa_num,
	a.source,
	a.status,
	d.net_name,
	d.net_owner,
	d.owner_id,
	e.network_group_id,
	(CASE WHEN substring(a.ub_btype,2,1) != '3' and a.clm_type='U' THEN  'I' 
	 WHEN substring(a.ub_btype,2,1) = '3' and a.clm_type='U' THEN  'O' else  NULL end) as in_out,
	f.patcity,
	f.patstate,
	f.patzip,
	a.wc,
	b.tos,
	b.pos,
	b.reject,
	a.onset_date,
	member_of = case when (a.tax_id) in('391102739', '364385181', '364495910', 
			  '390806174', '390806181', '390806347', '390872192', '390930748',
			  '391022464', '391150165', '391540571', '391597102', '391678306',
                          '391696443', '391805963', '391824445', '391943214', '391947472',
			  '391979612', '390806180', '391027676', '391211629', '391480198',
			  '391595302', '391733325')
			then 'Aurora'
			ELSE
			Null
			END 
	--into HMPDW.dbo.dtbl_CLAIMS
	FROM	HMPDW_Staging.dbo.MASTER a		
	JOIN HMPDW_Staging.dbo.DETAIL b
	ON a.CLAIM = b.CLAIM
	AND a.VERSION = b.VERSION 
	and a.SOURCE = b.SOURCE	
	left outer join HMPDW_Staging.dbo.ADDLCLM f
	ON a.CLAIM = f.CLAIM
	AND a.VERSION = f.VERSION 
	and a.SOURCE = f.SOURCE	
	left outer join HMPDW_Staging.dbo.networks d
	on a.net_num = d.net_num
	LEFT OUTER JOIN HMPDW_Staging.dbo.ADDRESS aa
	ON a.loc_rec = aa.addr_num	
	left outer join HMPDW.dbo.network_wraps e
	on a.client_id = e.client_num
	WHERE
	b.dup = 0 and proc_date >= '20060915'

Here are the table scripts and indexes:

CREATE TABLE [dbo].[addlclm_combined] (
	[claim] [int] NOT NULL ,
	[amsclmno] [varchar] (13) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[numattach] [int] NULL ,
	[injury] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[provsuf] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[pataddr1] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[pataddr2] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[patcity] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[patstate] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[patzip] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[wpstitle] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[remarks] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[sub_fname] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[sub_lname] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[sub_mname] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[pat_rel] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[admit_hr] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[admit_type] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[admit_src] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[policy_num] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[pat_acct] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[amtpd] [decimal](11, 2) NULL ,
	[dischr] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[field13] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[refdoc] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[accident2] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[prtssn] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[fld84a] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[fld84b] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[fld84c] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[fld84d] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[time_stamp] [datetime] NOT NULL ,
	[last_modified_by] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[deleted] [tinyint] NULL ,
	[siteid] [tinyint] NULL ,
	[version] [tinyint] NULL ,
	[source] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[SYS_AUDIT_IND] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[SYS_UPDATE_DATE] [datetime] NULL 
) ON [DATA] TEXTIMAGE_ON [DATA]
GO

 CREATE  CLUSTERED  INDEX [claim] ON [dbo].[addlclm_combined]([claim], [version], [source]) ON [DATA]
GO

CREATE TABLE [dbo].[address] (
	[addr_num] [int] NOT NULL ,
	[addr_addr1] [char] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[addr_addr2] [char] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[addr_city] [char] (28) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[addr_state] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[addr_zip] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[addr_phone] [char] (22) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[addr_fax] [char] (13) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[addr_email] [char] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[addr_count] [char] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[addr_hcode] [decimal](7, 0) NOT NULL 
) ON [DATA]
GO

 CREATE  CLUSTERED  INDEX [IX_address_1] ON [dbo].[address]([addr_num]) ON [DATA]
GO

 CREATE  UNIQUE  INDEX [IDX_ANUM_ACITY_AZIP_ACOUNT_ASTATE] ON [dbo].[address]([addr_num], [addr_city], [addr_zip], [addr_count], [addr_state]) ON [INDEX]
GO

 CREATE  INDEX [IX_address] ON [dbo].[address]([addr_zip]) ON [DATA]
GO


CREATE TABLE [dbo].[detail_combined] (
	[claim] [int] NOT NULL ,
	[version] [tinyint] NOT NULL ,
	[pos] [tinyint] NULL ,
	[tos] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	 [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[servcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[charge] [decimal](11, 2) NOT NULL ,
	[price] [decimal](11, 2) NOT NULL ,
	[serv_date] [datetime] NULL ,
	[serv_date2] [datetime] NULL ,
	[reject] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[units] [decimal](9, 2) NOT NULL ,
	[diagptr] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[anesmin] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[paydeny] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[emer] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[cob] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[mods] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[pos2] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[time_stamp] [datetime] NOT NULL ,
	[last_modified_by] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[deleted] [tinyint] NULL ,
	[repriced] [tinyint] NULL ,
	[dup] [tinyint] NULL ,
	[siteid] [tinyint] NULL ,
	[lphylname] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[lphymname] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[lphyfname] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[lphysuffix] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[idnum] [bigint] NOT NULL ,
	[source] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[SYS_AUDIT_IND] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[SYS_UPDATE_DATE] [datetime] NULL 
) ON [DATA]
GO

 CREATE  CLUSTERED  INDEX [IX_detail_combined_2] ON [dbo].[detail_combined]([claim], [version], [idnum]) ON [DATA]
GO

 CREATE  INDEX [IX_detail_combined] ON [dbo].[detail_combined]([claim], [version], [time_stamp]) ON [INDEX]
GO

 CREATE  INDEX [IX_detail_combined_1] ON [dbo].[detail_combined]([claim]) ON [INDEX]
GO




CREATE TABLE [dbo].[master_combined] (
	[CLAIM] [int] NOT NULL ,
	[PROD_TYPE] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CLM_TYPE] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[client_id] [int] NULL ,
	[TAX_ID] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[PROV_NUM] [int] NULL ,
	[NET_NUM] [int] NULL ,
	[DEAL_REC] [int] NULL ,
	[upin] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[LOC_REC] [int] NULL ,
	[PPO] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ins_ssn] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[pat_bd] [datetime] NULL ,
	[pat_sex] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ub_btype] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[disch_stat] [int] NULL ,
	[PROC_DATE] [datetime] NULL ,
	[onset_date] [datetime] NULL ,
	[diagcode1] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[diagcode2] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[diagcode3] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[diagcode4] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[diagcode5] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[proccode1] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[proccode2] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[proccode3] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[pat_fname] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[pat_lname] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[pat_mname] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[pat_acct] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[notes] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[status] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[retflags] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[SEND_DATE] [datetime] NULL ,
	[REVIEWED] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[SECOND] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[OCCURCODE] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[DRG] [int] NULL ,
	[REC_DATE] [datetime] NULL ,
	[PROC_TIME] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[STAMP_NUM] [int] NULL ,
	[chi_note] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ENTEREDBY] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[datein] [datetime] NULL ,
	[dateout] [datetime] NULL ,
	[deal_type] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[WC] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[phy_num] [int] NULL ,
	[IN_OUT] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[PAY_TO] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[UNDER_REV] [tinyint] NULL ,
	[EOB] [tinyint] NULL ,
	[dup] [tinyint] NULL ,
	[KICKOUT] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[PROVNAME] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[PHYSICIAN] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[employee] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[SS] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[phyrec] [int] NULL ,
	[TPA_NUM] [int] NULL ,
	[accident] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[time_stamp] [datetime] NOT NULL ,
	[ediout] [tinyint] NULL ,
	[filename] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[sourcclaim] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[direct] [tinyint] NULL ,
	[deleted] [tinyint] NULL ,
	[last_modified_by] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[invnum] [int] NULL ,
	[member_id] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[medicare] [tinyint] NULL ,
	[siteid] [tinyint] NULL ,
	[version] [tinyint] NULL ,
	[send_date_ah] [datetime] NULL ,
	[prvinvnum] [int] NULL ,
	[origclaim] [int] NULL ,
	[autoprice] [tinyint] NULL ,
	[prvbilladd] [tinyint] NULL ,
	[nonnetwork] [tinyint] NULL ,
	[phy_lname] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[source] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[SYS_AUDIT_IND] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[SYS_UPDATE_DATE] [datetime] NULL 
) ON [DATA] TEXTIMAGE_ON [DATA]
GO

 CREATE  CLUSTERED  INDEX [IX_master_combined] ON [dbo].[master_combined]([CLAIM], [version], [source]) ON [DATA]
GO

 CREATE  INDEX [IDX_TIMESTAMP_LOC_REC] ON [dbo].[master_combined]([time_stamp], [LOC_REC]) ON [INDEX]
GO

 CREATE  INDEX [IX_master_combined_1] ON [dbo].[master_combined]([PROV_NUM]) ON [INDEX]
GO

 CREATE  INDEX [IX_master_combined_2] ON [dbo].[master_combined]([PROC_DATE]) ON [INDEX]
GO

 CREATE  INDEX [IX_master_combined_4] ON [dbo].[master_combined]([TAX_ID]) ON [INDEX]
GO

 CREATE  INDEX [IX_master_combined_5] ON [dbo].[master_combined]([version]) ON [INDEX]
GO

 CREATE  INDEX [billing_index1] ON [dbo].[master_combined]([PROV_NUM], [PROC_DATE]) ON [INDEX]
GO

 CREATE  INDEX [IX_master_combined_6] ON [dbo].[master_combined]([TAX_ID], [CLAIM], [PROC_DATE], [version], [TPA_NUM]) ON [INDEX]
GO

 CREATE  INDEX [IX_master_combined_7] ON [dbo].[master_combined]([CLAIM], [time_stamp], [LOC_REC], [version]) ON [INDEX]
GO

 CREATE  INDEX [IX_master_combined_3] ON [dbo].[master_combined]([NET_NUM]) ON [PRIMARY]
GO 


CREATE TABLE [dbo].[network_wraps] (
	[client_num] [decimal](18, 0) NOT NULL ,
	[network_group_id] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [DATA]
GO

 CREATE  CLUSTERED  INDEX [IX_network_wraps] ON [dbo].[network_wraps]([client_num]) ON [DATA]
GO



[code]CREATE TABLE [dbo].[networks] (
	[net_num] [decimal](5, 0) NOT NULL ,
	[net_name] [char] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[net_aka] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[network_ef] [datetime] NULL ,
	[network_te] [datetime] NULL ,
	[net_owner] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[net_cred] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[net_mc] [bit] NOT NULL ,
	[repr_doc] [bit] NOT NULL ,
	[net_type] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[net_custom] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[net_note] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[sheetname] [char] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[spec_addr] [bit] NOT NULL ,
	[owner_id] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [DATA] TEXTIMAGE_ON [DATA]
GO

 CREATE  CLUSTERED  INDEX [IX_networks] ON [dbo].[networks]([net_num]) ON [DATA]
GO

Thanks for any help,
Marcie

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources