glad the example got you pointed in the right direction; did you run a trace to see exactly what the ERP is doing?

triggers are rarely affected by anything outside of...

As usual, we'd need more info..your current trigger you tried, the CREATE TABLE definition of the table, the Actual "rule" you want to use to calculate the correct price.

here's a...

I'm fiddling with this, and if we have consistent delimiters, it's REALLY easy to pull out with a tally table.

my dilemma is that it looks like multiple passes of updates...

if you are limiting to a single Id, it should be fast...you could convert the textfield to varchar(max) for the query: if it's going to scan all rows for a...

first get everything into a temp table, and make sure you convert to varchar(max)...it's a lot of trouble fiddling with TEXT datatypes.

something simply like SELECT convert(varchar(max),YourTextField) as BetterTextField,* into #tmp...

here's my guess;

as a general rule, an index which uniquely identifies a row is more valueable than an index which shows a value releated accross millions of rows.

assuming your status...

can you provide the CREATE TABLE definition for the table accservcategory ?

I say it all...

change the cd.* to a list of the actual columns desired.

your status, I'm assuming is just one more field based on a case statement; you were not explicit on the...

it's the * for the column list.

there's no problem running that statement all by itself, but if ytry to create a VIEW of it, you'll have problems because the emp_id...

here's some consumable data to help look at the problem.

i think in your example you said one column was c_date, but int he SQL you referenced clocking_date; i added both...

then it is probably owned by a different schema than dbo, and needs to be identified by that.

what is the real, exact error message?

maybe if you have a user named...

if it literally says 'table name' , with a space, you'll need to wrap any name with spaces in double quotes or brackets:

SELECT * from [My Table Name] WHERE [First...

i tried creating a brand new post, and immediately deleting it.

http://www.sqlservercentral.com/Forums/Topic718433-433-1.aspx

i was unable to delete it.

i think if you create a brand new post, you can delete it , but if it's a reply to a post, instant-notification emails might have foreign keys to your...