Did you get this problem resolved?

If not, can you provide us with the table structures so we can try to help?

Have you had a chance to test them?

If so, do they return the correct results? Was one of them faster than the others?...

You did...

I don't have a list of improvements, but I have seen a number myself. 2008 R2...

Thanks for letting us know the queries we provided helped.

I think you need to check the answer key for this question. It lists "Column references can pull data from multiple rows." as one of the options you have to...

Give this a try:

WITH CTE AS (SELECT

S_NO,

...

Here is an alternate version that doesn't use as many CTEs, opting for correlated sub-queries instead, and from the execution plan should run faster while still returning the same results:

I...

Well since you included sample/test data that almost worked, and had a almost complete explanation of what you wanted I think I was able to make a query to do...

This insert fails because the data is longer than you have allowed in your table...

Could someone please help me with the query , I have to...

I agree, nice question, but it would have been even better with a fourth option: 1-Boston;2-New Delhi

Without that option it was really a test of transactions, not of IDENTITY....

Your welcome, and thanks for letting me know it worked for you.

Your welcome, thanks for letting us know that worked for you.

It sounds to me like the best fit for your problem would be to use FILESTREAM storage for your VARBINARY(MAX) field. You might want to look that up in BOL.

Digs (9/28/2010)

---

Are you sure you have the order round the correct way, that is the 01/04/2000 record is divided by the 01/03/2000, that is new date divided by the older...