Viewing 15 posts - 3,571 through 3,585 (of 7,631 total)
Actually I think that Kumar's case function might have the "1" and "2" backwards.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 22, 2009 at 12:56 pm
Like this:
Select F1, F2
From TABLE1 t1
Where EXISTS(Select * From TABLE2 t2
Where t1.F1 Between t2.F1 and t2.F2
And t1.F2 Between t2.F1 and t2.F2)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2009 at 10:15 pm
andrewd.smith (2/19/2009)
select @result = ((1+@lf_group1/100)^(12/@lf_exponent)-1)*100
The ^ character represents the XOR operator in TSQL, not the exponential operator that it represents in VB. In TSQL,...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2009 at 9:39 pm
And how are rows to be joined between the two tables? Do you want every row from Table1 that has any overlap to any row from Table2? Or is...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2009 at 9:27 pm
Yes, but will have to define what you mean by match. Do you mean that the first range is completely contained by the second or do you mean that...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2009 at 9:11 pm
You know, I've been so busy the last month or so, I missed this when it first came out. This is an impressive piece of work, Lynn, congratulations. ...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2009 at 8:42 pm
Yeah, the search facility is really awful. I cannot imagine how it hard it is for you, Jeff, with 3 to 5 times as many posts as me!
Example: use...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2009 at 11:40 am
One thing that I would really like to see, is better capabilities for managing, organizing or even just finding forum posts, even just our own previous posts. Great as...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2009 at 10:44 am
GilaMonster (2/21/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 21, 2009 at 7:54 am
Hey, Eron The Relentless, I haven't seem him in a long time!
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 20, 2009 at 8:39 pm
Nah, I was playing a White-Blue Wrath of God/Blinking Spirit with counters deck. It was OK for the time (very weird format) but is was too slow.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 20, 2009 at 7:18 pm
Glad we could help and thanks for getting back to us.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 20, 2009 at 7:07 pm
Bob Hovious (2/20/2009)
I'd say you were in high school between 1974 and 1977. Am I close?
Even worse 🙁
I graduated high school in 74. I played...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 20, 2009 at 4:32 pm
Lynn Pettis (2/20/2009)
Alvin Ramard (2/20/2009)
David Webb (2/20/2009)
All-night, drunken D&D at the next PASS?I'd have to show up for that. I might not live through it, but what the hey...
Is...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 20, 2009 at 4:30 pm
I believe that you will have to migrate your package from SQL 2000 to at least SQL2005 before it will work.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 19, 2009 at 4:24 pm
Viewing 15 posts - 3,571 through 3,585 (of 7,631 total)