Flexibility decreases as logic increases.....true but that's exactly what placing the logic in the db is supposed to do...guard the db from the user who only seems hellbent on trying...

magyar...while you are reading up on normalization basics, why don't you start another thread....this time ask for help with the database design...identify all the different entities you have, how they...

magyar - what you really need to do is to identify each of the entities...eg: you seem to have - school, college, attorney, physician, claimant, center, employer, building, rehab..(wow)....identify how...

also...unless there is a compelling reason to use varchar datatypes for your ID columns, you'd be better off using integers....(meant to say that as soon as i read you had...

oh dear - what a mess....magyar...i'm afraid all this can be traced back to when you asked:

As far as table structure goes, I have 5 tables: School, Students, Professors, Buildings,...

salvatore - i apologise but i cannot take a look at this until later on today...farrell - do you have the time ?!

if everything is already "aggregated" then you may...

salvatore - could you pl. query the 3 tables with the date filter...

(ACW.AUDIT_DTE BETWEEN '07/10/05' AND '07/14/05') 
(CWID.ADHERENCE_DTE BETWEEN '07/10/05' AND '07/14/05') 
(QPP.EVALUATION_DTE BETWEEN '07/10/05' AND '07/14/05')

and post the...

having the @@error at the end will only check if the last stored procedure executed resulted in any error or not...it will commit even if the previous procedures resulted in...

sai - why don't you post your query and the requirements ?! That should help someone identify a solution much quicker!

unfortunately the limitation of the cube operator is 10 dimensions...

maybe you could split it into a couple of views and then query the views...but then if you have a large...

salvatore - I just revisited the script I posted....I think this is what it should actually be...

or at least something like this...depending on what you want...you may need to "play...

you misunderstood me.......quite completely I'm afraid..

to redeem myself though, I have a link for you where something (almost) identical was discussed a few days...

oh - didn't realize from your first post that the file size has reverted back to normal!

next time (hopefully there won't be one) you may want to post your script...

I'm going by personal experience....I had a scheduled backup that ran just fine for over 6 months before suddenly deciding to (most mysteriously I may add) start appending...

does your backup...

are field2, field3 etc...columns from your tblUsers - are you trying to update these ?! If you are...then you should create a stored procedure and pass the field values to...