If your trigger is For Update, Insert

there is not any system information identifying what action caused the trigger to fire.

You could duplicate your code, and create 1 trigger for...

can you post the string that is being executed?

Your not constructing your dynamic sql correctly.

if you want to pass parameters into dynamic sql, then you MUST use sp_executesql. the EXEC function does not except parameters.

If you do...

Your desire to find companies within a certain distance of a given point is fairly simple on the surface,

Your function is not correct tho. (I did not check your...

Would this work?

SELECT SUBSTRING(PK, Charindex('=',PK)+1 , (len(PK)-1)) FROM audit

or you could wrap a replace..

SELECT replace(SUBSTRING(PK, Charindex('=',PK)+1 , len(PK)),'>','') FROM audit

What do you mean based off Previous AchieveLevel?

Your talking about comparing values from two different rows?

Please post sample data and desired output so we can see what your looking for..

Thx

😎

There is no need/ way to integrate stored procedures with a trigger.

For triggers you gain access to 2 virtual tables called "Inserted" and "Deleted"

Inserted holds the data that is being...

What data type is the code column in your emp table?

Please Post table definition.

It is likely your code table is an int.

Try

Select jobid As job,

CASE WHEN code in ('1','2','3') THEN...

Richard Sabbara (10/6/2006)

---

I need a quick on line refresher on Indexing, any idea where I can go? I finally have a need to build an index, just don't remember some...

I am assuming your talking about reporting services.

If not, please post and let us know.

Give this article a read

http://www.sqlservercentral.com/articles/Development/reportingservicesconditionalformatting/1423/

Or this

http://msdn2.microsoft.com/en-us/library/ms345242.aspx

:D, Just playin about the cursor,

I don't think the error your getting has to do with the open query query, its coming from somewhere in the string.

Either your string...

select A.*

from BaseOutlet A

join (select CaseId, OUTL_ID, MKT_ID, max(cast(TAC_ID as tinyint)) as TAC_ID

from BaseOutlet

group by CaseId, OUTL_ID,...

If you have reporting services running, it is a good solution to do this.

Thats what I Have done in this scenario

What size are your @SqlString parameters declared as?

Try printing the @SQLString

Print @SQLString and in the messages tab, copy and paste that into a new window and see if you can...

select distinct top 10 CNO

from MyTable