Even if the format is NOT fixed, you can use the Tally Table-based string splitter function from this very site (authored by Jeff Moden in an Article with a...

• This reply was modified 5 years, 2 months ago by Eirikur Eiriksson.

Just wanted to reiterate my initial question to the OP, is the format fixed?

😎

The reason for asking is that if the format is fixed, one can easily half the work...

I can see where this is going;)

😎

Hi all,

I have some data which is provided, unfortunately I have no control over the format.

One crazy column contains some data i need to split into two columns, i...

Honestly, this is why I personally find it easier to just store anything in UTC if I'm ever working with time sensitive data, or multiple timezones (and I include...

So, it uses the same kind of lookup table but stored in Windows Registry.

Not sure how gods is it in terms of performance, but it does not eliminate the...

As of 2020-09-25 16:42 BST, you owe me a keyboard!

😎

Should have learned to have...

"How do you get the current date and time using T-SQL question that 20 out of 22 candidates couldn't answer before I stopped counting.  It's NOT a...

• This reply was modified 5 years, 2 months ago by Eirikur Eiriksson.

Thank you for posting...

What is the minimal way to create a tally table/tvf/cte and to describe its advantages (if any) versus recursive cte's?  For the past several weeks I've observed most (all)...

This is an illustration, not real code. Presumably, you might have lots of other code that checks for the need to rollback.

However, I'm not sure SET and SELECT impact...

Hi inayatkhan,

and thank you for providing the data and the results for your question,  much appreciated!

😎

Unfortunately, I'm struggling with the logic as nothing is inserted into the #Summary table? Can...

Thanks Steve, good question.

My take on it is that "begin tran --- rollback" = "Oops"

😎

On a more serious note, many do not understand the difference between SET and SELECT in...

• This reply was modified 5 years, 3 months ago by Eirikur Eiriksson.

My guess is that "if at one stop i have more than one address then i have siblings" is lost in translation, and I think you need to read...

OK the thing behind it is COVID-19.

The customers are students boarding a bus so if at one stop i have more than one address then i have siblings and...