.

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...

Hi Luis

I am going to read and inwardly digest Jeff Moden's Spackle article[/url] that you is linked to in the thread you pointed to, and see if that suggests anything.

Many...

Man, it worked. I could have sworn I'd already tried that.

A slight twist though, and an extra confusing factor - the original file was actually Unix format, with only line-feed-terminated...

Hi experts

Here is the complete test table definition with primary key and enhanced data. I have replicated the existing patients twice but with new IDs (starting with a Q or...

Yes, that's absolutely right. I need to add some cases to the test data.

Sorry for not replying earlier, but...

In response to John Mitchell,

There are multiple records for each PatientID, each covering a separate date range. (We know that the date ranges can never overlap, though they will...

Dear experts

Here are the records I would expect a working query to return, highlighted in bold. I am taking an As At date of the 1st of June 2015 (2015-06-01):

PatientID...

Hi experts

To answer Kevin's question, the table I am getting the data from is a read-only view maintained by another team and originating from a non-relational database of doubtful integrity!...

Hi guys,

Thanks for the replies so far.

I obviously need to brush up my approach to asking questions! Here therefore is some DDL for a test table (thanks to Jeff...

Hello Gail

Just got an email from the DBA saying that he had shrunk the DB as a maintenance measure after rebuilding the indexes. I thought - based purely on what...

Re possible duplication of effort, I am co-ordinating with the DBA, who has just taken over the management of the DB. (I am more of an applications person, though I...