Thom A

Forum Replies Created

Viewing 15 posts - 526 through 540 (of 5,109 total)

Reply To: Are the posted questions getting worse?

I know many of us haven't seen Gail in awhile. I was at ZSL London yesterday and believe I found her:
(Sorry Gail if...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

March 10, 2020 at 4:03 pm

#3732893
Reply To: extract all data with week
Lots of us can help you, but you need to help us help you. What have you completed so far? Why isn't what you've done working, or where have you...
- This reply was modified 6 years, 3 months ago by Thom A.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 10, 2020 at 3:26 pm

#3732866
Reply To: Are the posted questions getting worse?
I can't remember who, but I remember someone in here saying that they were having problems with Powershell Core because of it's changed (lack of) functionality with Web Services.
As an...
- This reply was modified 6 years, 3 months ago by Thom A.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
March 5, 2020 at 9:20 am

#3731322
Reply To: Excel source error after windows update

According to Googling, that error code means that the connection failed to the file, normally is because it does not exist. Is the file name dynamic? If so, have you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

March 4, 2020 at 3:40 pm

#3730894
Reply To: SSIS Catalog and Github

Siten0308 wrote:
thanks again for your assistance Phil, so what I am getting at is (I am slow sorry), is it does work with Integration catalog SSISDB, BUT you have to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

March 4, 2020 at 9:46 am

#3730802
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

Jeff Moden wrote:
Sorry, Thom... my fault for this confusion. You're correct that it wasn't obvious at the time of the posting. I had the advantage of viewing the thread after several...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

March 3, 2020 at 2:36 pm

#3730570
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

I don't really feel like I should be defending myself here, but 'BSNC001481905191912080000001 PEE5P01 124650005 EMU 090D P' is 57 characters long, the length of all those columns is 80...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

March 3, 2020 at 2:25 pm

#3730566
Reply To: Are the posted questions getting worse?

Sean Lange wrote:
x wrote:
I (occasionally) work with an app like that, thousands of tables, no foreign key constraints, even better, if you add an index to a table, the next build...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

March 3, 2020 at 9:24 am

#3730470
Reply To: How to get specific database name for one common table

sram24_mca wrote:
Table Orders Schema,Definition are same. but row may differ.
You're still not giving any clarity I'm afraid. Perhaps show us what you're after, as your descriptions are very vague; they...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

March 3, 2020 at 9:15 am

#3730468
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

Jeff Moden wrote:
Thom A wrote:
How to you get 26 different columns from the string 'BSNC001481905191912080000001 PEE5P01 124650005 EMU 090D P'? I see 6 at most. Where are the other 20 coming from?
Fixed...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

March 3, 2020 at 9:10 am

#3730466
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.
Andrew Goffin-302397 wrote:
I did some timing tests and it will process these records at a rate of 140777 per minute, I was just wondering whether it could make it quicker and...
- This reply was modified 6 years, 3 months ago by Thom A.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 27, 2020 at 4:56 pm

#3729340
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

Andrew Goffin-302397 wrote:
you have assumed that the spaces are delimeters and there are none its 80 characters long and the spaces are empty fields/columns
the data is from a fixed width data...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

February 27, 2020 at 3:53 pm

#3729316
Reply To: Taking a single 80 character piece of Text and converting to columns in a table.
Andrew Goffin-302397 wrote:
'BSNC001481905191912080000001 PEE5P01 124650005 EMU 090D P'
my initial cut and paste got squeezed
That still looks like 6/7 columns to me:
```
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

Larnu.uk
```
February 27, 2020 at 3:40 pm

#3729310

Reply To: Taking a single 80 character piece of Text and converting to columns in a table.

How to you get 26 different columns from the string 'BSNC001481905191912080000001 PEE5P01 124650005 EMU 090D P'? I see 6 at most. Where are the other 20 coming from?

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

February 27, 2020 at 3:14 pm

#3729291

Reply To: Identity Guarantees

Nice reminder to those that use IDENTITY that it's supposed to be nothing more than an arbitrary number. 🙂

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

February 27, 2020 at 12:25 pm

#3729215

Viewing 15 posts - 526 through 540 (of 5,109 total)