Try putting the objects into a Rectangle. The Rectangle object will keep items together where you put them. Usually. 😛

It would probably be best to let the query filter the data by passing the parameters to the query, as such:

select * from tblA where YourDateField >= @DateMin and YourDateField...

Whenever a date is dropped into Excel from SQL it is in the full date format. You'll want to cast or convert the datetime column in your query. ...

Lol. The right "stuff". You made a punny. 😛

Excellent point and good teaching.

Love the name, Mr. Pants.

This is a great place to be. I spend whatever free time I have during the day reading through the forums. There are some mighty talented folks here...

Also - stored procedures typically provide better maintainability and reusability

The sub-report should also work. Like most anything with sql there are several ways to get there. The trick is picking the most efficient route.

I'm kind of guessing as I've not worked much with SSIS yet... but in the olden days of DTS, the package ownership was assigned to whoever created it, and you...

Unfortunately only one dataset per data region (table/matrix). You might be able to get the results you want by combining the datasets into one and using the grouping properties...

Are you trying to export to excel by chance? you will get this error when you have > 64k rows. Try to export as csv.

Thanks! Very helpful. I made myself a Word version. It's attached if anyone wants it.

Transmogrification

freshman fifteen

create table #Student (

student_code char(1) not null,

stud_act_id int null,

fee decimal(19,4) null,

discount_rate decimal(19,4) null

)

insert into #Student

select 'A', 52165, 200, 60 union all

select 'A', 54902, 300, 50...