ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,396 through 7,410 (of 10,143 total)

RE: Are the posted questions getting worse?

Brandie Tarvin (9/15/2010)
GilaMonster (9/15/2010)
Chris Morris-439714 (9/15/2010)
Paul White NZ (9/15/2010)
Chad Crawford (9/14/2010)
If only you and DEAD people can read Hex, how many people can read Hex?
Don't know. But I...
^{“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

September 15, 2010 at 8:55 am

#1221401
RE: Are the posted questions getting worse?

Paul White NZ (9/15/2010)
Chad Crawford (9/14/2010)
If only you and DEAD people can read Hex, how many people can read Hex?
Don't know. But I do know what an expired...
^{“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

September 15, 2010 at 8:15 am

#1221349
RE: Today's Random Word!

wiggles
^{“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

September 15, 2010 at 7:18 am

#1221308
RE: I want optimize the store procedure-It's take more time to excecute by use while loop

It's really inefficient code. Try this:
INSERT INTO #dgclassNew (eqpid, book_no, flag, dgclass)
SELECT d.cno, d.bno, d.flag, iTVF.dgclass
FROM @dgclassunique d
CROSS APPLY
(SELECT CAST(dgclass AS VARCHAR) + ','
FROM @dgclassunique
WHERE cno =...
^{“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

September 15, 2010 at 5:52 am

#1221258
RE: Are the posted questions getting worse?

Tom.Thomson (9/15/2010)
Stefan Krzywicki (9/14/2010)
CirquedeSQLeil (9/14/2010)
Alvin Ramard (9/14/2010)
GilaMonster (9/14/2010)
Grant Fritchey (9/14/2010)
GilaMonster (9/14/2010)
Lynn Pettis (9/14/2010)
The key to arguing with GilaMonster (or anyone for that matter) is:
A) Admit when you are wrong.
B) If...
^{“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

September 15, 2010 at 4:26 am

#1221222
RE: count on several colum

ilbric-762008 (9/15/2010)
Well, simply perfect!!
Actually I have a question... could you explain the following row, the first in the CTE statement?
SELECT [ColumnName] =...
^{“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

September 15, 2010 at 3:58 am

#1221207
RE: count on several colum

If you're unsure about any part of this, just ask 🙂
-- sample data (not part of the solution)
DROP TABLE #Sample
CREATE TABLE #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

September 15, 2010 at 3:05 am

#1221190
RE: count on several colum

There are numerous ways of getting the aggregates that you need, but how do you expect the output to look? If you run this, then you'll see what I mean:
DROP...
^{“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

September 15, 2010 at 2:24 am

#1221170
RE: Try...Catch not catching

I tried a slightly different tack, thinking that perhaps the conditional was screwed by the lack of a BEGIN-END block around the TRY-CATCH:
DECLARE @Splitter BIT
SET @Splitter = 1
IF @Splitter =...
^{“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

September 14, 2010 at 7:35 am

#1220669
RE: Today's Random Word!

Brandie Tarvin (9/14/2010)
pastries.
@sigh. Trying desperately to behave today.
Why get bored and give yourself a headache when you could be having fun?
^{“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

September 14, 2010 at 4:22 am

#1220553
RE: Are the posted questions getting worse?

Will The Thread be affected by the steeply-rising cost of cotton? Maybe...just a bit? 😀
^{“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

September 14, 2010 at 2:26 am

#1220517
RE: Needa Query to filter the matching records

Left join table B to table a. Nothing could be simpler.
^{“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

September 13, 2010 at 2:58 am

#1219902
RE: adding Column

cpinky01 (9/10/2010)
Thank you for your reply.
I got waht i wanted by using substring.
Thanks once agin for your reply.
@steve-2: I don't know about you but I'm totally lost.
^{“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

September 10, 2010 at 9:34 am

#1219288
RE: adding Column

Please edit the following code so that the values exactly match your table:
IF OBJECT_ID( 'tempdb..#MyTable') IS NOT NULL DROP TABLE #MyTable
CREATE TABLE #MyTable (PeriodDescription VARCHAR(20))
INSERT INTO #MyTable (PeriodDescription)
SELECT 'Q1 2009'...
^{“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

September 10, 2010 at 9:04 am

#1219258
RE: Calculations with SQL code

You mean like this?
SELECT BENCHMARK,
SUM(Number_of_INC) AS [Sum of Incumbents],
AVG(Number_of_INC) AS [Average of Incumbents],
AVG(AVG_SALARY) AS [Average Salary],
AVG(PAY_RANGE_MIN) AS [Average Pay Range Min],
AVG(PAY_RANGE_MIDPT) AS [Average Pay Range Mid],...
^{“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

September 10, 2010 at 8:46 am

#1219234

Viewing 15 posts - 7,396 through 7,410 (of 10,143 total)