Check your dmv's for missing indexes.

What I generally do is to add a parameter to the procedure:

@debug tinyint = 0

Then, within the code, do things like:

if @debug > 0 select ....

if @debug > 1 select...

Bezan (9/2/2010)

---

Problems/to do:

- with more periods (>10) there is complete mess .... why?

- another test: periodlength = 30 ... also totally different results... why?

- have to figure out better way...

Bezan (9/2/2010)

---

Problems/to do:

- have to figure out better way of getting numbers 1,2,3,4,... than as it is now from table

- Comumns name like 1-7 8-14 not...

So true. Interviews is one of those things that I'm always a little bit...

One thing that can be done...

I would suggest you read this article Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays[/url]

simflex-897410 (9/1/2010)

---

I have a quick question Wayne.

Why didn't I just do that for only name since that's the only one we are interested in displaying first value only while leaving...

Probably the easiest way would be for you to use the import wizard (right-click the database | Tasks | Import data). For the data source, select "Excel Source", and follow...

Neither SSIS nor the OpenRowset/OpenDatasource functions can do this... they all use the JET database engine, and all they do is manipulate data (insert, update, delete, select).

To do formatting, you...

Craig Farrell (9/1/2010)

---

True, but neither does the mm one, just gotta deal with that...

I guess that would depend on the size of the drives. On the systems that we were getting just a couple of years ago, we were putting the binaries on...

Craig Farrell (9/1/2010)

---

Nasty. Alright, quick fix. First, back...

Craig Farrell (9/1/2010)

---

Hm, that tally table looks interesting, and I'll explore it more shortly, I'm not immediately familiar with it. The crossjoin computations seems like it takes a lot...

Okay Craig, how's this?

declare @DateToCheckAgainst datetime;

--SET @DateToCheckAgainst = DateAdd(day, DateDiff(day, 0, GetDate()), 0);

SET @DateToCheckAgainst = '20100822';

SELECT repeatID,

BeginDate,

...