If you will look at my script, I have identified all records from a field in a table that have character 128 and above.  I did not know what you...

I included a $ column since you sounded as if you wanted the top 10 customers, I assumed you meant in purchasing... You could simply insert these into a #TempTable...

If you do not want to use the Enterprise Manager, you can try with Access.  But I had a client that used MSDE for field operations and I really prefered...

oops... should have been IF @TempValue > 128

Sorry...

I used to need to strip Alpha-numerics from a certain field.  I have changed it to try and fit your needs.  Hope it works...

SET NOCOUNT ON

DECLARE @CurrentID int,...

If I am understanding this correctly, basically want the Client Number, name, etc., and the various money's (sales and commission amounts) printed out. 

Then you want to add the various...

Thanks.  I have some time on this one and these suggestions will really help me plan out my approach - I imagine I will find a number of sprocs with...

A good while ago, we had a middle ware that would goof with the server.  Might that be an issue? 

Thank you Steve. 

Sort of...  Basically, the variables are populated outside the stored procedure (seven possible strings are put into the @Variables).  Because this system has changed over time, they...

Thanks - I kinda wish I could delete my posting so I do not waste people's time when I figure out an approach. 

Your URL is in German.  Do you know...

Do you always want the "last" entry into the Customer Info table for that CustID?  (any dates or other data in the Customer Info table you could use?) 

I asked about the blocking in another forum earlier today and was told that was a 6.5 version problem and has since been fixed. 

Another issue to consider is the...

I am shooting in the breeze here, but it looks like you are using Views and not actual tables.  Dynamic SQL cannot generate a plan in the SQL Server, that...

Sometimes it helps to be more explicit.  Try the following: 

SELECT @zipcodeEXIST = (SELECT zipcode FROM invalidziplist WHERE zipcode = @zipcode)

SELECT @weekInfo = (SELECT week FROM invalidziplist WHERE zipcode = @zipcode)

You can also try:...

If you can, name your Transaction. 

BEGIN TRANSACTION InsertTableName