query the database size, insert into table with timestamp... I know there are examples around here somewhere. Search around.

Thanks for the explanation... Helps a lot! Is this what you were looking for?

SELECT Account

, MonthsBetweenRuns

, DDCycle

, Num

FROM tblDDAccounts A CROSS JOIN Tally T

WHERE Num % MonthsBetweenRuns = 0;

Note,...

Ouch. Explain what you're trying to accomplish. You can probably do this with a Tally or "numbers" table and a simple query.

/* remove City and State from the Address */

SELECT Address

, LEFT(Address,CHARINDEX(',',Address,1)-1) AS StreetAddr

, RIGHT(Address,2) AS AddrState

FROM Address1;

What if you use a Calendar table?

full weeks since when? the first of the year?

Maybe Lynn Pettis' article will help:

http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

I would probably start with Dwain Camps' article here:

http://www.sqlservercentral.com/articles/String+Manipulation/94365/

I might go about it by writing all the locations (use CharIndex) of a string to a temp table and then doing...

STDistance returns the straight line distance between two points (as the crow flies). GoogleMaps determines the distance by the sum of the lengths of sections of roads traveled on....

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