ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,896 through 8,910 (of 10,143 total)

RE: Are the posted questions getting worse?

You can say that again 😀
^{“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

January 19, 2009 at 6:56 am

#929193
RE: convert DateTime to BigInt

munishprathap (1/19/2009)
its a new table didnt hav any values in that column.
assume that column 1 has Id as bigint ,column 2 has Date as datetime
my aim is to alter 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

January 19, 2009 at 6:18 am

#929165
RE: Using Replace Function

When comp_indcode contains more than one value, it's a comma-delimited list and this won't work: capt_code = comp_indcode . This isn't because there are pesky commas everywhere, it's because you...
^{“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

January 19, 2009 at 6:15 am

#929164
RE: convert DateTime to BigInt

munishprathap (1/19/2009)
i need to convert DateTime to BigInt through query in SQL
plz let me know
What does this column presently contain? Can you post a range of values?
^{“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

January 19, 2009 at 6:00 am

#929148
RE: Top N sub query workaround - Does it exist?

Oops...try MIN 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

January 16, 2009 at 9:22 am

#928266
RE: Top N sub query workaround - Does it exist?

Hi Krypto
Which solution did you decide to use? Would it be possible for you to post it, for the potential benefit of others who may experience the same or 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

January 16, 2009 at 7:31 am

#928121
RE: Top N sub query workaround - Does it exist?

This may be doable with a preaggregated derived table instead of a correlated subquery:
-- current query
SELECT e.coCRN, e.deptCRN, e.county, e.orderNo, MAXuserID = (SELECT TOP 1 userID FROM #events e2
WHERE...
^{“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

January 16, 2009 at 6:17 am

#928021
RE: Are the posted questions getting worse?

Adi Cohn (1/16/2009)
Actually when you have legal weapons there are procedures in air lines that lets you fly with your weapons. You won’t be able to have any weapons...
^{“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

January 16, 2009 at 5:03 am

#927965
RE: Are the posted questions getting worse?

Steve Jones - Editor (1/15/2009)
Well it is steel, and likely move's fast in Gail's hands, but no, it's not a bike.
http://en.wikipedia.org/wiki/Katana
Got to play with sticks last night, Filipino style last...
^{“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

January 15, 2009 at 10:18 am

#927516
RE: Are the posted questions getting worse?

GilaMonster (1/15/2009)
Chris Morris (1/15/2009)
They take a few moments to string, speshly in the dark, so if Mr Catburglar comes visiting then your best move would be to pin him to...
^{“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

January 15, 2009 at 9:27 am

#927461
RE: Are the posted questions getting worse?

Grant Fritchey (1/15/2009)
Chris Morris (1/15/2009)
Grant Fritchey (1/15/2009)
Oh yeah, two bows in the house, one a flat native american style long bow and the other a d-shaped english longbow with 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

January 15, 2009 at 7:55 am

#927322
RE: Are the posted questions getting worse?

Grant Fritchey (1/15/2009)
Oh yeah, two bows in the house, one a flat native american style long bow and the other a d-shaped english longbow with a Victorian riser and horn...
^{“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

January 15, 2009 at 7:12 am

#927268
RE: Are the posted questions getting worse?

GSquared (1/15/2009)
Grant Fritchey (1/15/2009)
jcrawf02 (1/15/2009)
Have I mentioned how much I LOVE all of you, and REALLY APPRECIATE all of your help on the forum?
(laughs nervously, backs away slowly...)
Oh now, don't...
^{“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

January 15, 2009 at 6:45 am

#927246
RE: Are the posted questions getting worse?

jcrawf02 (1/15/2009)
Have I mentioned how much I LOVE all of you, and REALLY APPRECIATE all of your help on the forum?
(laughs nervously, backs away slowly...)
Get yourself a little snub-nosed handgun...
^{“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

January 15, 2009 at 6:26 am

#927226
RE: Are the posted questions getting worse?

Jeff Moden (1/14/2009)
Actually... I built a "cannon" to fire the potato part of the pork chop dinner. 5 foot barrel with a 5 foot extension (haven't tried the extension,...
^{“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

January 15, 2009 at 4:03 am

#927166

Viewing 15 posts - 8,896 through 8,910 (of 10,143 total)