Oh, c'mon... you've been around here long enough to know how to post data. Here's the table/inserts:

CREATE TABLE t1 (

n INT PRIMARY KEY,

note_ID INT,

Note_Serial_Num INT,

NoteStatus TINYINT);

INSERT INTO t1 VALUES...

I don't think certification proves anything at all. I know people who have written books on SQL Server, are MVPs, and don't have a single certification. My certs are...

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?