What's the primary key in CarrierRoutes?

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #215,909 by drewk 7/21/05 12:24:46 PM Reply	What's the primary key in CarrierRoutes? Is there a unique index in CarrierRoutes? === Purveyor of Doc Hope's [link\|http://DocHope.com\|fresh-baked dog biscuits and pet treats]. [link\|http://DocHope.com\|http://DocHope.com]
Post #215,916 by folkert 7/21/05 1:14:48 PM Reply	Record number. There are so many Carrier Routes that are the same, but for different ZipCodes... Awww, feck it all. The Address Details has everything I need, I just have to compute totals and sorting by. It ain't worth the effort to join this stuff. Of course... I could do all left joins. See as I only know them. -- [link\|mailto:greg@gregfolkert.net\|greg], [link\|http://www.iwethey.org/ed_curry\|REMEMBER ED CURRY!] @ *i_wethey* [image\|http://www.danasoft.com/vipersig.jpg\|\|\|\|]
Post #215,924 by tuberculosis 7/21/05 1:58:00 PM Reply	So CarrierRouteId+ZipCode is unique? "Whenever you find you are on the side of the majority, it is time to pause and reflect" --Mark Twain "The significant problems we face cannot be solved at the same level of thinking we were at when we created them." --Albert Einstein "This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses." --George W. Bush
Post #215,950 by folkert 7/21/05 3:23:46 PM Reply	Yessir Indeed that is what is unique. Never had to use a Multi-field primary key. -- [link\|mailto:greg@gregfolkert.net\|greg], [link\|http://www.iwethey.org/ed_curry\|REMEMBER ED CURRY!] @ *i_wethey* [image\|http://www.danasoft.com/vipersig.jpg\|\|\|\|]
Post #215,967 by tuberculosis 7/21/05 4:00:04 PM Reply	It happens and you can use it that way if it is immutable. Otherwise replace it with a generated key and add a constraint. "Whenever you find you are on the side of the majority, it is time to pause and reflect" --Mark Twain "The significant problems we face cannot be solved at the same level of thinking we were at when we created them." --Albert Einstein "This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses." --George W. Bush

Okay, so here I am making an indeterminate - (folkert) - (7) - July 21, 2005, 10:27:48 AM EDT

Why have the zip in 3 seperate tables? - (ChrisR) - (1) - July 21, 2005, 11:10:36 AM EDT

Table record number are in teh Millions already - (folkert) - July 21, 2005, 11:57:08 AM EDT

What's the primary key in CarrierRoutes? - (drewk) - (4) - July 21, 2005, 12:24:46 PM EDT

Record number. - (folkert) - (3) - July 21, 2005, 01:14:48 PM EDT

So CarrierRouteId+ZipCode is unique? -NT - (tuberculosis) - (2) - July 21, 2005, 01:58:00 PM EDT

Yessir - (folkert) - (1) - July 21, 2005, 03:23:46 PM EDT

It happens - (tuberculosis) - July 21, 2005, 04:00:04 PM EDT

iwethey.org

Whenever someone says, "Show, don't tell," aren't they violating that exact rule?
155 ms