Thanks for the sample data. Try this:

-- Sample data

DROP TABLE [dbo].[MisIcg_InteractionChecks]

CREATE TABLE [dbo].[MisIcg_InteractionChecks](

[SourceID] [varchar](3) NOT NULL,

[MisIcgID] [varchar](30) NOT NULL,

[InteractionID] [varchar](25) NOT NULL,

[RowUpdateDateTime] [datetime] NULL,

[InteractionCheckMedication] [varchar](2)...

purushottam2 (1/25/2013)

---

Yes, vehicle is main table. So you mean first i should select data from vehicle table based on all filters into a temp table with index.

Then for other filters...

Most of the filtration and...

Have a look at the article linked in my sig (please read this) for ddl and dml recipes. This will be much easier if folks have readily-consumable data to work...

Except for Sergiy's first query, the plans are very similar and are costed exactly equal. I'd guess that my APPLY version with two extra operators (Compute scalar and TOP, each...

Here's another method:

-- Parameters

DECLARE @String VARCHAR(8000)

SET @String = 'Reverse'

-- Local Variables

DECLARE @OutputString VARCHAR(8000); SET @OutputString = '';

DECLARE @StrLen INT; SET @StrLen = DATALENGTH(@String);

DECLARE @MappingTable TABLE (n INT PRIMARY KEY CLUSTERED);...

SELECT

p.ProductID,

Relation = CASE x.n WHEN 1 THEN 'Linked' ELSE...

SELECT

p.ProductID,

Relation = CASE x.n WHEN 1 THEN 'Linked' ELSE 'Not Linked' END

FROM @product p

OUTER APPLY (

SELECT TOP 1 n=1

FROM @ProductRelation r

WHERE p.ProductID IN (r.FirstProductID, r.SecondProductID)

) x

ORDER...

Have you tried figuring out the filters and applying to the inner query? Something like this:

DECLARE @YEAR INT, @MONTH INT

SELECT @YEAR = 2005, @MONTH = 6

DECLARE @StartDate DATETIME, @EndDate DATETIME

SET...

dwain.c (1/22/2013)

---

Gentlemen,

Allow me to enter a new dog in this race! Perhaps you'll find the new approach amusing. I call it the Nested Replace by Quirky Update (NRxQU...

Have a look at the code I used for the sample data, if there's anything you are unsure of then ask. Note that the sample data tables I created for...

Here's how to create some sample data -...

Welsh Corgi (1/22/2013)

---

The following works :

SELECT

CASE WHEN LEFT(Customer.StartDate, 2) = '98' THEN substring(convert(varchar(20),Customer.StartDate), 3, 2)

...

No worries, you're new here. Have a read of this article[/url], it will help you formulate some test...

Not often you miss something Dwain! You're right of course....