I would be wary of a design like that. How would you deny update/delete on a table if you had all of your stored procedures like that? If they...

<zing!>

Sorry, missed that COMPLETELY.

Save yourself the headache. Store the dates as dates, not as two columns with numbers. Then you can do date math really easily, index columns and all that....

What are you trying to do? Filter the report so they only see the records they want? That's pretty easy.

Or are you trying to make the fields in your...

Not near enough information to help.

What does the signature of the stored procedure form Oracle look like?

storedproc_name

@param1 <datatype>,

@param2 <datatype>

If the stored procedure already has paramters, are you trying to use...

By far the easiest way of dealing with stuff like this is by using a Calendar table. Then you can get ANY day of ANY week...

SELECT ..

FROM CalendarTable

WHERE WeekNumber...

Why not just cascade the parameters?

First one is Elementary/Middle/High School

Second filters based on that.

SELECT Grade FROM src WHERE Level = @Parameters!Level

Think if it this way:

T-SQL does all the data manipulation

VBA does the front end stuff (if you're using something like an Access FE and a SQL Server BE) -- pretty...

Not sure if it's possible, but one way might be to use an ADO connection from inside Excel to push the results to SQL Server...

This looks like a pretty good answer:

https://answers.laserfiche.com/questions/48435/SQL-Transaction-Log-is-taking-up-all-drive-space

Then read Gail's articles:

http://www.sqlservercentral.com/articles/64582/

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

John,

Any chance you can upload a copy of your report? The fun part is that you have to provide some data for it. So you have two options:

1....

If you're using a matrix, you need at least one Row Group and one Column Group as well as one Aggregate...

So... this worked for me:

Row Groups: [PeriodEnd] (or the date...

Might sound like a dumb question, but what happens if you add a table to the report and drop the fields into a tablix but don't filter it. Just...

Okay, I was going to use a Calendar table to force the dates to exist. DAX is just still kind of mind-boggling.

I figured out the solution after the...

Not much for details. BOL (Books On Line... hiding under the F1 key) is your friend. Check out this article on CHARINDEX. It should get you started. ...