Viewing 15 posts - 3,166 through 3,180 (of 4,080 total)
No, I haven't looked at this since I realized that my shift-left version was not the ultimate answer. You guys had already made considerable progress, so I've just been...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 6, 2009 at 9:12 am
Sweet. This has certainly been an interesting problem to follow.
Anyone heard from the OP lately?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 6, 2009 at 8:05 am
I quite agree, Vladan. "Backdating" transactions is often a questionable business practice. Although there may be disastrous situations where recovery fails and transactions MUST be entered...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 6, 2009 at 8:03 am
Roy, I'm terribly sorry to hear that. God bless your family in this time of trouble.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 6, 2009 at 6:58 am
Paul, I was referring to your comments about functions which are applied to constants or local variables not having an effect on the use of indexes. (Sorry for...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 6, 2009 at 6:51 am
It's dead, Jim. Wake and afterparty to be held near Roy's place.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 5, 2009 at 9:51 pm
If we need to know by using select getdate()
I hope you're not trying to change the system time to retrieve rows that had the current getdate() value stored...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 5, 2009 at 9:41 pm
Oh, one more thing about the bit datatype. I rarely see a simple active yes/no. Usually it is a "status" column and (A)ctive is but...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 5, 2009 at 9:18 pm
Trans54, me see if I can reply in pretty much the same order.
1. Paul is correct that an explicit null can always be passed,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 5, 2009 at 9:07 pm
One other VERY IMPORTANT point that I almost forgot.
The first time you run this procedure, the parameters you pass may have an effect on the execution plan. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 3, 2009 at 10:52 pm
You're very welcome.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 3, 2009 at 10:45 pm
Thought I'd throw in an afternote. I recently read in Karen Delaney's 2005 internals book that when columns are dropped, the space isn't reclaimed until the clustered index...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 3, 2009 at 10:41 pm
How about this approach?
DECLARE @EmpXML AS XML(EmployeeSchema)
DECLARE @LocalError -- as what?
BEGIN TRY
SET @EmpXML = @EmployeeXML -- TRY to set the @EmpXML to @EmployeeXML
END ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 3, 2009 at 10:33 pm
AND (@CodeId IS NULL OR @CodeId = 0 OR p.CodeId = @CodeId)
Let's begin with this statement in the WHERE Clause. It will be helpful to interpret it...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 3, 2009 at 9:48 pm
Yes guys, the original version is "What happened to the other dollar?"
Actually, I think the original version may go something like...
III centurions enter an inn and the innkeeper's son...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 3, 2009 at 7:59 pm
Viewing 15 posts - 3,166 through 3,180 (of 4,080 total)