ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,891 through 7,905 (of 10,143 total)

RE: using CASE in a WHERE clause

david.woulds (5/20/2010)
Chris, well it's basically determined by the current month which comes from:
datepart(month,getdate()) as I use this the get the FY start and end dates. I just need to incorporate...
^{“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

May 20, 2010 at 10:09 am

#1170288
RE: How to Remove duplicate records (rows)

;WITH SequencedTable AS (
SELECT GroupID = ROW_NUMBER() OVER (PARTITION BY cRightID ORDER BY cDesc)
FROM dbo.SMRights)
DELETE FROM SequencedTable WHERE GroupID > 1
-- Note that the choice of sort column is up...
^{“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

May 20, 2010 at 10:07 am

#1170283
RE: Today's Random Word!

Paul White NZ (5/20/2010)
Chris Morris-439714 (5/20/2010)
Paul White NZ (5/20/2010)
Dynamic SQL - versus - not very dynamic DBAs.
Hey Chris, what's with the paint tin avatar?
Paint tin? :Whistling:
Yeah.
And congratulations.
Huh?:ermm:
^{“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

May 20, 2010 at 10:02 am

#1170274
RE: Today's Random Word!

John Rowan (5/20/2010)
sing4you (5/20/2010)
Not pregnant 😀
Congrats! I'm happy for you too.
Oh John...I always thought you were one of us good guys...
^{“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

May 20, 2010 at 9:53 am

#1170260
RE: Today's Random Word!

Paul White NZ (5/20/2010)
Dynamic SQL - versus - not very dynamic DBAs.
Hey Chris, what's with the paint tin avatar?
Paint tin? :Whistling:
^{“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

May 20, 2010 at 9:52 am

#1170259
RE: using CASE in a WHERE clause

david.woulds (5/20/2010)
Chris, I tried the code you suggested might work, but doesn't seem to like the word DECLARE
I used your suggestion re WHERE datepart(month,getdate()) >3 and the following 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

May 20, 2010 at 9:49 am

#1170249
RE: Today's Random Word!

dbowlin (5/20/2010)
Steve Jones - Editor (5/20/2010)
Chores
Never ending.
Good Lord! Lighten up, guys!
^{“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

May 20, 2010 at 9:37 am

#1170229
RE: How to Remove duplicate records (rows)

wmalik001 (5/20/2010)
Guys, thank you for your reply,
But i am getting this error:
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE...
^{“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

May 20, 2010 at 9:35 am

#1170225
RE: using CASE in a WHERE clause

Hi David
I've no idea whether or not BO would permit the use of variables, however, they will certainly assist you in creating and debugging a SQL statement - after which,...
^{“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

May 20, 2010 at 9:11 am

#1170197
RE: using CASE in a WHERE clause

Using @variables makes the code much easier to read - for the purposes of figuring out the problem, if nothing else. The same applies to using table aliases - 'p'...
^{“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

May 20, 2010 at 8:36 am

#1170164
RE: How to Remove duplicate records (rows)

;WITH SequencedTable AS (
SELECT GroupID = ROW_NUMBER() OVER (PARTITION BY DuplicateColumn1, DuplicateColumn2, ...)
FROM dbo.SMRights)
DELETE FROM SequencedTable WHERE GroupID > 1
^{“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

May 20, 2010 at 8:16 am

#1170151
RE: Today's Random Word!

sing4you (5/20/2010)
Not pregnant 😀
Speak to Barry - he's got his modulus back 😀
^{“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

May 20, 2010 at 7:16 am

#1170096
RE: Today's Random Word!

Paul White NZ (5/20/2010)
Know-nothing lazy **** boneheads!!!!!!!!
/vent
Sounds like the outlaws. Wassup Paul?
^{“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

May 20, 2010 at 5:29 am

#1170019
RE: Today's Random Word!

RBarryYoung (5/19/2010)
Chris Morris-439714 (5/19/2010)
Young's modulus
Yes, and I'd appreciate your returning it too. 😛
:-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

May 20, 2010 at 2:14 am

#1169920
RE: Today's Random Word!

John Rowan (5/19/2010)
Chris Morris-439714 (5/19/2010)
Pregnant
Contrats Chris! I'm happy for you.
Heh that would be a medical first! Sure would surprise 'er indoors too!
^{“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

May 20, 2010 at 2:13 am

#1169918

Viewing 15 posts - 7,891 through 7,905 (of 10,143 total)