Viewing 15 posts - 1,156 through 1,170 (of 4,080 total)
I'm not sure I understand the question completely. Could you please give us a (small) example of the data, and a sample query?
If you are saying you...
__________________________________________________
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 1, 2011 at 9:31 am
Would you call this recursive?
WITH cte (Curse) AS
(
SELECT 'Dammit'
UNION ALL
SELECT Curse from cte
)
select Curse from cte
__________________________________________________
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 1, 2011 at 9:15 am
Roy Ernest (5/31/2011)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 31, 2011 at 12:57 pm
The Dixie Flatline (5/31/2011)
GilaMonster (5/31/2011)
The Dixie Flatline (5/31/2011)
Bob Hovious - MBSCSDD/FUBAR/BOHICABob! Where you been?
Lurking 😀
Ummmm.... I mean working. Yeah, that's 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
May 31, 2011 at 12:37 pm
GilaMonster (5/31/2011)
The Dixie Flatline (5/31/2011)
Bob Hovious - MBSCSDD/FUBAR/BOHICABob! Where you been?
Lurking 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 31, 2011 at 12:36 pm
Stefan Krzywicki (5/31/2011)
GSquared (5/31/2011)
The Dixie Flatline (5/31/2011)
Could 42 possibly be the airspeed velocity of an unladen swallow?
Considering that we haven't defined either length or time units, I say it's PRECISELY...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 31, 2011 at 12:34 pm
Could 42 possibly be the airspeed velocity of an unladen swallow?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 31, 2011 at 12:25 pm
GSquared (5/31/2011)
Damian Widera-396333 (5/31/2011)
What is the *REAL* question here?What's the meaning of "42"?
That depends on the question, doesn't it?
Bob Hovious - MBSCSDD/FUBAR/BOHICA
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 31, 2011 at 12:22 pm
That is deprecated syntax for doing a join. Remove it from your where clause and replace
FROM at_pdesc_off,
...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 27, 2011 at 2:43 pm
A crude analogy. You own a fruit orchard but are only interested in selling apples today. Is it less work to pick all the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 27, 2011 at 11:51 am
If using the STDistance() on a geography type, distance is understood to be calculated over a curved surface. Some SRIDs even take into account that the earth...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 27, 2011 at 8:51 am
There is a link in Sean's signature line to this article. It's worth reading.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
As Sean said, the people who answer questions in these forums are unpaid volunteers....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 26, 2011 at 9:10 am
The solution is simple, but you are going to generate a huge number of combinations. (With a small town of only 10,000 properties, you have almost 100...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 26, 2011 at 8:15 am
I don't have time to code and test today, but since the same set of points is being cross joined multiple times, perhaps a recursive CTE?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 18, 2011 at 1:18 pm
ccparkhill (5/18/2011)
No, recipie 1 is:Apple
Recipie 7 is:
Apple
Orange
Banana
My error. I wasn't thinking of combinations of single elements.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 18, 2011 at 12:45 pm
Viewing 15 posts - 1,156 through 1,170 (of 4,080 total)