Viewing 15 posts - 6,646 through 6,660 (of 10,144 total)
wburnett_1 (9/13/2011)
Understood, that actually works better for this case, in that it should be more like drawing names from a hat...
Look up NTILE in BOL, this is what it's...
September 13, 2011 at 10:03 am
At my last place, the product transaction table was about 70 million rows. A requirement was to extract transactions for a single product - about 30k to 70k rows -...
September 13, 2011 at 9:13 am
Tom.Thomson (9/12/2011)
ChrisM@Work (9/12/2011)
WayneS (9/11/2011)
ALZDBA (9/11/2011)
:sig:The one who's name thow shall not state felt the need to kill a forum newbe with ancient history and lousy advise.
September 12, 2011 at 8:49 am
WayneS (9/11/2011)
ALZDBA (9/11/2011)
:sig:The one who's name thow shall not state felt the need to kill a forum newbe with ancient history and lousy advise.
September 12, 2011 at 6:33 am
You can't put the roof on a house until the walls are up. Start with the foundations - build a query which returns the data you want to process into...
September 9, 2011 at 8:02 am
uciltas-924976 (9/9/2011)
I just realized a minor problem on the code you sent.
To handle [AVG-DAYS] we said to use when it is current month data CTR_UPDATED will be getdate()
So...
September 9, 2011 at 7:32 am
GSquared (9/9/2011)
ChrisM@Work (9/9/2011)
GSquared (9/8/2011)
...breeding dogs for 10,000 years has yet to produce a T-Rex...
Isn't it fortunate for us that this wasn't the intention from the outset?
I don't know.
I think scritching...
September 9, 2011 at 7:07 am
in_beta (9/9/2011)
Hi Chris,Ok, I'll try attempt a rough table output, I'll omit DocDate unless you specify otherwise.
...
You're new here - this is better:
USE tempdb
GO
SET DATEFORMAT MDY
CREATE Table OCRD (CardCode VARCHAR(20),...
September 9, 2011 at 7:04 am
Let's assume for a moment that the results aren't quite what you're expecting because of dupes in the output. Now, if you were to set up sample data scripts with...
September 9, 2011 at 6:12 am
Something like this?
SELECT
ocrd.CardCode,
ocrd.CardName,
ocrd.CntctPrsn,
ocrd.Phone1,
ocrd.Cellular,
YearTotal = (ISNULL(oinv.debit,0)-ISNULL(orin.credit,0))/1.1,
Jan2010Total = (ISNULL(moinv.dMTD,0)-ISNULL(morin.cMTD,0))/1.1
FROM OCRD ocrd
LEFT JOIN (
SELECT cardcode, debit = SUM(DocTotal)
FROM oinv
WHERE DocDate BETWEEN '2010-01-01 00:00:00.000' AND '2010-12-31...
September 9, 2011 at 5:27 am
;WITH OrderedData AS (
SELECT
patient_id,
attendance_date,
rn = ROW_NUMBER() OVER (PARTITION BY patient_id ORDER BY attendance_date)
FROM PS_TestForOnline
)
SELECT *
FROM OrderedData v1 -- first visit
LEFT JOIN OrderedData v2...
September 9, 2011 at 4:28 am
The difference between two times isn't a time, it's a quantity. You could use an integer datatype to store the number of minutes difference between the two times - easily...
September 9, 2011 at 3:36 am
GSquared (9/8/2011)
...breeding dogs for 10,000 years has yet to produce a T-Rex...
Isn't it fortunate for us that this wasn't the intention from the outset?
September 9, 2011 at 3:21 am
Naked Ape (9/8/2011)
...about 1% of lizards are capable of parthenogenesis...
Including, surprisingly, the biggest. One convenient theory for Komodo parthenogenesis is their habitat - there's a higher probability of an island-dwelling...
September 9, 2011 at 3:17 am
The Dixie Flatline (9/8/2011)
The...
September 9, 2011 at 2:15 am
Viewing 15 posts - 6,646 through 6,660 (of 10,144 total)