Yes, as Steve said store them as strings (char or varchar) and just fill out the strings.

Presumably, you would have to figure it out from context and the data state of the record. Maybe keep a STATE or STATUS column that indicated where in your...

Jeff Moden (6/21/2008)

---

Heh... still, the best thing to do would be to give the person requesting that this be done without adding an IDENTITY column and without using an intermediate...

Dang!...

No, sorry. Don't think of a View as a separate storage for records, think of it as just an alias for a table expression.

I think that you might want...

Not automatically. I think that you would have to create Views/Synonyms in your CI schema to map to the objects in your CS schema.

Plus, I don't think that Case-Sensitivity...

Normally, you wouldn't store them that way, you would just store them as some numeric and than leave the leading zeros as a task for presentation formatting.

Yeah, someone always calls the cops on you! :hehe:

Oops, sorry. Forgot one of the steps:

--pre-compress the records:

Update TAB

Set Sex = CHAR(CASE Sex When 'M' Then 0 Else 1 End)

--Compress duplicates together and

--encode them into archetype...

Vish:

vish (6/19/2008)

---

I use SQL server 2000.

I have a table 'TAB' with 3 coulumns 'Name','Age','Sex'

and there is no primary key.

I have multiple duplicate data in my table. for eg..

ABC24M

ABC24M

LMN27M

LMN27M

LMN27M

PQRS25F

XYZ24M

XYZ25M

Now i would...

Jeff Moden (6/21/2008)

---

Tally table method in 2000 for this would require a triangular join... I believe. If you know a way to do this in 2k without using a...

Jeff Moden (6/21/2008)

---

There is a way to do this using SET ROWCOUNT 1 and a cursor (which is technically an intermediate table but fools most people). Performance will totally...

ramu.guggilla (6/21/2008)

---

i have a tables domain, location and visit.

table - domain (domain_id, name,creator,date)

table - location (location_id, location_name, domain_id, date)

table - visit(visit_id, domain_id,location_id)

there are foriegnkey relations on these tables. i need...

I want to add that IMHO, the reason that the work of ths ANSI SQL has seemed so out of step with users and practioners for the last 15 years...

Ok, this is all rather complicated, and I am not sure that I have it completely figured out, so anybody who knows better, please correct me:

First, here is a good...