I'm not sure I understand your question.

stored procedures are normally used as the source for a dataset, which you use in the report.

Once you create your report, you grant users...

Repeat how? Like you don't have LinkChild/LinkMaster set in Access?

Not a clue what you're trying to do. Can you mock it up in Excel and upload a JPG?

This looks like you're building the query in .NET or something....

SELECT ChargeAttribute.Value...

Not enough information to answer very well, but do you have a date or a time dimension/table in your database?

Maybe this article[/url] will help.

It covers creating subscriptions without Enterprise edition.

I think this is what you meant. Your code should be inside the BEGIN/END block, and it wasn't.

CREATE TRIGGER Customers_country_Insert_Update

ON Customers

AFTER INSERT, UPDATE

AS

BEGIN

SET NOCOUNT ON;

UPDATE Customers

SET Country=UPPER(Country)

WHERE CustomerID IN...

Did you look at your transaction log to see what's going on in your database?

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....