Viewing 15 posts - 1 through 15 (of 36 total)
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
July 14, 2011 at 2:48 pm
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...
August 23, 2010 at 3:30 pm
brucla (8/20/2010)
If there are a lot of clients to retrieve payment histories for, and cursors are too slow, you can try...
August 23, 2010 at 2:58 pm
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...
August 20, 2010 at 9:45 am
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...
August 18, 2010 at 2:20 pm
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...
August 18, 2010 at 12:47 pm
nevermind, i'm an idiot had clientname going into clientid field. (should have just copied and pasted...)
August 5, 2010 at 12:49 pm
already did that. still don't know why it thinks I'm converting nvarchar to int though
August 5, 2010 at 12:44 pm
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...
August 5, 2010 at 12:39 pm
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...
August 5, 2010 at 12:17 pm
no i get "The data types nvarchar and varchar are incompatible in the '&' operator."
clientname is nvarchar(50) and clientid is int
August 5, 2010 at 12:11 pm
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...
July 20, 2010 at 12:53 pm
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...
July 16, 2010 at 6:50 am
Robert Cary (7/15/2010)
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...
July 15, 2010 at 11:45 am
Viewing 15 posts - 1 through 15 (of 36 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy