My first question would be why you have a column that's defined as an incrementing number, and the data type is char(10).

Second, what do you get if you select from...

All the proc does is populate a temp table, then run that sp_transform proc.

This means that there are three things that could be slow:

1. The view

2. Creating the...

That's why my version of the trigger is "For Update", not "Instead of Update". That's one of the key differences.

Well, for code objects, you could select from sys.sql_modules. That'll get you procs, views and functions. For tables, you'd need to select from sys.columns, and a variety of...

If you have a Numbers table (Tally table, Sequence table), it's easy:

select dateadd(day, number-1, '9/1/2009')

from dbo.Numbers

where number <= datediff(day, '9/1/2009', dateadd(month, 1, '9/1/2009'));

If you don't have a Numbers table, and...

gboyer (9/4/2009)

---

It looks to me as if he is trying to replace the zeroes with a space and then trim off the space and then replace the space with a...

Doesn't matter if the DML has the ID column in it or not. Triggers have two "tables", one called "inserted", one called "deleted". The inserted one is a...

Try this:

CREATE TRIGGER trg_UpdateDateModified

ON Employees

FOR UPDATE

AS

UPDATE Employees

SET DateModified = getdate()

FROM Employees

INNER JOIN inserted

on Employees.ID = inserted.ID;

I'm assuming the existence of an ID column in the Employees...

Good that you solved it.

It's probably a minor difference in the way the engine code was written for selects vs for deletes. But that's just me guessing. You...

If the dynamically created table is a persistent table, not a temp table, you could export it to csv pretty easily with bcp.

If you don't want to keep the table,...

It looks, from your example, like @name is supposed to have two different values. Is that what you're trying to accomplish?

If you just want to get rid of the trailing zeroes from a number, you can reverse it, cast that as an Int, cast back to varchar and re-reverse.

Is that...

I'd have to know what sp_transform does to even begin debug this.

Have you tried running the sub-selects separately to see what you get from those?

Lysdexia is jo...