Viewing 15 posts - 1,111 through 1,125 (of 4,080 total)
Joe, this is essentially a running totals problem further complicated by the need to associate each sale with a buying price. It's like FIFO inventory. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 6, 2011 at 2:37 pm
Sean is correct, and I was remiss in not mentioning the possibility of SQL Injection attacks. Gail's article, which he refers you to is excellent. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 6, 2011 at 9:09 am
Congratulations, Lynn! Hope all goes smoothly for mother and child.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 5, 2011 at 5:13 pm
If any value in a formula is NULL, the result is NULL. This includes concatenation of columns and variables.
(I know not these "fields" of which you speak.)...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 5, 2011 at 2:04 pm
You might want to look at the Quotename() function in BOL.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 5, 2011 at 12:34 pm
Wisecrack withdrawn.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 4, 2011 at 10:31 pm
This is pretty standard stuff actually. Here's one way to code it.
If your table is large you would certainly benefit from having indexes on both...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 4, 2011 at 10:26 pm
So can beer, Jeff. I'm about to go sample some. Have a great weekend, y'all.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 3, 2011 at 4:28 pm
WHERE Col2 is not null and Col2 = Table1.ID
Your join requires that every row of Table2 be tested. Your addition of NOT NULL restricts the set...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 3, 2011 at 4:26 pm
Stats on how many NULLS are in Col2 and in Table1.ID?
In deciding to use an index, the optimizer is informed by both the sequence and the distribution of values in...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 3, 2011 at 2:31 pm
What would you say to finding MVPs who are plagiarizing content to either gain MVP or to retain MVP?
Be sure always to call it please "research."
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 3, 2011 at 12:59 pm
But you HAVE to enclose the variable in parentheses
This works.
declare @x int = 10
select top (@x) *
from sys.all_objects
This doesn't. You'll get a syntax error.
declare @x int = 10...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 3, 2011 at 10:25 am
I tested it out. The Double-LEFT join runs over 10 times faster when joining 100,000 rows to 9,000 rows. HOWEVER, the critical difference isn't...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 3, 2011 at 10:00 am
Jim Murphy (6/3/2011)
The Dixie Flatline (6/3/2011)
I've given the matter considerable thought, and have conclusively concluded that the posted questions are indeed getting worse.
Bob - this is an old thread and...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 3, 2011 at 9:38 am
The crowd has rubber bullets?? That's a new one to me...
Is my participle dangling? :w00t:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 3, 2011 at 9:23 am
Viewing 15 posts - 1,111 through 1,125 (of 4,080 total)