ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,966 through 7,980 (of 10,143 total)

RE: Are the posted questions getting worse?

GSquared (4/22/2010)
jcrawf02 (4/22/2010)
Grant Fritchey (4/22/2010)
jcrawf02 (4/21/2010)
Pity that Brent will get kicked out of the MVP club so soon after his MCM... 😛
And now for something completely different...
Any advice on ridding...
^{“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

April 23, 2010 at 2:30 am

#1156664
RE: Are the posted questions getting worse?

Paul White NZ (4/22/2010)
Chris Morris-439714 (4/22/2010)
Well I can't see what you're on about. Must be a rare defect of the optic nerve.
SOM
Som, an alternative name for the Hungarian wine grape...
^{“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

April 22, 2010 at 6:56 am

#1156062
RE: Are the posted questions getting worse?

jcrawf02 (4/22/2010)
Grant Fritchey (4/22/2010)
jcrawf02 (4/21/2010)
Pity that Brent will get kicked out of the MVP club so soon after his MCM... 😛
And now for something completely different...
Any advice on ridding my...
^{“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

April 22, 2010 at 6:52 am

#1156053
RE: Today's Random Word!

jcrawf02 (4/22/2010)
Chris Morris-439714 (4/22/2010)
jcrawf02 (4/21/2010)
Taraxacum
Salad
Dressing?
Undressing - see water cooler thread 😉
^{“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

April 22, 2010 at 6:38 am

#1156035
RE: Are the posted questions getting worse?

Paul White NZ (4/22/2010)
CirquedeSQLeil (4/21/2010)
Now, does anybody know how to get rid of morning glory?
:blink:
Check the last definition: http://en.wikipedia.org/wiki/Morning_glory_(disambiguation)
:blink:
Well I can't see what you're on about. Must be a rare...
^{“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

April 22, 2010 at 5:34 am

#1155991
RE: Today's Random Word!

jcrawf02 (4/21/2010)
Taraxacum
Salad
^{“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

April 22, 2010 at 2:10 am

#1155901
RE: Today's Random Word!

dbowlin (4/21/2010)
relax
Don't do it
^{“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

April 21, 2010 at 8:10 am

#1155357
RE: Are the posted questions getting worse?

Tom.Thomson (4/20/2010)
Gianluca Sartori (4/20/2010)
Thanks, Tom. So, you're a Scot, aren't you?
Well, I used to be a Scot. But I got married so now I'm a slave. 😀
LOL! That's set...
^{“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

April 21, 2010 at 2:15 am

#1155170
RE: Transpose Single column into Multiple column

karthikeyan-444867 (4/20/2010)
i think i need to study how PIVOT is working internally...because the concept is unclear for me...
if anybody explain it little bit more,it would help me....
PIVOT (MAX(Item) FOR StringPos...
^{“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

April 20, 2010 at 6:59 am

#1154525
RE: define composite primary key with more than 900 bytes

Tom.Thomson (4/19/2010)
Jeff Moden (4/18/2010)
I still can't believe that someone needs a 70 column primary key. Without actually understanding the table at hand, I believe that some normalization would be...
^{“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

April 20, 2010 at 2:28 am

#1154385
RE: Today's Random Word!

CirquedeSQLeil (4/19/2010)
Kringer
Without Googling, this has to be a flavourless colourless sweetish lager served freezing cold to impressionable teens 😛
^{“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

April 19, 2010 at 10:06 am

#1153948
RE: Are the posted questions getting worse?

I went to one of those male griming parlours at the weekend. They give you a beer and you sit for 20 minutes while they fiddle with your fingernails, putting...
^{“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

April 19, 2010 at 6:55 am

#1153772
RE: Are the posted questions getting worse?

Paul White NZ (4/18/2010)
RBarryYoung (4/18/2010)
Yes, in binary. 😀
010110010110010101110011
("yes" in binary)
Chortle 😀
^{“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

April 19, 2010 at 2:13 am

#1153638
RE: Problem in INSERT statement :(

lmu92 (4/16/2010)
Chris Morris-439714 (4/16/2010)
...
This is what happens when you moonlight as a shower-curtain salesman, Lutz 😛
...
Are you not satisfied working with SQL anymore? And do you sell knifes as well...
^{“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

April 19, 2010 at 2:08 am

#1153634
RE: Today's Random Word!

mbricker-600840 (4/16/2010)
hypogycemia
You missed a letter out in all the excitement.
^{“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

April 16, 2010 at 8:51 am

#1152894

Viewing 15 posts - 7,966 through 7,980 (of 10,143 total)