Hi Dennis,

Thanks for clarifying the filestream issue, I did follow this up in the part 1 thread but didn’t here. Oops.

With regard to the functions, you are...

This *may* be more performant

Create proc Search @deparr datetime

as

declare @deparr datetime

Select @deparr = '20110501'

Declare @YearStart datetime

Declare @NextYear datetime

Select @YearStart = DATEADD(yy, DATEDIFF(yy,0,@deparr), 0)

Select @NextYear = dateadd(yy,1,@YearStart)

Select *

...

Hi Jerome,

Glad you enjoyed the series,

I cant confirm right now but im pretty sure the links i gave point to the correct AW database.

It may not of installed correct on...

Something tells me you are not a fan of AdventureWorks Joe 😉

Possibly fulltext indexing would help you.

But your design is wrong , there is no magic bullet for this one.

Please post some sample data for further advice.

Try this article

http://www.sqlservercentral.com/articles/T-SQL/71571/

Thanks all,

Enjoyed doing it, now to find the next set of bad code to write about 🙂

wbrianwhite (6/28/2011)

I just looked at it now that it's up. It uses a temp table and a lot of outer apply functions and multiple CTEs. It is a...

Thanks Gail , I did wonder if the poster read past the first few lines.

Tempted to crank sarcasm up to 11

http://www.sqlservercentral.com/Forums/FindPost1133245.aspx

Best left till the morning it think

Personally i would use a calendar table here.

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Thanks Jason,

It was a long hard slog to get it to this point.

Glad you enjoyed it

FYI : Part 2 is now active here http://www.sqlservercentral.com/articles/T-SQL/73889/

Agreeing with Jeff.

Reseeding is something you should rarely (if ever) need to do.

What are you trying to achieve ?

An identity column automatically increments, can you explain your issue further ?

Did you add the index like i suggested a few days ago ?