well you need TextData and DatabaseID so you Know what command was...

i think that without a TRY CATCH, the moment an error is encountered, processing stops, and it never gets to the error handling code;

i've got this example saved in my...

i think the events SQL:BatchCompleted , which catch ad hoc queries, and RPC:Completed, which catches code executes in a procedure or function(is that right) are what i typically use;

I think...

another issue to consider;

avoid updating a static table based on a rollup of other information; use a view instead;

the tables could be out of sync if the process is not...

your issue is you need to update FROM another table...not a real table, but a summary of data in another table;

you didn't provide any details as far as the schema...

no, the TEXT datatype is in the process of being deprecated in favor of the...

pankaj.kuchaliya (9/22/2010)

---

I have one confusion that is "trigger is executed when i insert in " ETL_Update" table . only one row can be inserted in this table at a single...

glad you are getting a handle on it; kudos for posting what you are trying so you can get the proepr kind of help; too often we see folks just...

yep the errors telling you the issue, and it was kind of what i expected.

this value exists in that column:

'Assistant Manager Officials & Managers'

it should be obvious that...

seems like your column EEO1Classification is actually a varchar even though it might contain what seems to be just integers....so you'll have to explicitly convert it to do the sum...

what would happen if your procedure received NULL for either of the two parameters? could it raise an error?

exec [sp_ETL_To_Rpt] @frmdt,@todt

since your trigger says it's also for DELETE, and you...

i use getdate() excluseively; like others havre said, it's been in my repitoir for years, and also because of that datatype where a timestamp is not really a timestamp, but...

ok, this example, based on your provided data seems to work for me;

i'm assuming the discount rates are added to the same table...but i hope it is obvious that a...

interesting wissam;

the excel spreadsheet you receive, does the start and end date apply only to the short term offer? so for one month some rate is slightly cheaper, but the...

i don't think that is true; SQL will simply use only the TCP/IP instead;...