ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,871 through 9,885 (of 10,143 total)

RE: in and not in question

Adam Haines (4/2/2008)
This is similar and may in some cases work faster:
SELECT a.id
FROM tblA a
LEFT OUTER JOIN tblB b
ON...
^{“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 3, 2008 at 4:15 am

#797700
RE: in and not in question

Adam Haines (3/31/2008)
Just putting a solution that is new to SQL 2005. It works the same way as not in, except nulls do not throw it off.
select id
from...
^{“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 2, 2008 at 5:29 am

#797108
RE: HOW TO USE A SUM FUNCTION IN A UPDATE QUERY

Ian, always check an UPDATE...FROM using a SELECT first. Only when the SELECT returns the values you are expecting should you convert it over to an UPDATE...FROM. It makes 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

April 2, 2008 at 4:54 am

#797094
RE: ORDER BY

Try this in SQL2k or equivalent mode:
SELECT ShippedDate AS [OrderDate], * FROM Northwind.dbo.Orders o ORDER BY o.OrderDate DESC
which has a table name (or rather alias) preceeding the column name. If...
^{“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 31, 2008 at 9:46 am

#796016
RE: Comparing Strings......

Matt Miller (3/31/2008)
If you're trying to make sure that they don't re-enter existing clients - why not force them to go through the existing list of customers FIRST? 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

March 31, 2008 at 9:15 am

#795996
RE: Comparing Strings......

It's not built-in like 2k5 so you have to write your own. I've used it a lot for migration deduping on the last project with this client, looking for dupes...
^{“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 31, 2008 at 5:34 am

#795857
RE: ORDER BY

kevriley (3/29/2008)
Comments posted to this topic are about the item
Kev
Try this in a SQL2k query window:
select OrderDate, * from Northwind.dbo.Orders order by OrderDate desc
Yes of course it works....
^{“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 31, 2008 at 4:41 am

#795841
RE: Comparing Strings......

Hi Ahmad, depending on how many rows you're working with, fuzzy matching may also be an option. You could employ SOUNDEX or DIFFERENCE to quickly obtain a list of likely...
^{“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 28, 2008 at 8:43 am

#795239
RE: Scheduling data extraction to excel

Haha! Cool! Good luck, mate. And...nice one, Jason!:)
^{“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 26, 2008 at 1:54 pm

#794330
RE: Help with Transactions, Isolation levels and Blocking??

George Heinrich (3/25/2008)
Wait...I meant I've never heard of BOHICA before!
Bend Over Here It Comes Again. (pronounced: bow-hee-ka)
This is for information purposes only, it's not an instruction :hehe:
^{“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 26, 2008 at 6:53 am

#793984
RE: Scheduling data extraction to excel

Ahmad Osama (3/19/2008)
Hi All,
I think that the last one is the best(Macro linked with views).
🙂
Regards,
Ahmad
How are you getting on with this, Ahmad? It would be interesting to hear 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

March 26, 2008 at 6:15 am

#793966
RE: Scheduling data extraction to excel

Jeff Moden (3/18/2008)
His slingshot is a lot bigger than mine... catch my drift? 😛
LOL! Oh yes! 😀
^{“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 25, 2008 at 7:15 am

#793461
RE: Human Power

Loner (3/21/2008)
I was there to see the rocks and I did not find it amazing. Maybe it was me.
First no on knew why those rocks were there,...
^{“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 21, 2008 at 12:44 pm

#792671
RE: CASE statement rpoblem

erdem (3/19/2008)
Hi Folks,
I really wonder to know how to correct the mistake below.How can I use CASE statement?????
Please help
select b.SiparisNo,
datediff(day,a.dteTeslimTarihi,b.OnayTarihi) as 'Gun Farki',
substring(c.sKodu,1,12) as ModelKodu,
CASE datediff(day,a.dteTeslimTarihi,b.OnayTarihi)
when datediff(day,a.dteTeslimTarihi,b.OnayTarihi)>0 Then 2...
^{“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 20, 2008 at 9:01 am

#792059
RE: Human Power

I have to admit, when I saw
Wally Wallington...(Thanks Curtis Curtington)
it crossed my mind that this was an early April Fools prank, but no, not at all. Very impressive...
^{“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 20, 2008 at 4:56 am

#791915

Viewing 15 posts - 9,871 through 9,885 (of 10,143 total)