ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,471 through 7,485 (of 10,143 total)

RE: filtering with a alias

Cristian Maidana-360609 (9/2/2010)
Hi, i was trying filtering a query with an alias, but it doesn't work
select a,b, (select count(*) as Tot from table2) as Tot
From table1
where (Tot > 0).
but 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

September 2, 2010 at 9:41 am

#1215712
RE: Today's Random Word!

Sunshine.
And warm, too. Not bad for the UK in September.
^{“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

September 2, 2010 at 9:05 am

#1215677
RE: Are the posted questions getting worse?

pin the tail to the donkey.
^{“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

September 2, 2010 at 8:51 am

#1215660
RE: Using CASE WHEN to return a logical value in WHERE clause

CASE is used with values, you are attempting to use CASE to build part of a statement. You could go the whole hog and perform the latter successfully using dynamic...
^{“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

September 1, 2010 at 7:58 am

#1214977
RE: Today's Random Word!

Ray K (9/1/2010)
Brandie Tarvin (9/1/2010)
Today's word: Filibuster
Ghostbuster
Mythbuster.
You still 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

September 1, 2010 at 7:22 am

#1214938
RE: Execution time difference when parameter is difference

stephenhai (9/1/2010)
My stored procedure has input parameter for branch id
if I provide the small branch (no of record is 1000), it takes 3 sec
if I provide the large branch (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

September 1, 2010 at 7:19 am

#1214929
RE: Today's Random Word!

Oh that Weird Al!
Must have been watching Deliverance the other night, put me off!
^{“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

September 1, 2010 at 4:29 am

#1214840
RE: Today's Random Word!

Brandie Tarvin (9/1/2010)
Oddly enough, I was thinking "Weird Al" when I posted "Eat it!" but Marathon Man works. @=)
Today's word: Filibuster
Horse Whisperer.
I'm old, Brandie - not heard of 'Weird Al'....
^{“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

September 1, 2010 at 4:14 am

#1214832
RE: Today's Random Word!

Brandie Tarvin (8/31/2010)
Eat it!
Marathon Man
^{“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

September 1, 2010 at 4:00 am

#1214821
RE: Today's Random Word!

CirquedeSQLeil (8/31/2010)
Chris Morris-439714 (8/31/2010)
Magic 🙂
Selena Gomez?
Had to Google 'cos she's not really known over here. My word she's pretty.
^{“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

September 1, 2010 at 3:29 am

#1214807
RE: Today's Random Word!

Just back from a tour of the battlefields of the Hundred Years' War - Ray, you won't believe how much better you will feel for a few days away. Magic...
^{“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

August 31, 2010 at 9:46 am

#1214432
RE: Today's Random Word!

Brandie Tarvin (8/31/2010)
doctor
Who?
^{“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

August 31, 2010 at 6:59 am

#1214232
RE: DATEADD

Jeff Moden (8/18/2010)
... I've had a whole lot of "well meaning" folks say that I'm a bit too "folksy" in my articles and that I should "write more professionally rather...
^{“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

August 20, 2010 at 9:11 am

#1209732
RE: Where are you?

sing4you (8/19/2010)
Ray K (8/19/2010)
alexmpd (8/19/2010)
Ray K (8/19/2010)
Where in Russia (just out of curiosity)?
Saint Petersburg
I would love to visit Russia someday. Maybe at some point, when I actually have money...
^{“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

August 20, 2010 at 8:23 am

#1209693
RE: Today's Random Word!

crookj (8/19/2010)
Ray K (8/19/2010)
sing4you (8/19/2010)
crookj (8/19/2010)
Steve Jones - Editor (8/19/2010)
Yikes!
Remind me not to ride the sky ride when I go down there again. Do not like heights.
Just note 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

August 20, 2010 at 8:05 am

#1209674

Viewing 15 posts - 7,471 through 7,485 (of 10,143 total)