If the positive amounts don't equal the negative amount then nothing happens, those amounts get added to the new table. I want to create a new table with the...

I made an edit...to my original request the positive amount does equal the negative amount and those records get removed.

This worked for me:

USE FSW_NZ_BIS_Sep12_S;

EXECUTE sp_MSforeachtable 'EXECUTE SP_PRGDS [?];';

Thanks!

It runs some stats on the table. The sproc was built by someone else which is no longer with my company.

Sorry, I forgot to specify I only need the units and the amounts. ie

comments:

5321063 HOLLAND BL 90X210 10 Unts ...

Haven't tested it but looks like this is what I need. Thanks!

That's correct.

Sean Lange (2/21/2012)

---

You might want to add an IF EXISTS around both the create and drop statements. The way this is if you run it twice with the same parameter...

I made minor fixes...but worked like a charm! Thanks!

CREATE PROCEDURE dbo.SP_AS_tblEmailHdr_Trig (@UserID as varchar(10))

AS

BEGIN

SET NOCOUNT ON

DECLARE @UserTable AS Varchar(50), @UserTable2 AS Varchar(50)

DECLARE @SQLDROP AS varchar(255), @SQLCREATE AS varchar(max)

DECLARE...

Thanks! I had to make a minor change and this is what worked for me. The only issue is that I linked the table to ms access and...

sorry...i edited my original msg as it was not clearly laid out...

just in case..here it is again:

I have a trigger and I want to kick it off from a stored...

...

How can i execute this in a select statement?

I can use this line below to return the records, but I want to be able to use it in any select...

I want to use this in a query i.e.

Select * from GetClaims 'Audit Number,Audit Year,Claim Number,Claim Key,Client Name,status','''AAFES''','''2010'''

How can I edit my script to do this?

Also, I just turned this into a sproc and I want to allow for multiple AuditYears so how can I change it so that it will accept multiple years? I...