quote:

---

'I know what you're thinking. Did he fire six shots or only five? Well, to tell you the truth, in all this...

Hi Tim,

never mind! Let's forget it

Cheers,

Frank

Hi Mandar,

quote:

---

Does sql Stores this in any global variable (may be similar to way it stores the value of the Identity Column.)...

Forgot to post the example. This might also give you the idea how to get the old and new value from deleted and inserted tables

CREATE TRIGGER...

Hi Gerry,

quote:

---

So I can determine the column, but now I need to determine the value.

..

It works, but I wonder if there...

Hi Esal,

maybe this threads will help you

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=13310

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=13473

Good luck!

Cheers,

Frank

Hi Dale,

quote:

---

OK. Wait a minute! I must clear something up. I said that Frank was a Cyber Geek and...

quote:

---

Hrmmm.. In none of the examples did I see an actual zero, other than the leading zeros. Why not just do...

Hi Zambrtp,

quote:

---

that is not a double quote in front of dog its two single ticks...

I dont want the tick at the end...

Hi CarKnee,

you've already seem to have found a solution.

What about REPLACE (your_column, 'ed','',1) and CAST this as int?

Haven't tried this here at home, but when it works, it should be...

quote:

---

Here is how the insert ends up looking because the @parameter passes the data to the dynamic insert statement..

Insert into table ('col',...

quote:

---

this should do it:

cast(left(annoying_column,patindex('%ed%',annoying_column) - 1) as integer)

you can either cast the other column as an integer, or throw another cast...

quote:

---

Would that always insert a tick ....this has only occurred once so far...if it always inserts a tick then the data would...

Hi ilan,

quote:

---

NO

i test the tow possibility

and still a gen an error

---------------

when i do this

set @recipient='select @pstrNames'

OR

this

select @recipient='select @pstrNames'

i...

Hi Zambrtp,

quote:

---

Would that always insert a tick ....this has only occurred once so far...if it always inserts a tick then the data...