Yes, DelimitedSplit8K is miraculously optimized for VARCHAR(8000). It runs very fast!

Hi Jeff - Sorry those things are not pairs/dont increment by one. I just made that example in excel.

Yes, I have tried it. I have observed performance degradation. Query runs much slower with VARCHAR(MAX).

Hi - the solution works as expected. Is there anyway to increase the size of the input string to 100,000. Its only limited to 8,000.

Thanks much!

Awesome .. thanks!!

Thanks Cadavre. This is cool stuff.

Can your code take two row terminators? pipe (|) and line break ()?

Example data:

field1;field2|

30;38469|

31;38469|

32;38469|

33;38469|

34;38469|

I didn't notice the line break in the original data. Very sorry.

The...

Thanks Cadavre. This little too complicated for a newbie. But I'll go through the code and understand the beauty of it. Appreciate your quick reply.

Thanks much, nigelrivett .. this is a great help! I could understand the code. Really appreciate it.

Thanks Lowell. Pretty intuitive code. It worked on the example I sent. I will test it and tweak it if needed.

Thanks again! Much appreciated.

BTW, select DATEDIFF(d, '20110101', '20110103') returns 2,...

Thanks for your reply. Sorry for not being clear.

The function is supposed to calculate the fiscal days in a fiscal year (fiscal year is supplied). The fiscal year starts on...

Thanks LutsM!

The start date, end date are two fields in the same table.

Lets say sku, start_date, end_date are in table t1.

I am looking for something like:

select a.*, dbo.fiscal_days(2006, a.start_date,...

I am using the GUI method: Right Click Databases - Attach etc.

While installing I added myself as admin .. is there a way to check out my user privileges?

Thanks!