I wouldn't bother with the current design and start from scratch: what are the input tables and values and what is the expected result.

Don't worry about the current DTS design...

One option:

Determine the condition when the 3min-sproc needs to be called either within your 2se-sproc or in the next step in the job agent. Based on that condition fire a...

Nice solution, Matt!!

Much cleaner code thant the FOR XML EXPLICIT stuff...

Maybe you can use SOUNDEX or DIFFERENCE to find similar rows. But I guess you'd manually need to verify the results, since there is no logic know of that...

Ok, I'll give you something to start with:

The two separate statements

SELECT @SUCCESSCOUNT = COUNT(CALLOUTCOME)

FROM OBD_CALLACTIVITY

WHERE CAMPAIGNID = @CAMPAIGNID

SELECT @VOICEOUTCOMECOUNT = COUNT(CALLOUTCOME)

FROM OBD_CALLACTIVITY

WHERE CAMPAIGNID = @CAMPAIGNID

...

Would you mind sharing a sample file that shows the problem you're stuck with?

First thing to notie: normalize your table.

There is no need to put AccountName in your Accounts table.

In order to get the hierarchy tree you should try to follow the example...

duplicate post.

Please continue discussion here.

Ok, the easy stuff first: OP = original poster = the person who started the related thread (in this case: you). That's not a dumb question at all!, since it...

If you create/modify tables but you don't know how to design a database I'd expect there is someone in your team doing the design job. Maybe you should ask that...

First of all: THANK YOU for providing perfectly formatted test data! Awesome job! 😀

And here's what I came up with (as far as I can se it'll return your expected...

Nice screen shots! Seems like you put quite some effort into it...

Unfortunately, that's not even close to what the article I mentioned describes as "ready to use data"... :crying:

Again, please...

You might want to have a look at the Tallytable article referenced in my signature. Part of it as a split string version that will outperform your loop in most...

Would you please provide table definition and some sample data in a ready to use format as described in the first link in my signature?

By doing so you would give...

Not that i know of.

But there are several alternatives:

select * from my table

where filed like '%papper%'

or filed like '%pen%'

or using a split function to...