ChrisM@Work

Forum Replies Created

Viewing 15 posts - 6,931 through 6,945 (of 10,143 total)

RE: Selecting a Value of the Order Within a Group

Better late than never. Last I heard, dkrumholtz was growing organic root crops on a plot outside Seattle.
^{“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

December 7, 2010 at 6:45 am

#1259502
RE: join - on problem

Kit G (12/2/2010)
I think you need an alias name for that select statement on the LEFT OUTER JOIN.
Looks about right to me too.
Table aliases throughout would be ideal.
^{“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

December 7, 2010 at 6:41 am

#1259500
RE: Error turning Varchar into Numeric

Hi James
Firstly, ISNUMERIC() has limitations - it returns true (1) if the value can be converted into a number. SSC has a recent article covering its limitations.
Secondly, the filters in...
^{“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

December 7, 2010 at 5:27 am

#1259469
RE: SELECT data for today's date

A Little Help Please (12/7/2010)
I have a table which has a column called TimeStarted.
The formate of the date in this column is YYYY-MM-DD HH:MM:SS
Are you saying the column holds a...
^{“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

December 7, 2010 at 3:23 am

#1259434
RE: Calculate accumulated with the over ()

alecio (12/6/2010)
What I need is a sum of values, taking the previous value and adding to the next.
RANK () OVER (PARTITION BY ORDER BY DATE ASC CODIGO_PESSOA, SUM (VALUE)) 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

December 6, 2010 at 7:11 am

#1258999
RE: Today's Random Word!

Brandie Tarvin (12/6/2010)
Flimflam
Arsenic
^{“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

December 6, 2010 at 6:56 am

#1258989
RE: Calculate accumulated with the over ()

alecio (12/6/2010)
How to make a calculation by adding values to the example OVER ... ..
1 - 10 - 10,
2 - 20 - 30.
Can we have a few more sample...
^{“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

December 6, 2010 at 6:42 am

#1258980
RE: Select record with multiple rows in each rank after dense_rank

SELECT Col1, Col2, Col3, Dense_Rank_Column, COUNT(*)
FROM (
Col1 Col2 Col3 Dense_Rank_Column = [Dense_Rank]
.. .. .. 1
.. .. .. 2
.. .. .. 2
.. .. .. 1
) d
GROUP BY Dense_Rank_Column
HAVING COUNT(*) >...
^{“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

December 6, 2010 at 4:36 am

#1258946
RE: ISNULL of an INTEGER

It's an example of implicit conversion
SELECT CAST('' AS INT)
^{“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

December 3, 2010 at 9:05 am

#1258470
RE: Update with Joins

Fix the obvious syntax error, then use table aliases throughout the CASE construct.
^{“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

December 3, 2010 at 8:43 am

#1258450
RE: Update with Joins

UPDATE TEST SET
B = CASE
WHEN (CASE WHEN ISNULL(S,0) <> 0 THEN G * H END) = 0 THEN NULL
ELSE (G + K END)
END
FROM TEST T
INNER JOIN #L TP
ON
T.A1...
^{“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

December 3, 2010 at 8:29 am

#1258439
RE: Using CASE in a WHERE clause

GSquared (12/3/2010)
Chris Morris-439714 (12/3/2010)
GSquared (12/3/2010)
select * from dbo.MyTable where @Parameter = 'A' or (ParentTradeID is not null and @Parameter = 'O')
or (ParentTradeID is null and @Parameter = 'R');
Wouldn't that do it?
Hey Gus,...
^{“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

December 3, 2010 at 7:04 am

#1258385
RE: Cumulative Index

I'm sorry but it's impossible to understand the requirement here. It's not the language barrier between English and Portuguese, it's the lack of clarity and information. Would you be able...
^{“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

December 3, 2010 at 7:02 am

#1258384
RE: replicating records w/o using a cursor

Brandie Tarvin (12/3/2010)
Chris Morris-439714 (12/3/2010)
What folks often forget about tally tables is that they are a source of rows as well as numbers.
I've actually used a Tally Table to do...
^{“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

December 3, 2010 at 6:47 am

#1258370
RE: replicating records w/o using a cursor

Much simpler than you think - join to a tally table on dbo.SOP10200.QUANTITY.
What folks often forget about tally tables is that they are a source of rows as well...
^{“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

December 3, 2010 at 6:38 am

#1258361

Viewing 15 posts - 6,931 through 6,945 (of 10,143 total)