ChrisM@Work

Forum Replies Created

Viewing 15 posts - 6,871 through 6,885 (of 10,143 total)

RE: Recursive CTE - Am I going mad???

kp81 (3/11/2011)
Let it be said Ian...you're a legend!
I've just run it up and it's spot on what I need. I think the key was also in the
case when...
^{“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

March 11, 2011 at 4:43 am

#1297530
RE: Complex Query

BeginnerBug (3/9/2011)
create table #sample(sno int identity,student_no int, head int,task varchar(50))
insert into #sample (student_no,head,task) values(1,10,'tactical')
insert into #sample (student_no,head,task) values(10,20,'basket')
insert into #sample (student_no,head,task) values(20,40,'aerospace')
insert into #sample (student_no,head,task) values(40,10,'robot')
insert into #sample (student_no,head,task) values(10,40,'tackle')
insert...
^{“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

March 9, 2011 at 7:07 am

#1296482
RE: Union Query Total

Jeff Moden (3/9/2011)
Chris Morris-439714 (3/9/2011)
clarmatt73 (3/9/2011)
Hi All,
I have a stored procedure that has five union queries within it, the first and last queries in the code are the Header and...
^{“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

March 9, 2011 at 6:11 am

#1296447
RE: Union Query Total

You're welcome Matt. If you're still unsure, post up the whole query.
^{“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

March 9, 2011 at 5:31 am

#1296421
RE: Union Query Total

clarmatt73 (3/9/2011)
Hi All,
I have a stored procedure that has five union queries within it, the first and last queries in the code are the Header and Footer for the export...
^{“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

March 9, 2011 at 4:35 am

#1296409
RE: Are the posted questions getting worse?

Gianluca Sartori (3/9/2011)
Koen Verbeeck (3/8/2011)
Tom.Thomson (3/8/2011)
Kiara (3/8/2011)
Koen Verbeeck (3/8/2011)
First of all, as it is international woman day, congrats to all those woman out here!
(who for some bizarre reason love to...
^{“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

March 9, 2011 at 2:18 am

#1296366
RE: inner join returns cartesian product why?

Michael Tocik (3/8/2011)
dope!:blush:
My mistake....I was joining on the wrong field
Easily done. Try to get into the habit of using table aliases:
SELECT i.order_number
FROM INVOICE_DETAIL_CONF_ALL i
INNER JOIN ORDER_EXTRACT_AUTO o
ON o.[Ord No]...
^{“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

March 8, 2011 at 4:59 am

#1295775
RE: Are the posted questions getting worse?

SQLkiwi (3/4/2011)
Exciting day - just had my first Simple Talk article published:
http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Good lord Paul, they get better and better. You have an enviable skill, like Jeff M, at making 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

March 7, 2011 at 9:22 am

#1295399
RE: Are the posted questions getting worse?

Dave Ballantyne (3/4/2011)
SQLkiwi (3/4/2011)
Plagiarism is when you're pretending the work is your own and not giving proper credit.
Copyright infringement is when you're reprinting the work without permission.
It is possible to...
^{“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

March 4, 2011 at 5:17 am

#1294571
RE: 'Pretty-up' the code

Try this as an alternative:
;WITH CTE_Filter AS (
SELECT drugid
FROM dphadrugdata d
WHERE d.usagetype LIKE '%Non%'
AND d.active = 'Y'
GROUP BY drugid -- <<<---- dedupes, might not need this
) ...
^{“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

March 2, 2011 at 7:15 am

#1293481
RE: Extra space in string pivot CTE

Jim, here's an alternative method. Assuming your new codes are in column A then insert the following into B1 and B2:
="SELECT '" & A1 & "' AS NewCode UNION ALL"
="SELECT...
^{“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

March 2, 2011 at 6:52 am

#1293466
RE: Are the posted questions getting worse?

CirquedeSQLeil (3/1/2011)
Fal (3/1/2011)
David Benoit (3/1/2011)
Grant Fritchey (3/1/2011)
Well do you want video or just pictures?
Just don't put either on The Thread. Please... 😀
Hey, I thought only code was barred on 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

March 2, 2011 at 3:21 am

#1293392
RE: Are the posted questions getting worse?

GSquared (2/28/2011)
Jeff Moden (2/25/2011)
SQLkiwi (2/22/2011)
Steve Jones - SSC Editor (2/22/2011)
On a similar debating note, does anyone know of code in SQL Server that's worth protecting with CLR, obfuscation, or any...
^{“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

February 28, 2011 at 7:01 am

#1292285
RE: Today's Random Word!

Daniel Bowlin (2/23/2011)
Focus
Hocus Pocus
^{“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

February 23, 2011 at 6:53 am

#1290359
RE: Today's Random Word!

Peter Trast (2/9/2011)
Tom.Thomson (2/9/2011)
CirquedeSQLeil (2/9/2011)
Brandie Tarvin (2/9/2011)
CirquedeSQLeil (2/9/2011)
Histogram
Diagram
pentogram
epigram
Epidural
Durian
^{“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

February 10, 2011 at 5:55 am

#1285106

Viewing 15 posts - 6,871 through 6,885 (of 10,143 total)