Yes - you'll need an enumerator. Most likely - you'll need an ADO enumerator.

Rough steps:

1. set up a package-level variable to type object (for this we will call it...

Might be worth making sure you're even getting to that part of the code. Sometimes code gets complicated enough that the branching you THINK is happening, isn't happening the...

There are lots of cases where SSRS doesn't care or acknowledge the order in the sp. IF you want the report sorted you need to set the ordering in...

marcia.j.wilson (6/29/2014)

---

Jeff Oresik (6/28/2014)

---

I wouldn't take "my" data to mean at the exclusion of others. It is a declaration of ownership, but usually in the context of taking responsibility for...

Building off of Sean's idea - this gives you the same functionality with up to 6 words

Note: since the number of permutations will grow factorially as you expand the number...

carrieathomer (6/27/2014)

---

Matt Miller (#4) (6/27/2014)

---

A tally table - whether a physical one or one that you would build on the fly using ROW_NUMBER() - can churn through 1M records in...

A tally table - whether a physical one or one that you would build on the fly using ROW_NUMBER() - can churn through 1M records in under 2 seconds. ...

You probably want to split this into two different exercises. First extract the column name and values, and then use a dynamic pivot table to rebuild your rows.

The Dynamic...

Sometimes a little test helps to clear things up. The indexing does seem to help, so the trade-off is whether the improvement is enough to offset the creation of...

No - just the opposite. Sorry if I was unclear, but just like Sean demonstrated - it works just fine...

The intersect syntax looks correct. I mocked up the same syntax on a few tables here and the query does work as written.

Roust_m (5/26/2014)

---

Hi,

I have a query, which eats massive amounts of CPU because of a CLR function, which deals with local time (our server system time (US) is different from local...

Have you tried look at the profiler session of the parameters being passed in? Also - have you made sure that there is in fact only ONE stored proc...

This may be unwinding your multiple tables join, but the easiest way is to create sub-queries by level.

Something like this:

;with fun as (

select 'UG1' as UserGroup, 'Tom' as UserName union...

I have not dealt with Sabio, so I cannot weigh in on them.

Again I didn't want to scare you away from the org per se. It's just that the...