Viewing 15 posts - 9,871 through 9,885 (of 10,143 total)
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...
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
Adam Haines (3/31/2008)
select id
from...
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
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...
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
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...
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
Matt Miller (3/31/2008)
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
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...
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
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....
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
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...
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
Haha! Cool! Good luck, mate. And...nice one, Jason!:)
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
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:
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
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...
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
Jeff Moden (3/18/2008)
His slingshot is a lot bigger than mine... catch my drift? 😛
LOL! Oh yes! 😀
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
Loner (3/21/2008)
First no on knew why those rocks were there,...
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
erdem (3/19/2008)
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...
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
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...
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
Viewing 15 posts - 9,871 through 9,885 (of 10,143 total)