Oh no!!! Of course! Thanks, Adi!

Thank you all for the answers!

Thank you for the answer!

But the customer does't use Full Text Index on their databases, I am afraid.

Thank you Luis,

I am looking for the ideas at the moment. Want to play with various suggestions people may come up here, like CROSS APPLY for example.

Thank you!

That's interesting indeed, thank you!

Do you mean I can use it as a part of my update:

UPDATE myTable

SET myTable.Column1 = cApply.Column1

FROM myTable

CROSS APPLY (SELECT Column1 FROM myFunction WHERE ....)...

Have you tried anything so far? My assumption we all want to see that one has put an effort to solve the problem, before posting the

questions here. Have you looked...

Thanks!

Thank you for the reply.

Assuming I have myId field which is a single segment of myUniqueId index, is it correct

to state that there will be no difference if I will...

Thank you for the reply.

Because of the distance between SQL Server and the application one, the way it works at the moment,

by pulling all the data to the application...

I will rephrase my question then, is there is a way, using T-SQL to add an additional row, which will be a summary for each client? As far as I...

There is no 80 points and there is sample data - WITH statement runs and works perfectly (I understand you haven't tried it).

I do know that SQL is not a...

Koen Verbeeck (8/6/2013)

---

The only tool in the SQL Server...

SGT_squeequal (8/6/2013)

---

HI I have just implimeted something a little similar in excell however, instead of exporting from SQL i import from excel.

I created a button on spreadhseet then create some...

I guess I need to look for another solution as customer's sites do not have SSRS installed.

Any other advise, please?

Kind Regards