Cross post

http://www.sqlservercentral.com/Forums/Topic483879-145-1.aspx

Try this rewrite

ALTER TRIGGER dbo.tr_SVC_SVC00701_InsertAddress ON dbo.SVC00701

FOR INSERT

AS

UPDATEj

SETj.Address1 = ISNULL(q.Address1, ''),

j.Address2 = ISNULL(q.Address2, ''),

j.City = ISNULL(q.City, '')

FROMdbo.SVC00700 AS j

INNER JOINinserted AS i ON i.OrdDocID = j.OrdDocID

INNER JOINdbo.SVC00200 AS q...

Ouch!

RIGHT JOIN?

DECLARE@Schema SYSNAME,

@Table SYSNAME

SELECT@Schema = 'dbo',

@Table = 'Servers'

DECLARE@sql NVARCHAR(MAX)

SET@sql = 'UPDATE ' + QUOTENAME(@Schema) + '.' + QUOTENAME(@Table) + ' SET'

SELECT@sql = @sql + ' ' + QUOTENAME(COLUMN_NAME) + ' =...

Here is how CHECKSUM is calculated and how you break it.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70832

Another approach

DECLARE@Stage TABLE (RowID INT IDENTITY(1, 1), LocationID NVARCHAR(250), LocID NVARCHAR(250), CompanyID NVARCHAR(250))

INSERT@Stage

(

LocationID,

LocID

)

SELECTl.ID AS LocationID,

LEFT(l.ID, v.Number - 1) AS LocID

FROM@Locations AS l

INNER JOINmaster..spt_values AS v ON v.Type = 'p'

WHERESUBSTRING(l.ID, v.Number,...

Set-based solution

DECLARE@Locations TABLE (ID VARCHAR(250), Location VARCHAR(250))

INSERT@Locations

SELECT'AAA', 'LocA' UNION ALL

SELECT'AAA.BBB', 'LocAB' UNION ALL

SELECT'AAA.BBB.CCC', 'LocABC' UNION ALL

SELECT'AAA.BBB.CCC.DDD', 'LocABCD' UNION ALL

SELECT'AAA.BBB.CCC.DDD.EEE', 'LocABCDE' UNION ALL

SELECT'AAA.BBB.CCC.DDD.EEE.FFF', 'LocABCDEF'

DECLARE@Companies TABLE (ID VARCHAR(250), CompName VARCHAR(250), CompDate DATETIME)

INSERT@Companies

SELECT'AAA',...

This topic seems very much alike this one

http://www.sqlservercentral.com/Forums/Topic475244-8-1.aspx

I just grabbed something, since you didn't specify which datatype to use.

Go ahead and use MONEY if you prefer!

CREATE FUNCTION dbo.fnFare

(

@LineID INT,

@Fare NUMERIC(18, 4)

)

RETURNS NUMERIC(18, 4)

AS

BEGIN

RETURNCASE @LineID

WHEN 1 THEN @Fare * 0.92

WHEN 2 THEN @Fare * 0.92

WHEN 3 THEN @Fare * 0.92

WHEN 4 THEN @Fare * 0.92

WHEN 5...

It's called plan cache / data cache.

Or you could be victim of parameter sniffing.

Throw in a DISTINCT !

SELECT DISTINCT Model_ID,

...

-- Stage the data

CREATE TABLE#Stage

(

RowID INT IDENTITY(1, 1),

Model_ID CHAR(20),

lCikisTutar DECIMAL(18, 2)

)

INSERT#Stage

(

Model_ID,

lCikisTutar

)

SELECTModel_ID,

lCikisTutar

FROMSalesFact

ORDER BYModel_ID,

lCikisTutar DESC

-- Show the expected output

SELECTs.Model_ID,

MAX(CASE WHEN s.RowID = x.minID + 0 THEN s.lCikisTutar ELSE 0.0 END) AS lCikisTutar1,

MAX(CASE...

This is a great example where SQL Server 2005 is better.

Then all you have do to is use the CROSS APPLY operator.

Updatet

Sett.Price = f.Bid,

t.Date= f.Price_date

from#tmpUsed as t

cross applydbo.fn_Find_Security_Details(t.Sedol_Number, t.AsAt) f

Also asked and answered

here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99688

and here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99741