This thread is six years old.

Why not use a percentage for the tolerance?

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?...

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...

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...

Why do you have

isnull(10172,0)=0

in your query at all?

Use one query instead of two almost-identical ones.

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...

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].

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...

Then obfuscate column and table names! Your pseudocode is so full of errors that making sense of it is more...

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'...

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...

nitha jen (7/26/2013)

---

so there is a way to get a o/p using dynamic sql right..but how....i don't know many thing about dynamic sql....how do i insert the values in a...

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...