Here are some examples on how to do it with the DelimitedSplit8k. The function code and explanation can be found in the following article: http://www.sqlservercentral.com/articles/Tally+Table/72993/

SELECT LEFT(Item, CHARINDEX('.', Item)),

...

Now, the question would be, do you understand it?

Remember that you'll be the one supporting it. Feel free to ask any questions that you have.

Thank you for the feedback. 😉

Do you need more help with this?

If so, could you post sample data and expected results?

I don't have sample data to test, but this might help you.

WITH AvailableDates AS(

SELECT customer_id,

order_date,

...

Do you need something like this?

DECLARE @Team nvarchar(255) = 'TeamA';

WITH Winners AS(

SELECT *,

CASE WHEN Home_Score...

It seems that you have a poor design and that's making everyone confused. You should review what's going on here.

That said, this might help you:

CREATE TABLE SampleData(

...

Note that those functions aren't intended for multi-character delimiters.

Can you post an example of what you mean by empty last Column?

Is it something like this?

Column1,Column2,Column3

1,Something,

2,Sometext,

Or like this?

Column1,Column2,Column3

1,Something

2,Sometext

I forgot to include the safety net. 😉

SELECT string, RIGHT( string, CHARINDEX( '/', REVERSE('/' + string)) - 1)

FROM (VALUES('/Product_Images/small/1/10032.png'), ('JustImage.png'))x(string)

This might help.

SELECT string, RIGHT( string, CHARINDEX( '/', REVERSE(string)) - 1)

FROM (VALUES('/Product_Images/small/1/10032.png'))x(string)

There's a BULK INSERT command in SQL Server. You can read about it in here: http://msdn.microsoft.com/en-us/library/ms188365.aspx

To add functionality using format files, you can read the following article:

http://www.sqlservercentral.com/articles/BCP+(Bulk+Copy+Program)/105867/

Are you sure that you're using the same view and not different views with the same name and different schema? Is it possible that the information changed between each query?...

And what do those values mean?...

Based on the value 735510.40461, what are you expecting to get?