Lowell, was only working with one table.

Sean that worked. why the heck didn't I think of summing instead of just looking for nulls....DOH!

Thanks

awesome, that worked.

now i got one little hurdle, probably something in the pro, but each clients results are put into a little result table of it's own. I guess I...

DOH!:(

brucla (8/20/2010)

---

Simple solution would be cursors that iterates through client ids...

If there are a lot of clients to retrieve payment histories for, and cursors are too slow, you can try...

the data is spread across a bunch of tables and calculations. quite a bit over my head in sql. a couple of tables, and multiple joins is as far as...

well basically I am the DBA (although uneducated in the ways of the SQL). the database is part of custom software we purchased. and yes the will give us the...

locked - meaning it's locked with the little lock icon, I can not modify it. only run it

(i guess the correct term would be the procedure was created with Encryption...

nevermind, i'm an idiot had clientname going into clientid field. (should have just copied and pasted...)

already did that. still don't know why it thinks I'm converting nvarchar to int though

hmmm... the select statement works now, but when I add it to the insert I get

"Conversion failed when converting the nvarchar value 'Jim Beam' to data type int."

don't really...

nvrmnd used cast(clientid as nvarchar(10))

of course doing it that way I found I have a lot of empty spaces after some names, gotta remove all white space from the...

no i get "The data types nvarchar and varchar are incompatible in the '&' operator."

clientname is nvarchar(50) and clientid is int

the CA product has the ability to correct for an accidentally dropped table ( not that my users have direct access to the tables). it also has a rollback feature...

ok i guess that answers it. it uses an MS Access type front end right now, i think their net release is designed in .Net. don't know if it's ADO.Net...

Robert Cary (7/15/2010)

---

Your connection string would look something like this:

Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;Initial Catalog=myDataBase;Integrated Security=True;

The application will connect to whichever one is available, if the primary fails, the application connections will...