ChrisM@Work

Forum Replies Created

Viewing 15 posts - 5,281 through 5,295 (of 10,143 total)

RE: Are the posted questions getting worse?

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....
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 31, 2013 at 6:36 am

#1582964
RE: Max function without group by

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."
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 31, 2013 at 1:54 am

#1582802
RE: Proper way to concatenate values in a set from 1 column

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. ...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 31, 2013 at 1:35 am

#1582794
RE: Max function without group by

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.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 31, 2013 at 1:06 am

#1582785
RE: Are the posted questions getting worse?

Chad Crawford (1/30/2013)
I have to share my excitement. I taught a class here at work to help employees prepare for the Microsoft 70-461 test. So far 6...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 31, 2013 at 12:59 am

#1582783
RE: URGENT T- SQL QUESTION. NEED HELP.

Mr. Kapsicum (1/30/2013)
...
i want my query to use BOTH ISNULL and COALESCE...
Only homework would impose such a restriction.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 30, 2013 at 5:55 am

#1582570
RE: Turning Scan into Seek...

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 29, 2013 at 9:32 am

#1582220
RE: Strange Behavior In Insert

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 29, 2013 at 6:20 am

#1582081
RE: Strange Behavior In Insert

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 29, 2013 at 6:06 am

#1582074
RE: Nested replaces ?

Abu Dina (1/28/2013)
I have a one table which contains various noise words which I would like to remove from the company name field before I generate my phoentic code. The...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 28, 2013 at 8:35 am

#1581662
RE: Nested replaces ?

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 28, 2013 at 8:21 am

#1581648
RE: Returning Selective numbers

zahid_7777 (1/28/2013)
nchar
Thanks.
WHERE RIGHT(ACTCODE,3) <> '000'
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 28, 2013 at 5:20 am

#1581559
RE: Returning Selective numbers

What datatype is actcode?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 28, 2013 at 1:45 am

#1581455
RE: Unexpected behaviour of query

-- 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]...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 28, 2013 at 1:21 am

#1581440
RE: Check for existence of a single value for all rows in a column

Thanks for the sample data. Try this:
-- Sample data
DROP TABLE [dbo].[MisIcg_InteractionChecks]
CREATE TABLE [dbo].[MisIcg_InteractionChecks](
[SourceID] [varchar](3) NOT NULL,
[MisIcgID] [varchar](30) NOT NULL,
[InteractionID] [varchar](25) NOT NULL,
[RowUpdateDateTime] [datetime] NULL,
[InteractionCheckMedication] [varchar](2)...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 25, 2013 at 8:17 am

#1581070

Viewing 15 posts - 5,281 through 5,295 (of 10,143 total)