Viewing 15 posts - 4,276 through 4,290 (of 10,143 total)
Why not use a percentage for the tolerance?
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
July 29, 2013 at 7:36 am
No you can't, but you can fix the function so that it doesn't pass invalid values to substring or whatever.
Can you confirm what the function is supposed to do?...
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
July 29, 2013 at 6:39 am
Parameter sniffing is likely to affect your query. Goggle it and look for articles by known folks - I think Gail has one of the best articles.
More importantly, 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
July 29, 2013 at 6:17 am
Something to get the ball rolling. There are folks here who love date arithmetic and will come up with something quicker and more elegant, but you get the general idea;
;WITH...
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
July 29, 2013 at 6:09 am
Why do you have
isnull(10172,0)=0
in your query at all?
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
July 29, 2013 at 4:00 am
Use one query instead of two almost-identical ones.
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
July 29, 2013 at 3:49 am
It's not a brilliant script with the errors as they are: if you were to correct the ORDER BY (or better still, introduce a PK) and remove the ISNULLs 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
July 29, 2013 at 3:31 am
Thanks for the very generous feedback, Mr Kapsicum.
If you're interested in how the method works, here's an excellent article by Dwain Camps[/url].
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
July 29, 2013 at 2:39 am
No error on this platform:
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)
Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit)
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
July 29, 2013 at 2:14 am
SQL_Surfer (7/28/2013)
Sorry, I cannot post the actual code for security reasons....
Then obfuscate column and table names! Your pseudocode is so full of errors that making sense of it is more...
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
July 29, 2013 at 2:09 am
DROP TABLE #MySampleData
CREATE TABLE #MySampleData (Employee_id INT, IS_Al INT, Attendance DATE)
INSERT INTO #MySampleData (Employee_id, IS_Al, Attendance)
SELECT 1998, 1, '2013-03-18' UNION ALL
SELECT 1998, 1, '2013-03-19' UNION ALL
SELECT 1998, 1, '2013-03-21'...
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
July 29, 2013 at 1:31 am
Columns in the INCLUDE list are not part of the key. Crudely speaking and with the small amount of detail provided, your suggestion of an index with patientnumber as key...
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
July 26, 2013 at 8:57 am
nitha jen (7/26/2013)
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
July 26, 2013 at 8:04 am
Should be straightforward from here, Bill:
DROP TABLE #Invoices
CREATE TABLE #Invoices (InvoiceNo VARCHAR(10), Amount DECIMAL(10,2))
INSERT INTO #Invoices (InvoiceNo, Amount)
SELECT '1001', $230.00 UNION ALL --
SELECT '1002', $135.56 UNION ALL --
SELECT...
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
July 26, 2013 at 7:28 am
Koen Verbeeck (7/24/2013)
jcrawf02 (7/24/2013)
Koen Verbeeck (7/23/2013)
Lowell (7/23/2013)
Koen Verbeeck (7/23/2013)
Didn't know this site censored some words.Hum. Whaddayaknow...
Oh man,so you've been added into the naughty list, then right?
Probably, if I wasn't already...
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
July 26, 2013 at 6:43 am
Viewing 15 posts - 4,276 through 4,290 (of 10,143 total)