Nope. When you use a template, SSRS basically copies the contents of the template to the new file. Old files are not affected.

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