Have you deployed a shared datasource?  If not you can create the datasource in Report Manager under report properties->datasource.

I thought something like that might be te case so having an audit table that you are inserting into can really give you a history of what is going on...

Is there anything in the table to differentiate the records?  Why do you need to move the data to other tables?

What are doing with @msg after it is set?  Because as noel said what you are doing a=only works for single row updates.  IF you are logging the action in a...

Typo on my part down in the delete satement.  It says @deletesconsumerid instead of @deleteconsumerid.

My guess is that you should have:

rollback tran

Set @result = -1

In that order.  I did not see the Set so I do not know how oyou were successfully creating...

An insert, update trigger using charindex or patindex will work.

I have never tried what you are trying.  I usually explicitly create temp tables in my sp's because it helps reduce compiles.  What is the point of adding the new...

How about:

Declare @deleteconsumerid table (pk int identity(1,1), cons_id Int), @rows Int

Set @rows = 1000

While (Select count(*) From @deleteconsumerid) > 0

Begin

delete A from con.dbo.acct A Join @deletesconsumerid D On A.consumer_id = D.cons_id...

I have encountered the same issue with sp's in RS.  I do not use the wizard.  In the generic query designer I type in the sp name, rptDailyCumulativeProdSummaryByBussUnit

I encountered the same problem.  In order to create asubscription you need to go to the report and the properties tab -> data sources. Selct use a custom data source and...

Since, according to Lee, the book was not very good and Amazon had a problem and could not ship the book until April 26th I cancelled.  I have since figured...

If you can see the blocks you can run run DBCC InputBuffer(@spid) to see what command is running for that spid.  You should also run sp_lock @spid where @spid ifs...

You could save yourself a lot of heartache if you put a unique index (constraint) on team_id, player_id and season_id then you could not insert duplicates without an error.

In sql server triggers fire for a statement.  Meaning that if you insert 10 rows in a single sattement the inserted table contains 10 rows.  I am not sure what...