ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,656 through 8,670 (of 10,143 total)

RE: deleting some rows leaving one.

There's a DELETE...FROM lurking in here:
SELECT DISTINCT a.ApplicationID, n.PN, p.PartNumber, c.GenCategoryID
FROM ApplicationProduct ap (nolock)
INNER JOIN Application a
ON ap.ApplicationID = a.ApplicationID
INNER JOIN Product p
ON ap.ProductControlID = p.ProductControlID
INNER JOIN...
^{“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 23, 2009 at 10:55 am

#964597
RE: SQL GROUP statement

munderhill73525 (3/23/2009)
Using the Employees table below how would you select by Last_name and group by Salary within EE01_Classification?
If you group by salary alone, you're saying "return one row per salary...
^{“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 23, 2009 at 3:31 am

#964287
RE: Are the posted questions getting worse?

mazzz (3/21/2009)
Well, the beer festival was much fun (although my head would disagree this morning). I partook in Ale Caesar, Mad March Bear, Black Dog, Dark Brains among others, but...
^{“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 22, 2009 at 3:33 am

#964084
RE: Being More Productive

Hyperdata (3/20/2009)
Oddly enough, vitamins! For some reason, I get distracted easily, by the internet & emails(SSC). I forget which of the 10 to 15 things I was...
^{“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 20, 2009 at 10:23 am

#963659
RE: Are the posted questions getting worse?

Bob Hovious (3/20/2009)
In Park City, Utah, they brew Polygamy Porter, in deference to the early Mormons.
Motto: Why have just one?
very funny!
One of my favourites - namewise anyway...
^{“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 20, 2009 at 10:08 am

#963641
RE: Hanged on some of the querries do help......

Please provide table creation scripts, some relevant easily-consumed sample data and a table showing your expected output. If you're not sure how to do this, read the link below.
^{“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 20, 2009 at 9:56 am

#963631
RE: Are the posted questions getting worse?

mazzz (3/20/2009)
Grant Fritchey (3/20/2009)
I haven't sat down to a hand-drawn real ale since 1993... so... I hate you all. I hope they have nothing left but Coors.
I think the mere...
^{“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 20, 2009 at 8:13 am

#963538
RE: Are the posted questions getting worse?

mazzz (3/20/2009)
Chris Morris (3/20/2009)
mazzz (3/20/2009)
Is that Sainsbury's, UK?
If so I must investigate
Yep and if you're London-based it gets better 😎
Leeds-based, so I'm off here this evening: Leeds beer festival[/url] 😀
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 20, 2009 at 6:40 am

#963472
RE: Are the posted questions getting worse?

mazzz (3/20/2009)
Is that Sainsbury's, UK?
If so I must investigate
Yep and if you're London-based it gets 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

March 20, 2009 at 6:03 am

#963440
RE: Are the posted questions getting worse?

Derek Dongray (3/20/2009)
Lynn Pettis (3/19/2009)
Derek Dongray (3/19/2009)
Anyway, while I'm willing to offer some 'keyhole' fixes, I don't want to argue over a redesign of someone else's system (especially as they...
^{“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 20, 2009 at 5:34 am

#963426
RE: T-Sql rant

Lynn Pettis (3/18/2009)
I wrap my entire store procedures in a BEGIN END block, why? It clearly delineates the stored procedure for one. Also, somewhere in another thread, 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

March 18, 2009 at 11:14 am

#962117
RE: T-Sql rant

foxjazz (3/18/2009)
{} is much better than BEGIN BEGIN BEGIN BEGIN END END END END
Heh quite possibly - but the count of BEGIN - END pairs goes right down once people...
^{“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 18, 2009 at 10:33 am

#962080
RE: Multiple Values in Case statement

A separate case for each expression will do the trick:
SET colMask = ISNULL(NULLIF(
CASE WHEN ((b.col3 % 8) /4) >= 1 THEN 'Submit ' ELSE '' END +
CASE WHEN ((b.col3...
^{“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 18, 2009 at 7:43 am

#961869
RE: If then Else Statements (sum as well)

In the article which Gail referred you to earlier, this is described as "The Wrong Way to Post Data". Please read the article, it will only take three or four...
^{“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 18, 2009 at 7:00 am

#961801
RE: Are the posted questions getting worse?

Grant Fritchey (3/18/2009)
I'm going to hell for this one, I just know it.
I was checking up on the status of what I think is a bug that I posted 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 18, 2009 at 5:44 am

#961731

Viewing 15 posts - 8,656 through 8,670 (of 10,143 total)