Please follow the link at the bottom of my signature to find how you can get better and faster answers.

But just for this case:

set dateformat dmy

declare @t table (id int,...

Lowell (3/1/2012)

---

here's just one way to do it;

this strips out every char that is a-z,A-Z and 0-9, leaving, i assume, what would be the word separators, like space, dash,...

There is no way to automaticaly identify such separtors.

You can find all non-letter characters, but SQL will not know for granted that <BR > is a separator, as B &...

What would define as "word separator"?

If you would follow this: http://www.sqlservercentral.com/articles/Best+Practices/61537/

you would already have an answer.

Have you ever heard of JOIN's in SQL?

SELECT s.*

FROM SOP30300 s

JOIN #StatusHistory h ON h.SOPNUMBE =...

We don't know what you're trying, as you did not post your code here.

CAST should work. Check this one:

declare @t table (col1 varchar(5), col2 varchar(5), col3 varchar(5))

insert...

Check my previous post, please. The slowest part of your trigger is using "NOT IN" (for no reason)!

Can you please advise, what have you actually mesured? The time taken...

GilaMonster (3/1/2012)

---

Well, note that with that trigger you're doing more than twice times the work of an update without it and affecting twice the rows, so without the trigger will...

OK, here is one of possible solutions:

--1. create calendar table.

--you can create permanent calendar table

--with all required attributes if you don't have one already

-- the following will generate...

Can you try this:

ALTER TRIGGER [dbo].[TRG_Log_TempSales2_Changes]

ON [dbo].[TempSales2]

AFTERINSERT,

UPDATE,

DELETE

AS

SET NOCOUNT ON;

-------------------- Determine mode

IF EXISTS (SELECT 1 FROM INSERTED)

BEGIN

IF EXISTS (SELECT 1 FROM...

Next time, please post your question as per forum etiquette well described in the link at the bottom of my signature, this will guaranteer faster and better answers.

-- setup your...

Loundy (3/1/2012)

---

I've yet to find a use for triggers if i'm honest (there will be some use for them in the future im sure)

If i'm not mistaken (someone will correct...

Triggers do add some overhead into processing and it's not good idea to put a lot of business logic into triggers.

However, there are some cases where triggers are winners and...

azhar.iqbal499 (2/29/2012)

---

We are using functions for code reuseability in some sps.

So What Should be the exact alternative of functions to make query fast. I have very long queries so...