ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,716 through 8,730 (of 10,143 total)

RE: How to find Week start date and Week end date

karthikeyan (3/6/2009)
Thanks a lot to all.
I just wanted to know what about my solution? won't it be a god solution? I think 'YES'. Becuase i have used UPPER function. Right?...
^{“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

March 6, 2009 at 4:06 am

#954743
RE: Updating Multiple row subquery ..!! Help ..

If you were to write a SELECT against these two tables which returned just the rows you want to update from the target table, along with the target column and...
^{“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

March 6, 2009 at 2:33 am

#954706
RE: Are the posted questions getting worse?

Bob Hovious (3/5/2009)
Add some green peas to get the canister effect. Yum.
Mushy peas! Yum! Mushed ballistically!
^{“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

March 6, 2009 at 1:42 am

#954695
RE: give me your suggestion

Jeff Moden (3/5/2009)
Bob Hovious (3/5/2009)
I just tested the function from that article ... it is SLOW!!!!
9999 rows converted using that function takes almost 20 seconds!!!
Heh... I absolutely love it... let...
^{“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

March 5, 2009 at 3:50 pm

#954510
RE: Distinct going slower than *

Derek Dongray (3/5/2009)
Actually, I vaguely recall hearing that before.
These days I just avoid UDFs wherever possible, 'cos I know there's going to come back and haunt me later! 😀
They're cool,...
^{“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

March 5, 2009 at 12:56 pm

#954317
RE: Distinct going slower than *

Putts (3/5/2009)
Derek Dongray (3/5/2009)
Looking at the plan....
Sorry for a bit of confusion, Derek, but have brought up a new query that is doing something very similar here on page 4....
^{“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

March 5, 2009 at 12:13 pm

#954283
RE: Distinct going slower than *

Hey, thanks for going the extra mile, Putts. Can we have some table row counts as well, please? Off the top of your head is fine so long as they're...
^{“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

March 5, 2009 at 11:47 am

#954260
RE: Are the posted questions getting worse?

GilaMonster (3/5/2009)
Chris Morris (3/5/2009)
Hey Grant, your chum's back in town. I'm in the bleachers with a couple of beers.
I'll join you. Got any coffee?
Plenty, make yourself comfortable. You might want...
^{“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

March 5, 2009 at 10:16 am

#954180
RE: Are the posted questions getting worse?

Hey Grant, your chum's back in town. I'm in the bleachers with a couple of beers.
^{“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

March 5, 2009 at 9:57 am

#954158
RE: Distinct going slower than *

Putts (3/5/2009)
As mentioned later in my post, it's a view.
I've read the Forum Etiquette but not sure how that applies to my question ..... unless you just always paste 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

March 5, 2009 at 9:51 am

#954153
RE: Distinct going slower than *

Is IREP_V_POSITION_STANDARDS a table or a view?
^{“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

March 5, 2009 at 9:28 am

#954131
RE: How to get day of a specific week

peter.marshall (3/5/2009)
Ah - nevermind, thanks for the help but I've just found a solution! 🙂
I wrote a function which steps through the days of the month until it hits 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

March 5, 2009 at 5:51 am

#953940
RE: UPDATE a datetime field with a datetime from another database

Interesting...have a look at this...
SELECT u.[Last run], t.LastRunField
FROM [SQLSERVER\SQLINSTANCE].[Database].dbo.[UploadStatus] u
INNER JOIN [Table] t ON t.CashDesk = u.CashDesk and t.UploadJob = u.UploadJob and t.Store = u.Store
WHERE u.[Upload job] = @UploadJob
AND...
^{“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

March 5, 2009 at 5:22 am

#953927
RE: UPDATE a datetime field with a datetime from another database

agh100 (3/5/2009)
No, here it returns the date as it should.
2009-03-04 20:58:41.083
The usual suspects here are the backslash in the server name and the setting of quoted_identifiers... what does...
^{“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

March 5, 2009 at 4:56 am

#953916
RE: UPDATE a datetime field with a datetime from another database

Do you get a similar error if you run the corresponding simple select?
SELECT [Last run]
FROM [SQLSERVER\SQLINSTANCE].[Database].dbo.[UploadStatus]
WHERE [Upload job] = @UploadJob
AND Store = @ID
AND [CashDesk] = @CashDesk
^{“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

March 5, 2009 at 3:58 am

#953891

Viewing 15 posts - 8,716 through 8,730 (of 10,143 total)