This is just to expand your mind to ultra set based approach. This is no novice query .

Hehe. The final explanation has been posted in another thread :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=189202

Btw this is the simple exemple... I was successfull at avoiding the problems with udfs. Long story short is that tables functions have 2 sets of columns in SysColumns....

Where did I lose you?

If you need a suggestion, it would be nice if the report was exported to the server so that we could use your chm file in combinaison of our own...

I never said apex wasn't funny, I just said I was funnier as I can interact with humans...

May I ask how you generate the chm file (if it's not a...

A little clearer but not enough.

Can you post the table definitions, some sample data along with the desired output??

Gonna be much simpler that way.

Hehe, it's not your case YET. Don't forget to think a few years ahead when you design the database. You might get a few surprises if you don't.

I strongly suggest that you don't ignore my questions... It's gonna come byte you in the ass down the line.

Did it start with _wasys??

Those are statistics, there is also another prefix that is used by the index tuning wizard but I forgot it.

Select * from tableA A inner join dbo.TableB B on A.StartDate between B.PeriodStartDate and B.PeriodEndDate

What if the # of weeks is dynamic??

.

... Or just don't restart drinking...

That was implied in the article (rogue parameter giving different results than normal queries).

Nice... is this vb code or tsql??