Viewing 15 posts - 1,156 through 1,170 (of 4,081 total)
Insert your random cursors where you wish, change the variables and attach speech to the output.
Shut the front door....
June 1, 2011 at 11:32 am
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...
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
June 1, 2011 at 9:15 am
Roy Ernest (5/31/2011)
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....
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 😀
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...
May 31, 2011 at 12:34 pm
Could 42 possibly be the airspeed velocity of an unladen swallow?
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
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,
...
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...
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...
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....
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...
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?
May 18, 2011 at 1:18 pm
Viewing 15 posts - 1,156 through 1,170 (of 4,081 total)