Brad, I'll have to look at your response in much greater detail, but I
can tell you this.
Currently, I'm running a CF script that populates a prospect_export
table once a day. The initial query returns 25,785 rows, which gets
flattened into 20,265 rows for reporting purposes.
Ultimately I'd
Hi Rick,
This is where the limiting nature of SQL comes in--SQL is a set language
and has no (or very limited) looping/reshaping capability. Unless MS
has extended their SQL in ways I'm not aware of, this would be nearly
impossible. That's where the power of CF comes in.
--Ben
Rick Root
This is where the limiting nature of SQL comes in--SQL is a set language
and has no (or very limited) looping/reshaping capability. Unless MS
has extended their SQL in ways I'm not aware of, this would be nearly
impossible. That's where the power of CF comes in.
That's not true. You can
You might also take a look at ms sql 2005's row_number() function. You may be
able to partition the data and use row_number() to limit the returned records.
http://msdn.microsoft.com/en-us/library/ms186734.aspx
Original Message
Subject: (ot) Transact-SQL Help
From: Rick Root rick.r...@webworksllc.com
Date: Thu, September 10, 2009 12:25 pm
To: cf-talk cf-talk@houseoffusion.com
I'm hoping someone here can point me in the right direction. I'm
doing something in CF that I
As long as you are only dealing with a dozen or so records
from the database it should perform fine and and I think it will be
a heck of a lot simpler than trying to make your SQL server take a
row-based list of people and pivot them out into columns.
Assuming the example is actually
Rick Root wrote:
syntax of my function: getDistance(zip1,long1,lat1,zip2,long2,lat2)
taking either the zip code or the lat/long for each...
SELECT *
FROM prospects A
WHERE
zipcode in
(
SELECT B.zipcode
FROM zipcodes B
WHERE
On 2/6/07, Jochem van Dieten [EMAIL PROTECTED] wrote:
This query is not indexable so it needs to do the math on each and every
row. Prequalify the rows by drawing an imaginary box on the map from
b.lat + X to b.lat -X and b.lon + X to b.lon -X and finding only the
points in that box (the
8 matches
Mail list logo