Viewing 15 posts - 47,296 through 47,310 (of 59,064 total)
Lynn Pettis (11/10/2008)
Seems to me that a stored procedure, a temp table and a variation on the running count would give you what you need.What do you think, Jeff?
The data...
November 11, 2008 at 5:58 am
krayknot (11/10/2008)
if you want i can forward that function on your email id.
Heh... post it here so we can all enjoy it. 😉
November 11, 2008 at 5:39 am
...and that still won't guarantee that the user can write to the DB. Oracle has it's own "system" views... if you want to see what privs a user has,...
November 11, 2008 at 5:36 am
Mazharuddin is correct. The user won't necessarily be able to do anything... it just verifies that the user can connect. If you want to verify the user can...
November 11, 2008 at 5:34 am
The best thing to do, if it can be done, is to use variables like the original code. Of course, the OR still needs to be fixed as I...
November 11, 2008 at 5:28 am
Adam Hardy (11/10/2008)
Thanks for the input, but I think you may have miss-read my post, I said I was utilising triggers for data integrity tasks, not business rules....
November 11, 2008 at 5:20 am
Jack Corbett (11/4/2008)
November 11, 2008 at 5:07 am
Oh my... I just remembered where the heck such a requirement for all positive numbers may have come from... PeopleSoft software. Seems like the last folks that I knew...
November 11, 2008 at 5:03 am
Be careful, Sue... having a fully dynamic WHERE clause is very suseptable to SQL Injection attacks if the code is exposed to the general public.
November 11, 2008 at 4:57 am
You shouldn't ever bulk insert directly into the final table that already has rows in it. Bulk insert into a staging table first, check it for dupes, than then...
November 10, 2008 at 9:37 pm
Jeff Moden (11/10/2008)
That sounds more like problems with a table variable. Why aren't you using a temp table, instead?
Heh... sorry... I forgot... you're happy with the code you have....
November 10, 2008 at 9:25 pm
Continued at the following... on the 2k forum...
http://www.sqlservercentral.com/Forums/Topic599997-169-1.aspx
November 10, 2008 at 9:08 pm
You've got me... I use OPENROWSET for that type of stuff. Or, better yet, I'll have Excel write an importable CSV when they close the spreadsheet.
November 10, 2008 at 8:55 pm
ajaykini (11/10/2008)
I have developed a web based software for a Multi level Marketing Company where one member joins and then gets 2 members below him - one on the...
November 10, 2008 at 8:52 pm
Business rules in triggers? I think that more than 95% of all business rules can either be resolved by the proper use of constraints and foreign keys on the...
November 10, 2008 at 8:31 pm
Viewing 15 posts - 47,296 through 47,310 (of 59,064 total)