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...

Glad you have a working solution, although I think I might have approached this differently. I would have written code to create a single result set that has...

More "harmony" at work:

INPUT LENGTH IS KEY

TO COALESCE WITH ADMIN;

BEGIN FILLFACTOR

INSERT WITH ADMIN

NOT HAVING SOME CHARACTER;

CREATE ESCAPE PLAN

PLAN TO USE ROLLBACK

WHEN HAVING ADMIN NOT WITH

CHARACTER VALUES

Steve

(aka smunson)

:D:D:D

I'd be more concerned about the "can" influence, which might lead to this kind of thinking:

IF BACKUP EXISTS

TRIGGER DUMP PROCEDURE BY

ORDER OF USER

IF BACKUP EXISTS

TRIGGER DUMP PROCEDURE WITH

CHECK FOR DOUBLE...

"Do" is nothing more than another version of "While". Neither of them require any tie to a recordset - there are no such restrictions on their use.

Steve

(aka smunson)

:):):)

I'm going to suggest along another an entirely different line of thought. What reason do you have for aggregating all the e-mail addresses into a single line? ...