You can use the REPLACE function

Glad to help you out.

Regards,

Kingston

Sorry Try this one ..

Try this. I hope this works..

;WITH cteTable AS

(

SELECT ROW_NUMBER() OVER ( PARTITION BY zipcode ORDER BY datevalue ) AS RowNumber, *

FROM ...

Sorry Try this one ..

;WITH cteTable AS

(

SELECT ROW_NUMBER() OVER ( PARTITION BY officecode ORDER BY datevalue ) AS RowNumber, *

FROM ...

Try this..

;WITH cteTable AS

(

SELECT ROW_NUMBER() OVER ( PARTITION BY officecode ORDER BY datevalue ) AS RowNumber, *

FROM#Table

)

UPDATET

SET ...

Sorry for the error. I actually missed see the forum name. I think we can use the table variables or temporary tables with an identity column to solve this problem.

;WITH cteCountSpeed AS

(

SELECTROW_NUMBER() OVER ( ORDER BY Col1 ) AS Row, *

FROMtblCountSpeed

)

SELECTC1.Col1, C1.col2, ( C2.Col2 - C1.Col2 ) / ( C2.Col1 - C1.Col1 ) AS QueryColumn

FROMcteCountSpeed C1

LEFT OUTER JOIN cteCountSpeed...

INSERT INTO #PresentInfamily

SELECT * FROM #FamilyMembers

DECLARE@strSQLVARCHAR(MAX)

SELECT@strSQL = COALESCE( @strSQL, '' )

+ ' INSERT INTO #PresentInfamily( IndividualNo, MemberInFamilyID, PresentStartDate, PresentEndDate ) '

+ ' SELECT IndividualNo, MemberInFamilyID, ''' + CAST( DATEADD( DAY,...

Actually your code has put me in confusion with the names.

But just try if this works or if you get some idea

SELECT b.divid,sum(a.Amount)

FROM DailyTrans a,accounts_Info b

WHERE a.acctID=b.acctID

and (b.DivCode = 'AAA')...