Thanks guys for the really rapid responses.

I am well aware of relational concepts. My example contained two non-related tables on purpose,
as a step on the way...

Thanks Ed, that makes it a good deal clearer.

The thought behind my original question was, in effect: Where a primary key contains multiple fields, can I use it (or its...

HanShi (10/25/2016)

---

You have defined the "TemplateName" column as the first in the composite key (clustered index), so the clustered index will be used if you use the "TemplateName" in the...

RossOverThere (9/9/2016)

---

sknox (9/9/2016)

---

Good question, but the explanation is incomplete. Precision is only half of the story, the other being scale.

1.0 can fit in a number with precision of 1, if...

I find this incredible as well. To my mind, rounding a number X to N places consists of the following steps:

1. Multiply X by 10 to the power of N

2....

Spot on Ben. Ditto ditto. +1

I too would like to treat others as I myself would wish to be treated. The attitude that "I will happily treat others the...

Ah yes, it all comes back... The Dreaded Batter Pudding Hurler of Bexhill-On-Sea. Eccles doing the weather forecast ("Winds light and variable. Dark tonight"). The time Bluebottle was rescued from...

Hmm... as a non-American without an SSN, it would appear that I don't exist.

You don't say. Must admit, I never...

I'm not sure if the plant manager or upper IT management was ever told, but I'm glad we never had to deal with a hard drive crash during that period....

.

What about DBAPE - Database...

8.0

6

1SQLCHAR08000"\""0DUMMY ""

2SQLCHAR08000"\",\""1CODE ""

3SQLCHAR08000"\",\""2MEANING ""

4SQLCHAR08000"\",\""3DESCRIPTION ""

5SQLCHAR08000"\",\""4TYPE ""

6SQLCHAR08000"\"\...

benjamin.reyes (4/18/2016)

---

I recently had a similar situation, and found the import-csv powershell cmdlet mixed with out-datatable/write-datatable cmdlets seemed to work the smoothest. Also easily handled parsing an array in...

Just for the record, why doesn't the backslash n after the fifth field in the format file show up, (unless one sticks a space between the backslash and the n,...

Hi Jeff and Luis

OK, used a format file as suggested in Jeff's article, works smoothly. Since some of the fields contain embedded commas, I have changed the real delimiters to...