ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,061 through 9,075 (of 10,143 total)

RE: How can I change this stored procedure to get the desired result

Hi Arun
as regular SQL it will look like this...
SELECT r.resolution, ISNULL(sq.CaseCount, 0) As CaseCount
FROM tlkResolution r
LEFT JOIN (SELECT c.resolutionID, Count(Distinct c.caseID) As CaseCount
...
^{“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 19, 2008 at 8:32 am

#915348
RE: Are the posted questions getting worse?

ALZDBA (12/19/2008)
Finaly we are getting to the essence of being :w00t::w00t:
beer and food 🙂
I prefere a very good Geuze Lambic (the bottle with natural cork please) :smooooth:
I'm not that...
^{“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 19, 2008 at 7:55 am

#915304
RE: Subquery not working giving error - Only one expression can be specified

arun.samuel (12/19/2008)
Great. It works! 🙂
Thanks a bunch.
Arun
Arun, please could you post your final working code? Not only does it finish the thread nicely, it may also stand as...
^{“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 19, 2008 at 7:33 am

#915285
RE: Person data- Multiple rows due to more than 1 name. Automatic Numbering of rows

If you can figure out the rules, it shouldn't be too hard to figure out the code.
^{“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 19, 2008 at 7:31 am

#915279
RE: Person data- Multiple rows due to more than 1 name. Automatic Numbering of rows

Debbie Edwards (12/19/2008)
Thanks :ermm:
I think the best thing I can do is try to figure out another simpler way, Im out of my league a bit here.
Im hoping there may...
^{“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 19, 2008 at 7:03 am

#915237
RE: Are the posted questions getting worse?

Grant Fritchey (12/19/2008)
Nothing wrong with both beer and a good scotch. Preferably some incredibly hoppy IPA or ESB and some Scapa.... mmmm... Oh, look at the time. The sun just...
^{“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 19, 2008 at 6:49 am

#915213
RE: Subquery not working giving error - Only one expression can be specified

arun.samuel (12/19/2008)
I would like to get this script to work, it keeps saying:
"Only one expression can be specified in the select list when the subquery is not introduced with EXISTS."
Here...
^{“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 19, 2008 at 6:04 am

#915168
RE: Are the posted questions getting worse?

Someone said beer I swear...
Nicest beer this week was Blue Moon wheat beer from Denver, CO, purchased from Sainsbury's, Reading, UK.
^{“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 19, 2008 at 5:53 am

#915157
RE: Multi line Table-value function much slower then executing body SQL (2008)

ddorfman (12/19/2008)
Hi
I can see that it would be difficult to assess my problem from the chunk of code i placed down. But i can assure you the only difference...
^{“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 19, 2008 at 5:49 am

#915155
RE: Person data- Multiple rows due to more than 1 name. Automatic Numbering of rows

Debbie Edwards (12/19/2008)
Ahhhh
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT...
^{“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 19, 2008 at 5:15 am

#915131
RE: group by and difference

ALZDBA (12/19/2008)
same player shoot again ... hit ball when lights are on ...
:D:D
^{“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 19, 2008 at 5:11 am

#915129
RE: Person data- Multiple rows due to more than 1 name. Automatic Numbering of rows

Debbie Edwards (12/19/2008)
Im on SQL Server 2005.
Is there another way around this issue without using Partition?
Debbie
Debbie, I can see from some of your earlier posts that 2k5-specific code invariably fails...
^{“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 19, 2008 at 5:07 am

#915127
RE: string function

mdowns (12/19/2008)
But that's not going to give you what you said you want. I'm debugging this in my head but if both strings have 10 digits then the "select" is...
^{“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 19, 2008 at 4:46 am

#915114
RE: Person data- Multiple rows due to more than 1 name. Automatic Numbering of rows

Debbie Edwards (12/19/2008)
Thanks for that. Ive tried it but Im getting
Msg 195, Level 15, State 10, Line 1
'ROW_NUMBER' is not a recognized function name.
Debbie
It's a SQL Server 2005 function, 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

December 19, 2008 at 4:43 am

#915113
RE: group by and difference

santosh.lamane (12/19/2008)
no it doesnt work
Could you elaborate please, Santosh? Post the code, and the error message? Thanks.
^{“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 19, 2008 at 4:37 am

#915108

Viewing 15 posts - 9,061 through 9,075 (of 10,143 total)