Hi,

It was indeed a good answer for my question, but as my text for text box contain "abcd www.a.com efgh" dynamicly from back end, it's difficult for me to set...

Hi David,

by looking at the execution plan of below query could you please let me know how you calculated the overall query cost as 0.0517279.

SELECT C.CustomerID

FROM Sales.Customer AS C

LEFT...

Hi David,

by looking at the execution plan of below query could you please let me know how you calculated the overall query cost as 0.0517279.

...

It is same logic as

SELECT * from #t

WHERE NOT ISNULL(id,0) = 1

or

SELECT * from #t

WHERE ISNULL(id,0) != 1

Both the queries will produce same result, since in first query...

2 options

1. You can generate script of db of all objects.

2. Restore db and truncate tables by a loop with order as details tables data first and master tables...

One answer could be

SELECT CustID,

MAX(PaymentDate)

FROM #payment

GROUP BY CustID

ORDER BY CustID

Thanks,

Amit Choudhary