Man!! You are awesome... Yes i missed that part.

Thank you so much..

Ok Sorry for that.

For ex: If you take ID: 1, we have 2 records with two different status in status table and 1 record in fourhistory table. I need to...

Hi, Requirement is, i want to merge the status column in second table. For that, i need to consider both tables effective start and end dates.

So, #Fourhistory tables effective start...

Hi Tons of thanks first.

I tried for the ID value 1. Its working perfectly. But when i try insert other id into those 2 temp tables. Am not getting as...

Hi,

Unionall will append the data. But i need to merge the status column into second table based on the effective start and effective end date.

Hi,

Kindly suggest me a solution for this.

Hi,

Hope this helps you.

A request, while posting your doubts. Please come up with your neccessary scripts say, create table, sample values. So that our guys will help you as...

Hi, Thanks for the query. I will use this and let you know if i have any doubts.

Once you prefer different outputs, obviously you need to change the filtering. But, i don't know what is the problem of changing the query..

Please provide the ddl for your requirement. (Table structure & sample values)

ChrisM@Work (7/26/2012)

Well I'm stumped on this one. The CASE expression is a red herring - it's irrelevant. What's significant...

Hi,

Below is the entire script which will meet your requirement.

create table #test ( id int, col1 int, col2 int)

ALTER TABLE #test ADD computed_Max AS (CASE WHEN COL1> COL2 THEN...

Hi, Can you please try the below...

ALTER TABLE #test ADD computed_Max AS (CASE WHEN COL1 < COL2 THEN COL1 ELSE COL2 END)

please give less than symbol in place of "&lt"

For which column you need to check that variable?

Like, select * from [accomodation] where ? = @sql

Also specify, what is the input for that variable @sql.

Can you explain bit more on your doubt?