Thanks!

yes...and might i add....nice picture!!

NOPE...

pic address: file:///F:/Inetpub/wwwroot/DELIVERANCE/IMAGES/textsource.jpg

hm...the picture did not seem to display.

WHERE fa.EffEndDate=(SELECT MAX(fa2.EffendDate) FROM #LAccounts fa2 WHERE Fa2.accountnumber=fa.accountnumber)

or fa.EffEndDate is null

hm...i tired this and it pulled both the max date and null dates for some accounts. It seems at though some...

I receive the following error:

Server: Msg 248, Level 16, State 1, Line 1

The conversion of the varchar value '8442080139' overflowed an int column. Maximum integer value exceeded.

here is the query...

i've tried the following join with no luck

join lane.dbo.serviceaddr ls on (cast(a.aglaccountnumber as int)=(cast(ls.ldcaglnum as int))

am i doing something wrong with the placement of my parenthesis?

Server: Msg 16924, Level 16, State 1, Line 40

Cursorfetch: The number of variables declared in the INTO list must match that of selected columns.

I received the above error message. I...

That option will not really work since last payment dates range from 2002-present. We have accounts that have not made payment in a LONG time.

ok...here's another question...sorry.

How would i use the CAST with the ISNULL?

SELECT ISNULL(CAST (streetnumber AS VARCHAR(5), '') ?

For some reason, i get the following error message:

The isnull function requires 2 arguments.

how do i account for columns that are "null"?

There is not always a "streetsuffix", for example.

No Pain at all!!! Thank you so very much with your help on this!!

There are actually three tables I am looking pulling this information from.

There is a “Systems”...

Oh! yes of course! Sorry, there is a table with all account information (account #, hardware ID, Description) and the second table has all of the associations in it (hardware...