Viewing 15 posts - 346 through 360 (of 399 total)
OK - here is a testdb. It has all the tables involved for the triggers to work. I have also included some test data at the end (commented...
February 15, 2011 at 11:12 am
OK - let me see if I can do this without revealing too much. This is a top secret project (seriously - not that I would have to kill...
February 15, 2011 at 8:43 am
Thank you! If it takes you a few hours, no worries. I just appreicate the help!
🙂
February 15, 2011 at 8:03 am
Hi Sean!
Yes - the trigger code is on 4 tables total, but this is the one where it is erroring out. The only way I have successfully be able...
February 15, 2011 at 8:01 am
Hi Mister Magoo!
No - the scenarios would also need to include checking as well as savings. On the same level - some will have an OverDraftAccountID, and some will...
February 15, 2011 at 7:40 am
OK - came across an interesting issue. Bare in mind that this is SQL 2005 SP3 that I am developing for, so I do not know if this issue...
February 15, 2011 at 7:36 am
Hi Mister Magoo - If I may, I'd like to run this by you!
I am trying now to include all the other elements and attributes, but am running into trouble....
February 14, 2011 at 9:55 pm
Hello George!
Yes - I am backing up all of my databases (system and user db's) to a single file. Was not aware that this was a bad practice. ...
February 14, 2011 at 6:06 pm
Hello Nakul -
Basically - these are the steps I am taking...
1. Close SSMS, and shut down all SQL Services listed (probably even ones that do not need to be...
February 14, 2011 at 10:36 am
Thank you again ALZDBA. Sean in fact reconstructed my INSERT to exclude the NULLS. It's working great. Now - time to start testing it out for real!
Thanks...
February 14, 2011 at 10:25 am
OK - just wondering (as all of the triggers I've written to date have not been on isoldate installs as this one will be). The intention of the trigger...
February 14, 2011 at 10:18 am
Sean, thank you! That's got it! So I will now have all the safeguards or being able to do multiple INSTERTS or UPDATES (as I modifiy this for...
February 14, 2011 at 9:43 am
You know what? I just realized why I was going with variables/parameters. I need to combine 2 columns, so that the values are separated by a dash/hyphen... ...
February 14, 2011 at 9:26 am
Ah! That is SWEET! OK - I am going to get to work on this now to include the other pieces, so I may get this into my...
February 13, 2011 at 12:54 pm
That was it! Lutz, thank you again for your help! I am going to now use some variables to put the columns into a format for import, and...
February 12, 2011 at 5:26 pm
Viewing 15 posts - 346 through 360 (of 399 total)