repent_kog_is_near (4/1/2011)

---

>>when do you want it to fire and what do you want the fire action to be?

the trigger, ideally, should be fired only when there is a new row...

So it should only fire when it's not...

declare @WSUrid numeric

Why is this ID field a numeric? You have decimal IDs?

set @WSPrice1 = 'Select ISNULL(' + @WSUrnam + ',0) from dbo.productstb where productid = '...

Easy, use the code listed in this post http://www.sqlservercentral.com/Forums/Topic1082905-1292-1.aspx

You mostly have what you need. Put a "Union All" between the selects.

beginner123 (3/23/2011)

---

I have to migrate data into the table which has dependencies. I want to insert data into parent table by using Insert Into command. If I do that will...

Why can't you get the account# you are trying to insert before you insert into table ml? It seems you have all available info needed at point of insert, but...

Whenever you start a trigger out by assigning variables, you've lost. Think about your statement

SELECT @stamp = mlstamp, @cct = RTRIM(cct), @dim1 = RTRIM(dim1), @dim2 = RTRIM(dim2),

@dim3 = RTRIM(dim3), @dim4...

The GO statement marks the end of the batch and will end the procedure. Remove the GO from the middle of your create procedure script.

Yep, this is my new favorite. Thanks Drew.

If this improvement keeps up every post, pretty soon this will be a built-in SS function! Oh wait...:-)

Yep, that may be a little shorter than my version 😉

select * from #test where ' '+col+' ' like '%[!",.'':;? ]rate[!",.'':;? ]%'

Thanks David.

Ok, now I see where my question was silly. It's not comparing '% rate %' to 'rate' because you added the spaces before and after and then did the wildcard...

Perfect, David. Works great, but why does it work? Does SS just ignore...

I must admit I am impressed with the cleverness of your solution...but I have another failed test clause. Insert the word 'substrate' to the #test and your query will select...

Thanks for the quick reply CC, but I don't want to search for the phrase 'rate is 5', I only want results that have the word 'rate'.

Let me add...