Just go to the Line 155 of Procedure axspRSTOCKLEDGERREPORT as indicated by the error message.

Somewhere in that area is either a LEFT or SUBSTRING function (also mentioned in the error...

please provide table def and sample data in a ready to use format as described in the first link in my signature.

You might also want to have a look at...

to add what Lowell already stated:

set @sh_act_*, set @sh_plan_* and set @proposal_* logic queries the related table once per column to be selected. This should be done with a single...

May I ask what the purose of this request is?

Different "paths" may lead to different result (e.g. duplicate rows of the target table due to a 1:n relationship somewhere in...

I guess you're missing the "aggregated result" you mentioned in your comment.

There's not much more to say unless we have table def and sample data for the tables involved together...

Ok, this is the link where it's been mentioned that the app available on the web has been incorporated into SS2K8:

http://www.sqlskills.com/blogs/bobb/post/A-supported-Service-Broker-external-activator.aspx

The link also include a link to the original 2005...

Are you sure your ODBC connection points to the very same database as you're looking at with SSMS? I'd compare the connectiong string and the SSMS database location.

Great article, Dave! Very well done!

I can't really give you an example but you might find a solution on the web when searching for "SQL Server 2005 External activation".

I'm not sure if the SQL 2008...

What values do you expect to receive when running a query against that column, let's say now and 6 month from now?

Your computed column definition is based on getdate() so...

Another option would be to fire a ServiceBroker message using the trigger.

This will separate the two processes ad still provide (almost) real time processing.

We've had the once-per-minute-job approach installed for...

The code seems to be based on the BOL example A for "CREATE FUNCTION".

In the original code, the function itself is called inside the function.

In your case this would be...

There might be an option to tune your query and or the indexes involved.

Is there any chance you could provide some ready to use table def (including indexes) and sample...

Just to make sure I understand it correctly:

DBADMINS (like you) are not available 24/7, but developers are????

In that case there seems be a lot more to be fixed than the...

pujain (6/27/2011)

---

yes thats correct, we are planning to give access to some database programmer to update production data but still want to be safe (if they forget to put where...