I just tested Ryan Randall's code on SQL 2005, and it appears to work just fine. Is there some issue with it?

Steve

(aka smunson)

:):):)

Sounds like you haven't populated your tally table. Try my code using the table variable and see if that helps you. You can adapt it to...

By the way, the execution time on that query, including creating the table variable with the tally numbers, was less than 1 second.

Steve

(aka smunson)

:):):)

It's too late for me to look at it today, but I'll look at it in the morning and see what I can accomplish.

EDIT: Ignore that... I just found my...

You can name it whatever you want. Just remember to edit the name as appropriate when you go in to adapt Jeff's code that references it. ...

Again, you need to look at Jeff Moden's tally table string splitter technique. It's set-based, so you just don't need a cursor for ANY reason. It's a tried...

I'm not talking about the destination column, I'm referring to the source data column, where the original data is coming from. What size and type is that data...

Then the 8000 length you're giving your varchar variable is the limiting factor. As I indicated before, a cursor is a LOUSY way to achieve your objective. ...

You haven't yet answered the questions posed before. A cursor is actually a lousy way to achieve your goal, and it's clear you haven't even made the attempt...

What environment do you wish to achieve this from? I'm reasonably certain that this would be fairly easy from within the VBA code inside of MS Access or...

A couple of things needed to help you....

1.) What result DO you get? It's kind of hard to know where to look for the problem if we don't...

Jereme,

Most of my post was intended at clarifying the details, as many questions were asked that suggested there was confusion. Even one of your posts talks about having...

Actually, the property is the "Hidden" property, and it's within a property group known as Visibility. When set to False, the object IS visible, and when set to...

Based on the OP's (timbw's) request, the timeframe has to be ANY year, so I looked at this problem as the sum within one year of any given order, including...

Isn't the OP looking for the result columns without an actual execution of the SP? Isn't there some kind of option that returns that information without executing the...