This might help.

http://sqlfool.com/2009/08/find-recently-executed-stored-procedures/

But you could also do something simple like creating a simple logging table (ObjectName, ExecuteDate) and then create another stored procedure to do the insert...

CREATE PROCEDURE

uspLogSprocExecution(

@ObjName)

AS

BEGIN...

Oh, I see now... pity, because as I said, it's simple in SSRS. Did it in about 30 seconds. Normally, you do all the formatting in the front end...

David,

This was really easy in SSRS. Here are the steps:

1. Add a tablix to the report canvas (or whatever it's called).

2. Add Order Qty and Bin Qty to the...

Sorry, can't fix what I can't see, but if you drop a matrix into your report with

ROW Groups: [CustID]

COLUMN Groups: [Year], [Quarter]

Intersection: SUM([Amount])

I think it will do what you want....

Okay, I guess I'll bite...

Can you post some consumable data? here's one way to do it:

SELECT "Glass" AS ItemType ,109.52 AS Weight

UNION ALL

SELECT "Cardboard",55.86

UNION ALL

SELECT "Wood",150.54

UNION ALL...

If you're using pass-through queries, it means that your SQL syntax will work against SQL Server without modification. If not, you may have a lot of work to do...

here's a really article example of creating an XML file...

https://www.simple-talk.com/sql/learn-sql-server/using-the-for-xml-clause-to-return-query-results-as-xml/

Here's a really simple query on a table I had handy...

SELECT CompanyID

, RTRIM(CompanyName) AS CompanyName

, RTRIM(Address) AS StreetAddress

, RTRIM(City)...

I think I understand what you're doing. It sounds like you're trying to use some kind of grouping on states on the X axis... but the design sounds really...

just for grins, can you attach to SQL Server from Access and create a Make Table query to create the columns you need? I'm just wondering because maybe the...

Here's a create table statement and the insert statements to populate your table. The column names are a guess. If they're descriptive, it helps a LOT to explain...

Good to know I got a similar solution...

SELECT SampleDate

, CASE WHEN MONTH(SampleDate)%2=0 THEN SampleDate

ELSE DATEADD(m,-1,SampleDate) END

FROM

(

SELECT CAST('03-25-2014' AS DATE) AS SampleDate

UNION ALL

SELECT CAST('01-01-2014' AS DATE)

) x;

I like the empty Totals row option (hint hint)... see if you can figure that part out. You won't learn anything if you don't try things for yourself.

BTW,...

Is the schedule of sessions relevant? If so, could you post the DDL for the create/insert statements?

You might want to search for Itzik Ben-Gan's "Gaps and Islands" solutions. (His book...

The most flexible way of doing this is to create a Calendar table in your database and populate it. Then you can join in...

Got part of the way there... must have done something silly, because the math looks backwards... I created some sample records to play with... hopefully it's enough.

SELECT EmpID, InOutDate

,MIN(InOutTimeStamp)...