Try this free ebook - http://www.red-gate.com/specials/Grant.htm

If after reading that you dont know , its not worth knowing 🙂

+1 to you for working it out for yourself. 🙂

Try this, ive had to create a unique Id in the required order to get the 'previous' row

Drop table #Testtable

go

CREATE TABLE [#Testtable](

[TestTableId] integer identity,

[CustNo] [varchar](20) NOT NULL,

[ContractNo] [varchar](20) NOT NULL,

[RNo]...

Hi , I dont have access to a 2000 box to test but i think this should would

Select t1.* into #t1 from TestTable t1

join (Select CustNo,ContractNo,RNo,MAX(DateFrom) as MaxDate

...

Heres one method using PIVOT.

http://www.mssqltips.com/tip.asp?tip=1019

Something like this ?

with cteAccounts

as

(

Select AcctNo,Payment,Date,row_number() over (partition by AcctNo order by Date desc) as Rown

from Accounts

)

select * from cteAccounts

where...

Apologies Wrong link

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

Try this....

http://www.sqlservercentral.com/articles/T-SQL/62867/

Please confirm which SQL Version you are running.

Use a calendar table

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Duplicate thread

http://www.sqlservercentral.com/Forums/Topic850276-392-1.aspx

Shark Energy (1/11/2010)

---

We have 2 servers. One running a hotfix of SP2. The other is a new dev server now on SP3. The spec of the machines is the same...

So what does your statement look like now ?

This has the potential for fun.... 😉

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

Seriously, what do you expect from this forum ?

Without more detail on when this error occurs all that i can say is that you are inserting (possibly updating) data into...

Urgent or not, your error is on this line

SET @smaldate = select max(dat_Date) from tbl_Transaction where txt_statecode=@StateID and txt_DistrictCode=@DisID and dat_Date='3/31/2008'

The correct syntax is

select @smaldate = max(dat_Date) from tbl_Transaction...