Thanks but that may not be possible. Is there any other workaround?

Thanks for the info. Will keep in mind if the data grows out of hand.

What i was looking like is the complete history.

for e.g. this gives me 2 rows, one from 4/1-4/30 and other from 4/1-4/15

declare @dtmPointInTime datetime = '04/10/2013';

select ms_id, startdate, enddate,...

Can you please describe in more detail about the daily snapshot approach?

Thanks that worked. I need to understand how it works though. will check out the article.

Its not that simple.

The third party provides data, another team loads the data and we use the data to display on front end.

The team that loads the data will...

You are correct, the data should be clean. But sometimes we have no control on the data and it is provided by third party. All we can do is some...

Sorry, I was not clear. I want include values from table column that has leading/trailing spaces also.

For e.g.

table1

Col

----------

' ABC'

'XYZ '

' MNR'

' MCR'

table2

Col

-------

'XYZ'

'MNR'

Select * from...

So both the queries will return same results? I want to include leading and trailing spaces from table2.

If I understanding correctly, LTRIM/RTRIM does not make any difference.

If I have a query like

Select * from table1 WHERE ColVal IN (Select AllVals from table2)

Is it not better to have the following instead? It will bring in those values...

Then what is the need of LTRIM and RTRIM functions in SQL

using this query instead of using the view directly improved the performance times

SELECT

distinct ID,(Display+'--'+ID) as Display

FROM MyView WHERE ...

CREATE TABLE [case1](

[CaseID] [varchar](15) NULL,

[Emp_ID] [varchar](15) NULL,

[Segment] [varchar](10) NULL,

[dischargedt] [date] NULL,

[discharge_entered_dt] [date] NULL

) ON [PRIMARY]

GO

/****** Object: Index [IX_PK] Script Date: 03/28/2013 13:58:55 ******/

CREATE UNIQUE CLUSTERED INDEX...

Here you go

CREATE TABLE [case1](

[CaseID] [varchar](15) NULL,

[Emp_ID] [varchar](15) NULL,

[Segment] [varchar](10) NULL,

[dischargedt] [date] NULL,

[discharge_entered_dt] [date] NULL

) ON [PRIMARY]

GO

/****** Object: Index [IX_PK] Script Date: 03/28/2013 13:58:55 ******/

CREATE UNIQUE...

Full Index search will need an index on the view.

And Indexed view will not be a good idea here since the data in case1 table is frequently updated.