All of the DB connections are configured to get the values from a table at runtime but this not being an OLEDB connection i am not sure how should i...

I find the query useful so published it so that it might be useful for everyone. I was unaware of an existing post :-).

Try this..

Select sum(Duration1) as Duration1,Sum(Duration2)as Duration2,

Sum(Duration3) as Duration3, Case When Type = A then Math END as Math, Case When Type = A then Silver END as Silver

From Table

where...

Thanks Luiz for the info.

One last question on that why doesnt it fail when inserting a numeric field value to varchar() field?

Insert into #temp

Select * from #temp1

Worked like a charm .Thank you

It should go to where clause but how do i get those statements dynamically based on the above table structure without any hard coded script in the code.

Let me explain in more detail..

I do have admin rights on the server.

The temp table is being created by a stored procedure

The stored proc is being executed by a sql...

There is a view which is built on dbo.customerdetail table.. Also attached the actual plan.

Thanks Guys for the workarounds.. I will look into it and implement the one with less changes to my existing schema.

Yes, I do have an identity field which i havent put in the example.. Can you please let me know the workaround.

No, the ID column is not unique..

i know we can create clause with sql 2008 and later versions

Create unique index IDX_1 on Table1(Column) where column2 is null

The above query...

Hey Mate..

Thanks for the response but my requirement is to have a unique constraint create when the Dateexpired field is null ..

Let say below are my insert statements then...

The logic already had an IF conditions and its a new functionality which i need to integrate into the solution so dont want to add up if else clause for...

Thanks lutz.. It worked like a charm.

I will look into optimizing it now .

Thanks for the response..

I need to add few more fields in the case statement based on the parameter ..I will test it .

Thanks