ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,311 through 8,325 (of 10,143 total)

RE: StoreProcedure not reteurning any rows which containg local variables

Lynn Pettis (12/22/2009)
Let's take another step back. Help us help you, read the first the article I have referenced below in my signature block. Follow the instructions 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 22, 2009 at 7:42 am

#1095405
RE: StoreProcedure not reteurning any rows which containg local variables

abcim (12/22/2009)
>> are the values of RowID unique within the table
No
>> are they always unique within a single [ReportId]
Yes
Thanks. Last question, I think: for each RowID in the table Maturity_Detail,...
^{“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 22, 2009 at 7:39 am

#1095403
RE: StoreProcedure not reteurning any rows which containg local variables

Cool - now the biggie: are the values of RowID unique within the table?
If not, are they always uniquewithin a single [ReportId]?
^{“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 22, 2009 at 7:11 am

#1095384
RE: Are the posted questions getting worse?

GilaMonster (12/22/2009)
Merry Christmas everyone.
Since I didn't manage to finish the christmas scene for this year, have one from a couple years back.
It's a pretty picture - but many will feel...
^{“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 22, 2009 at 6:58 am

#1095377
RE: StoreProcedure not reteurning any rows which containg local variables

abcim (12/22/2009)
Thanks
52 Rows
Is this 52 weeks, or is the 52 just a concidence?
^{“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 22, 2009 at 6:55 am

#1095376
RE: StoreProcedure not reteurning any rows which containg local variables

abcim (12/22/2009)
Thanks
52 Rows
How many different values of RowID do you have?
^{“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 22, 2009 at 6:54 am

#1095375
RE: StoreProcedure not reteurning any rows which containg local variables

abcim (12/22/2009)
I think this is very nice but the problem is that there is not a single Row. So @local_variable must NOT be used to SELECT Query to return...
^{“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 22, 2009 at 6:41 am

#1095365
RE: Are the posted questions getting worse?

Alvin Ramard (12/22/2009)
I'm about to go offline for the next week or two, so it's time to wish y'all a very Merry Christmas and a Happy New Year.
🙂
Merry...
^{“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 22, 2009 at 5:50 am

#1095342
RE: StoreProcedure not reteurning any rows which containg local variables

abcim (12/22/2009)
Are you sure (Good Catch)
then why this works 100%,
DECLARE @a int
DECLARE @b-2 int
SELECT @a=1,@b=ISNUMERIC(@a)
SELECT @a,@b
You really don't want to use the "quirky update" trick for this
@ variable
Is 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 22, 2009 at 5:22 am

#1095334
RE: StoreProcedure not reteurning any rows which containg local variables

lmu92 (12/22/2009)
You could use CTEs (common table expressions) to determine @Total2 (see BOL for details).
This would make the whole query much more readable and most probably would make it more...
^{“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 22, 2009 at 4:52 am

#1095327
RE: StoreProcedure not reteurning any rows which containg local variables

abcim (12/22/2009)
I have the given SP which contains variables, but it never returns any rows
The variables are necessary because they are used at different places.
@Difference will always return NULL
@Total2...
^{“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 22, 2009 at 4:29 am

#1095323
RE: Query

khandaresarang (12/22/2009)
Hi all,
I created a table in which there r n fields and in that two of them are date field i.e., startdate and enddate.
Now 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

December 22, 2009 at 3:14 am

#1095307
RE: Inserting data into very first and very last row

Even if there were a way to do this with any certainty (and reproducibility / reliability) without changing your table structure, why would you want to? If you can provide...
^{“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 22, 2009 at 3:12 am

#1095305
RE: My code

Ray K (12/21/2009)
Chris Morris-439714 (12/21/2009)
So what? We've known for years that the answer is 42.
Yes, but what is the actual question? 🙂
Rumour has it that someone is deep in thought...
^{“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 21, 2009 at 9:23 am

#1094855
RE: "OR" statement in JOIN query

SELECT a.GROUPNUMBER, a.SSN,
ISNULL(b1.FIRSTNAME, b.FIRSTNAME) AS FIRSTNAME,
ISNULL(b1.LASTNAME, b.LASTNAME) AS LASTNAME
FROM tblNewData a
LEFT OUTER JOIN tblExistingData b1
ON b1.GROUPNUMBER =...
^{“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 21, 2009 at 8:50 am

#1094814

Viewing 15 posts - 8,311 through 8,325 (of 10,143 total)