Please go through this following article to understand how to post data to get the best help:CLICK HERE FOR FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

When u do so, i am...

Ok, i can understand what you want your code to do. I am in the middle of writing a query for you, but it will take time, In the meanwhile,...

Wont this populate the local variables with the...

Dear Lavanya, you have not even provided one of the requisites that Gianluca has asked for! Please provide us those and then we will provide you with awesome code! Guessing...

~Edit : My bad, posted in the wrong thread! 😀 ! Sorry!

Jason's code will perfectly delete the duplicate rows.

As a side note, mbrady5, please post the table structures (create table scripts), some sample data cokked-up from your original data (as...

emily-1119612 (5/4/2010)

So conceptually I want to truncate #Lists and Insert all records from #ListUpdate into #Lists. This would give me my desired results. From a coding/practical perspective I want to...

Oh am flattened! :blush: Thanks, Mr.Tally from Italy!!

Of late this PIVOT and UNPIVOT requirements are coming in large...

When you run my code, i get these values in @test-2 table before and after the UPDATE.

SELECT * FROM @test-2

1. BEFORE Update

ID ...

Hey i might have got what you wanted. Here is the full code:

First the test environment; sample data and the schemas

Note: I have used the same schema provided by you...

Hey Kumar, based on the sample data and your requirement, i have arrived half-the-way.

This will not produce the full result, but i have come to a point where i have...

I would love to, Mr.BlackCap! Please shoot it out!

Hi mashtal, truely speaking, i am unable to extract info from your post. I reaaly cant comprehend what you want from the code!! People here are unpaid volunteers who put...

You're welcome, Wellington! 🙂

Good to see that your code is fixed!

Cheers!!

Nice intuitive question and an equally impressive explanation, Mr.Black Cap. Learnt quite a few behind-the-scenes of datatype conversions and roundings!

Thanks!