To get the best help possible from this forum (or any other) please read and follow the instructions in the first article I have referenced below in my signature block...

Hate to burst my own bubble, but there is a bug in my code. The code as posted will only work if there is no gap in the first...

Two more options. Option 2 allows you to use the function in a CROSS APPLY in a query instead of using the Scalar UDF in the select part of...

Sounds like a bad cached plan. Try adding the WITH RECOMPILE option to the store procedure.

Please read the second article in my signature block below regard getting help with performance problems (or something to that effect). It will show you what you need to...

Interesting. Here is code where I have an input parameter defined...

You need to determine what the results should be and provide that. This is used to test our results as well as to understand the process that needs to...

Please read the first article I reference below in my signature block regarding asking for help. Follow those instructions in what you should post to get the best help...

PSB (1/27/2011)

---

If I use this string below

DECLARE @TestStr VARCHAR(MAX)

SET @TestStr=' 5305 ...

Duplicate post, please post all replies here.

Please, do not cross post as it simply fragments any responses you may get, and people may duplicate others answers.

Duplicate post, please post all replies here.

Please, do not cross post as it simply fragments any responses you may get, and people may duplicate others answers.

Based on what you have provided, here is what I came up with to solve your problem.

--drop table #temp

create table #TimeTemp(

...

Does this help you get started?

declare @TestDate date;

set @TestDate = '20110401';

select @TestDate, DATEADD(mm,9,@TestDate), CAST(year(DATEADD(mm,9,@TestDate)) - 1 as VARCHAR) + '/' + RIGHT(CAST(year(DATEADD(mm,9,@TestDate)) as VARCHAR),2);

set @TestDate = '20120331';

select @TestDate, DATEADD(mm,9,@TestDate), CAST(year(DATEADD(mm,9,@TestDate))...

jbon007 (1/27/2011)

---

Hi all,

i have this function which is not fully working. what it does is look at the date and work out our financial year. (financial year is from 1...

Still missing the expected results based on the sample data. If everything runs correctly, what should the data look like?