Viewing 15 posts - 1 through 15 (of 19 total)
I'm not sure I'm clear on your objective. Are you simply trying to get your three columns into a single select into the same table, or have I horribly misunderstood...
August 7, 2014 at 4:26 pm
Noted. In this case, it's a standard Foreign key relationship, like having the id from a country table as a fk in an address table.
February 25, 2014 at 4:49 pm
Turns out that SQL Server, by default, sets indexed fields to allow only unique values. To check this, open the table in Design and select "Manage Indexes and Keys"...
February 25, 2014 at 3:28 pm
Can't change the value to 65 as it's the [id] from the other table TBL_DFQ_MFG_PART_NBR. The need then is to have the field fk_mfg_nbr allow duplicates.
February 19, 2014 at 3:08 pm
We have a data base where a column has six atomic values stored in pairs of mixed alpha-numerical values (1A P7 S0). The data values are foreign keys. ...
June 11, 2010 at 10:01 am
Follow instructions given by a prospective employer carefully. If the ad says "No phone calls", then don't call.
If you are sending a CV out to someone specifically, learn something...
July 16, 2009 at 10:31 am
...and another one. No defaults for mandatory fields.
You're going along, adding values to a form. Click on the next page. Add a value to a field that...
May 8, 2009 at 11:02 am
I know this sounds simplistic, but a few things I found in a third party ERP.
Multi value, multi type fields:
Ex: "30 1LAP0 " Read it and weep! ...
May 8, 2009 at 10:10 am
So what kind of temperature data do you use for the last 100,000 years?
Ice core samples from glaciers and ice packs. They are like tree rings. Will not...
February 12, 2009 at 5:05 pm
The debate about global warming is mute. The fact is, intense human activity has a detrimental impact on the earth's environment. I see it in the brown tap...
February 12, 2009 at 11:11 am
A good family pick is "Marley and Me". Great story, funny & sad and my daughter, who is 11, loved it.
January 30, 2009 at 8:01 am
Given my job description and title, I make way more then my colleagues. Given what I actually do, I get paid way less. Given my work experience and...
January 16, 2009 at 9:30 am
When writing/testing an SP, I always start by writing the procedure's interface along with the paramaters, initial output are the paramater values. I then write a query that calls...
December 12, 2008 at 10:31 am
I have a major problem with people who use automatic email filters.
I too had issues with people not responding to e-mails, either because they auto-filtered it off into another folder...
December 9, 2008 at 9:10 am
Viewing 15 posts - 1 through 15 (of 19 total)