Thom A

Forum Replies Created

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

Reply To: Are the posted questions getting worse?

MVDBA (Mike Vessey) wrote:
but empty aircraft - that's a lot of fuel dumped into the atmosphere - maybe regulators might look at that idea and pay operators to not fly unnecessary flights
Last...

March 11, 2020 at 9:29 am

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

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 5 years, 8 months ago by Thom A.
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 5 years, 8 months ago by Thom A.
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...

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

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

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

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

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

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

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 5 years, 8 months ago by Thom A.
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...

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:
```
            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?

February 27, 2020 at 3:14 pm

#3729291

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