Forum Replies Created
Viewing 15 posts - 57,406 through 57,420 (of 59,049 total)
-
RE: Sum on a row
Mark left out one part and if you did, too, you WILL get the same results... your GROUP BY has to be by the same formulas that Mark gave you...
-
RE: Query Running Slow
Outstanding list, Rudy... I'd like to bump your rounds down 1 and add a new round 1... "Write scalable code to start with."
-
RE: Script Field formats.
Don't think that's quite what Nick meant...
Nick... You can do this by creating your view like this....
CREATE VIEW dbo.someviewname AS
SELECT CAST(dflt_cyl_ctf AS DECIMAL(18,4)) AS dflt_cyl_ctf,
CAST(cyl_ctf_actv AS INT)...
-
RE: Log file
As some have correctly suggested, unless you do backups everyday, you should have the "recovery mode" set to SIMPLE.
DO NOT LIMIT THE LOG FILE!!! IF IT TRYS TO GROW BEYOND...
-
RE: Generic Audit Trigger
Ok... first, thank you very much for making my life easier for testing... the good news is, I get no errors with the following test code. The bad news is...
-
RE: Generic Audit Trigger
Hmmmm.... I'm wondering if the error I got when I ran you build scripts might be a hint of your DELETE problem...
Warning: The table 'AuditDetail' has been created...
-
RE: Trigger issue
Understood and appreciate the feed-back but riddle me this... did you change your code so that it does NOT use an UPDATE, yet
-
RE: Split a field into multiple records
Paul Cresham's function is great... I have a similar one that uses a Tally table... thought you might enjoy seeing it... the documentation is longer than the function itself...
October 11, 2006 at 8:21 pm
-
RE: Pass a value to a trigger...
Peter,
Thanks for being patient with the explanation... It would be really nice to combine both methods so that if something other than your proc fires the trigger, you can still...
-
RE: Trigger issue
Yep, sorry about that... I got a little frustrated with you... everyone has been trying to tell you that you're asking for "Death by SQL" by doing the UPDATE right...
-
RE: syntax error.
There's really no physical problem to keep you from using it... However, Microsoft and a bunch of folks on this forum have indicated that in order to guarantee that your...
-
RE: Generic Audit Trigger
I guess I'm just going to have to materialize this code and test it...
Would you post the CREATE TABLE statement for the two audit tables and the CREATE FUNCTION...
-
RE: How to do a Select xx from
And, you need to be real careful if this comes anywhere near a GUI... think "SQL Injection". Theres a huge amount of info on how to prevent it... do a...
-
RE: Pass a value to a trigger...
I guess I don't understand... obviously, you are finding the correct Windows user name somewhere along the line in your stored procedure because you want to "pass it" to a...
-
RE: syntax error.
It's the triple quotes in the variable assignment that are the most recent problem...
Try this...
declare @townID varchar(25),
@sql varchar(1000)
set @townID = '00003' --<<THIS IS WHERE THE...
Viewing 15 posts - 57,406 through 57,420 (of 59,049 total)