Viewing 15 posts - 5,281 through 5,295 (of 10,144 total)
Bill Talada (1/31/2013)
January 31, 2013 at 7:04 am
L' Eomot Inversé (1/31/2013)
BrainDonor (1/30/2013)
jasona.work (1/30/2013)
Now, you want a topic that would *really* generate some responses, start a Star Trek vs Star Wars topic,Babylon 5 or nothing.
Blake's 7 was better....
January 31, 2013 at 6:36 am
Bhuvnesh (1/31/2013)
ChrisM@Work (1/31/2013)
MAX() OVER (PARTITION BY...) might be more appropriate.New to me 🙂
From BOL [Aggregate Functions (Transact-SQL)]: "The OVER clause may follow all aggregate functions except CHECKSUM."
January 31, 2013 at 1:54 am
dwain.c (1/30/2013)
ScottPletcher (1/30/2013)
No, no syntax errors per se, but that method's not guaranteed to work safely either.
Scott - Can you explain this?
I understand that ordering may be an issue. ...
January 31, 2013 at 1:35 am
Bhuvnesh (1/31/2013)
Using ROW_NUMBER() with PARTITION .See http://msdn.microsoft.com/en-us/library/ms186734.aspx
MAX() OVER (PARTITION BY...) might be more appropriate.
January 31, 2013 at 1:06 am
Chad Crawford (1/30/2013)
January 31, 2013 at 12:59 am
Mr. Kapsicum (1/30/2013)
...i want my query to use BOTH ISNULL and COALESCE...
Only homework would impose such a restriction.
January 30, 2013 at 5:55 am
How many rows in the table? How many rows are you returning? If you are returning more than say 25%* of the rows in the table, SQL Server may calculate...
January 29, 2013 at 9:32 am
chandan_jha18 (1/29/2013)
ChrisM@Work (1/29/2013)
chandan_jha18 (1/29/2013)
...Though it may sound simple, I need to find out why. Please come up with your inputs.
Take away the unnecessary tables and use variables in the exact...
January 29, 2013 at 6:20 am
chandan_jha18 (1/29/2013)
...Though it may sound simple, I need to find out why. Please come up with your inputs.
Take away the unnecessary tables and use variables in the exact same way:
DECLARE...
January 29, 2013 at 6:06 am
Abu Dina (1/28/2013)
January 28, 2013 at 8:35 am
Is it a "fixed" list? I guess what I mean by that is - would it be useful to you to have a function which contained the list definition, rather...
January 28, 2013 at 8:21 am
zahid_7777 (1/28/2013)
nchar
Thanks.
WHERE RIGHT(ACTCODE,3) <> '000'
January 28, 2013 at 5:20 am
-- This looks correct:
SELECT
ERP_ID,
customer_number,
ANNUAL_CONTRACT_PRICE,
[Rank]
FROM (
SELECT
ERP_ID,
customer_number,
ANNUAL_CONTRACT_PRICE,
ROW_NUMBER() OVER (PARTITION BY customer_number ORDER BY ANNUAL_CONTRACT_PRICE DESC) AS [Rank]
FROM EMEA_SERVICEMAX.Servicemax.SERVICE_CONTRACTS_STG
WHERE CONTRACT_START_DATE >= GETDATE()-730
AND CONTRACT_STATUS_DESCRIPTION NOT IN ('Free','Canceled','Cancelled')
) a
WHERE a.[rank]...
January 28, 2013 at 1:21 am
Viewing 15 posts - 5,281 through 5,295 (of 10,144 total)