UPDATEy

SETy.InvalidFlag = 6

FROMtb_LeadBox AS y

LEFT JOIN(

SELECTMIN(UId2) AS UId2

FROMtb_LeadBox

WHEREEntryDate >= DATEADD(YEAR, -1, GETDATE())

GROUP BYFName,

LName,

HomePhone

) AS x ON x.UId2 = y.UId2

WHEREx.UId2 IS NULL

AND y.InvalidFlag IN (0, 1, 2, 3, 4, 6, 7,...

http://www.sqlteam.com/article/datediff-function-demystified

Also read this article about DATEDIFF

http://www.sqlteam.com/article/datediff-function-demystified

Script out all SP and functions to a text file.

Open the text file on the new server and run the code.

Keep track of your operator presedence!

UPDATE wjam

SET wjam.Bin = iw.DefaultBin

FROM dbo.WipJobAllMat AS wjam

INNER JOIN dbo.InvWarehouse AS iw ON iw.StockCode = wjam.StockCode

INNER JOIN dbo.WipMaster AS wm ON wm.Job = wjam.Job

WHERE wm.Complete...

Also see

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89993&whichpage=2

;WITH Yak (ID1, ID2, RecID, RowID)

AS (

SELECTes1.EventSegment_ID,

es2.EventSegment_ID,

ROW_NUMBER() OVER (PARTITION BY es1.Location_Code, es1.Activity_ID ORDER BY es1.StartTime DESC) AS RecID,

COUNT(*) OVER (PARTITION BY es1.EventSegment_ID) AS RowID

FROM#EventSegment AS es1

LEFT JOIN#EventSegment AS es2 ON...

Wait a minute? What is the objective here?

1) Same week (sun-sat or mon-sun)

2) Any "7-day period" starting with first non-sequential date?

Here too

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

And you got a LOT of help here!!!

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

Read about ROUND function in Books Online.

It takes three parameters

1. The value

2. Number of decimals

3. Round or truncate

How is your statistics?

You are missing a ) in the code above.

SELECT      ACCTNUM,

            ENTITYID,

            PERIOD,

            BALFOR,

            SUM(ACTIVITY) AS ACTIVITY

Field1 is already VARCHAR? And Field2 is INT?

CAST(FIELD1 AS varchar(10)) + '/' + FIELD2 As fulltext,

Field1 + '/' + CONVERT(VARCHAR, Field2) AS FullText

You can also use the fnParseString function found here

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

Use the second version.

If you are concerned about speed, Ray's solution will not make use of any present index. Making a calculation with the indexed column renders the index useless.