Are all the procs in the same schema? The easiest way to fix this is to set GRANT Execute On SCHEMA :: [schema_name] to [principal_name].

The way I am reading the procedure you are only processing zip codes for TX, FL, and LA. Is this what you want? If so there are a...

Login to the server. Access to the database with Select only on those 4 tables.

Jeff Moden (7/21/2008)

---

Jack... after you get done building it, change all the Addresses to 0 for...

The toolman has that right. You could even compile that into a DLL, in which you would have other commonly used custom functions in SSRS, and reference the DLL...

kenksoftware (7/22/2008)

---

So you can see right off that I have my work cut out for me. So step 1 should be for me to convince them to store the...

Duh! That's what I get for ASSuming that the variable name and column names are consistent.

No you do not because of the FULL OUTER JOIN between the inserted and deleted tables. Notice he is using the CASE statement to determine if it is an...

I actually just re-read an article today that recommends using JOINS instead of subqueries. Here is the link, http://www.builderau.com.au/program/sqlserver/soa/Optimise-SQL-Server-queries-with-these-advanced-tuning-techniques/0,339028455,339283995,00.htm

You can actually eliminate the reference to the tblUsers table altogether...

Are you using a select nvarchar(max) in SSMS to try to debug/check the dynamic sql string? Perhaps the UI Is truncating it.

Yeah it definitely would be hard to maintain when you make schema changes.

I need to evaluate the logging I was planning, although I and my co-worker were going...

Have you checked for blocking while the long query is running? I know you said that your interactive queries are the only things running, but I can't think of...

The code you have posted looks like it should work to avoid the divide by 0 error. Are you sure you are always getting a value in the divisor...

GSquared (7/21/2008)

---

Unless you're talking about...

Sure you can make it format better by adding Carriage Returns, Line Feeds, and Tabs. You would do this using the CHAR() function. I believe it is CHAR(10)...