Sfrgttk

Why do neural networks need so many training examples to perform?

What to look for when criticizing poetry?

Can a hotel cancel a confirmed reservation?

Eww, those bytes are gross

Is it possible to grant users sftp access without shell access? If yes, how is it implemented?

How to make ice magic work from a scientific point of view?

How would an AI self awareness kill switch work?

Should I reinstall Linux when changing the laptop's CPU?

Which one of these password policies are more secure?

What is the wife of a henpecked husband called?

Absorbing damage with Planeswalker

What is a good reason for every spaceship to carry a weapon on board?

Has any human ever had the choice to leave Earth permanently?

Using only 1s, make 29 with the minimum number of digits

Construct transition probability matrix for markov chain

The use of the spellings -zz- vs. -z-

Why is it that Bernie Sanders is always called a "socialist"?

What is the most fuel efficient way out of the Solar System?

Finding a logistic regression model which can achieve zero error on a training set training data for a binary classification problem with two features

False written accusations not made public - is there law to cover this?

How do you funnel food off a cutting board?

Why is working on the same position for more than 15 years not a red flag?

How much mayhem could I cause as a sentient fish?

Is there a weight limit to Feather Fall?

SQL Split Address Line into Separate Columns

0

Whats the best way to split a comma list column into different columns? I am looking for a simple algorithm, heard it is best to avoid scalar value functions, as they might be slow. Searching into many methods, substring, find, splitstring; we need to run this algorithm across millions of addresses, so looking for best, optimal answer with good coding practice.

create table dbo.AddressTest (AddressLine varchar(255))



insert into dbo.AddressTest (AddressLine) 

values ('123 Maple Street, Austin, Texas, 78653, 555-234-4589')



-- may not require substring, just looking for good way

select 

    substring  as AddressStreet   -- Expected: 123 Maple Street

    substring(...) as City,       -- Expected: Austin

    substring(...) as State,     -- Expected: Texas

    substring(...) as ZipCode     -- Expected: 78653

    substring(...) as PhoneNumber -- Expected: 555-234-4589

from dbo.AddressTest

sql-server sql-server-2016 query substring string-splitting

share

asked 3 mins ago

GregThomas582GregThomas582

354

add a comment | 

0

Whats the best way to split a comma list column into different columns? I am looking for a simple algorithm, heard it is best to avoid scalar value functions, as they might be slow. Searching into many methods, substring, find, splitstring; we need to run this algorithm across millions of addresses, so looking for best, optimal answer with good coding practice.

create table dbo.AddressTest (AddressLine varchar(255))



insert into dbo.AddressTest (AddressLine) 

values ('123 Maple Street, Austin, Texas, 78653, 555-234-4589')



-- may not require substring, just looking for good way

select 

    substring  as AddressStreet   -- Expected: 123 Maple Street

    substring(...) as City,       -- Expected: Austin

    substring(...) as State,     -- Expected: Texas

    substring(...) as ZipCode     -- Expected: 78653

    substring(...) as PhoneNumber -- Expected: 555-234-4589

from dbo.AddressTest

sql-server sql-server-2016 query substring string-splitting

share

asked 3 mins ago

GregThomas582GregThomas582

354

add a comment | 

Whats the best way to split a comma list column into different columns? I am looking for a simple algorithm, heard it is best to avoid scalar value functions, as they might be slow. Searching into many methods, substring, find, splitstring; we need to run this algorithm across millions of addresses, so looking for best, optimal answer with good coding practice.

create table dbo.AddressTest (AddressLine varchar(255))



insert into dbo.AddressTest (AddressLine) 

values ('123 Maple Street, Austin, Texas, 78653, 555-234-4589')



-- may not require substring, just looking for good way

select 

    substring  as AddressStreet   -- Expected: 123 Maple Street

    substring(...) as City,       -- Expected: Austin

    substring(...) as State,     -- Expected: Texas

    substring(...) as ZipCode     -- Expected: 78653

    substring(...) as PhoneNumber -- Expected: 555-234-4589

from dbo.AddressTest

sql-server sql-server-2016 query substring string-splitting

share

asked 3 mins ago

GregThomas582GregThomas582

354

create table dbo.AddressTest (AddressLine varchar(255))



insert into dbo.AddressTest (AddressLine) 

values ('123 Maple Street, Austin, Texas, 78653, 555-234-4589')



-- may not require substring, just looking for good way

select 

    substring  as AddressStreet   -- Expected: 123 Maple Street

    substring(...) as City,       -- Expected: Austin

    substring(...) as State,     -- Expected: Texas

    substring(...) as ZipCode     -- Expected: 78653

    substring(...) as PhoneNumber -- Expected: 555-234-4589

from dbo.AddressTest

share

asked 3 mins ago

GregThomas582GregThomas582

354

share

asked 3 mins ago

GregThomas582GregThomas582

354

asked 3 mins ago

GregThomas582GregThomas582

354

asked 3 mins ago

GregThomas582GregThomas582

354