Viewing 15 posts - 2,641 through 2,655 (of 4,080 total)
I just tried to look at the attachment for a recent Candidate Reviews post. Would someone carefully save it to disk first (without left-clicking on it), open...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 7, 2009 at 5:46 pm
Warning. Don't click on the link above. Save it and open it with notepad or some other editor first. I'm not quite...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 7, 2009 at 5:33 pm
Hey Paul, I was aware of how dropped columns are handled. I was just theorizing about how Michael got his one-second update. His later statement that...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 7, 2009 at 10:34 am
Please post up a script to create a sample table with your date column, using the same datatype you are using in your production files. Populate it with...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 7, 2009 at 10:16 am
I believe so, but I require further clarification. After rereading your initial post, let me give you the following examples and you tell me what the count should...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 7, 2009 at 10:09 am
where date between '2009/05/01' and '2009/05/31' OR date is null
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 7, 2009 at 6:07 am
Using the sample table from the code above, will this do the trick for you? Ordering by newID basically randomizes it. Then the row_number() is assigned...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 6, 2009 at 9:18 pm
It creates yet another vulnerability, if you don't maintain control over who is allowed to execute which stored procedures. Someone more DBA focused could give you a...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 6, 2009 at 12:17 pm
So you are saying that you can't use the solution because it doesn't use the patindex, charindex functions? This sounds like a homework assignment to me. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 6, 2009 at 12:05 pm
You're very welcome, Michelle. Happy I could help.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 6, 2009 at 6:18 am
But I dare you to find anyone who finds me the least bit intimidating, except from across a chessboard, or in a game of Trivial Pursuit. [Smile]
(1) P-K4
(2) ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 3:03 pm
Check this out. The basic plan is to populate a worktable with the last two orders for every serial#/categoryCode combination. RowNo = 1 is...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 2:57 pm
Hang on just a little while longer. Caught a rush job at my office.
I haven't forgotten you and the solution was half-coded before I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 2:22 pm
The woman plays with edged weapons, Gus.
She can punt my posterior physically as well as technically 😉
I say this with GREAT respect.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 1:25 pm
Service Order ID | Service Order Created At | Serial | Service Order Categorization code
3000000021 | 2009-03-15 20:34:10.000 | 110214 | A04 B22 C17 D00 E00
3000000049 | 2009-03-15 21:00:49.000 |...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2009 at 1:01 pm
Viewing 15 posts - 2,641 through 2,655 (of 4,080 total)