Viewing 15 posts - 61 through 75 (of 173 total)
Steve Jones - Editor (3/15/2009)
...C#, VB, etc. are programming languages designed for working with a variables, of sets of variables in objects.
How do you realize a result of a query...
March 22, 2009 at 6:09 pm
Michael Valentine Jones (3/16/2009)
it didn't seem to answer was what...
March 22, 2009 at 2:46 pm
Here's an sql solution to leave one row from a pair of 'opposites'.
create table #t1 (A varchar(10), B varchar(10))
insert into #t1(A,B) select 'john', 'sainz'
insert into #t1(A,B) select 'john','candy'
insert into #t1(A,B)...
March 21, 2009 at 2:23 am
Steve Jones - Editor (3/17/2009)
I haven't complained about the advertising of your product because it's free, and because you've only mentioned it in places where you appear to believe...
March 19, 2009 at 1:43 pm
Lynn Pettis (3/16/2009)
steve dassin (3/16/2009)
To see for yourself visit my blog (for explanations and examples) or check out the system documentation (chm file):
http://www.geocities.com/d4tosql/D4/Dataphor.zip
Better yet I invite you to download the...
March 16, 2009 at 9:10 pm
Gift Peddie (3/15/2009)
Science is a b****, expediency is a w*****. It's not easy to sleep with science. But sql sells itself to even the lowest bidder. It's been screwing developers...
March 16, 2009 at 7:03 pm
foxjazz (3/13/2009)
March 14, 2009 at 11:58 pm
And true-believers recoil at the thought of a cursor. 🙂
March 10, 2009 at 12:31 am
Jeff Moden (2/3/2009)
I agree with Barry... enjoy the cleverness of the code and the way the author of that code overcame the shortcomings of the language. 😉
I agree. I appreciate...
February 4, 2009 at 4:50 pm
RBarryYoung (2/2/2009)
Uh, yeah. Not to intrude on your fantasy lecture here, Steve, but let's throw some actual facts in:...
1-7
I obviously was too ambiguous with my use of the term...
February 3, 2009 at 9:06 pm
RBarryYoung (1/31/2009)
Jeff Moden (1/31/2009)
February 2, 2009 at 10:29 pm
Lynn Pettis (1/30/2009)
Amazing how many problems seem to be solved using the running totals approach at times. 🙂
Yep.
This was recognized a long time ago by the major sql database venders...
January 31, 2009 at 1:13 am
nabajyoti.b (1/28/2009)
the record that appears first in order
select emp_id,emp_name,emp_address,rank
from
(select emp_id,emp_name,emp_address,
row_number()over(partition by emp_address order by emp_name) as rank
from ##emp) as A
where rank=1
order by emp_address,emp_name
emp_id emp_name ...
January 29, 2009 at 10:50 pm
beetlejuice (1/27/2009)
But all of this doesn't sound very 'relational to me.
I've never heard sound effects emanating from logic:) Lets see what you have so far. If it bleeds you...
January 28, 2009 at 10:59 pm
stephenmbell (1/27/2009)
- you cannot pass a variable of type table as an input parameter to a sql 2k5 stored procedure
- I tried setting it up so...
January 28, 2009 at 10:42 pm
Viewing 15 posts - 61 through 75 (of 173 total)