There is no such thing in the general sense since SQL Server does not have record numbers. You need a field such as an identity column or datetime stamp...

I assume tha you have the 3-disc pack. I uninstalled everything, then a full install of the Visual Studio Team System disc and then a full install of the...

I would suggest that you need to look seriously at your application anyway. A minute to load a screen is horrendous - I would start getting worried at a...

My children watched the film on Monday (in a sparsely populated cinema). They enjoyed it but assure me that any correspondence with the original is largely coincidental!

I would emphasise, for all the reasons set out in the referenced threads, please avoid dynamic SQL whenever possible. In particular, allowing users to enter anything directly into a...

See http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=176260#bm176364

Have you considered OPENQUERY() ? If you can 'pull' the data onto the target server using OPENQUERY, everything will run on its own server, that is, the data selection...

A very interesting approach - thank you. I will buy the book!

1. Require them to prefix all objects dbo.

2. MY DBAs have a nightly job that checks for any objects created other than dbo and automatically mails the culprit...

I have done something similar and with a similar size table. I also used a recursive SELECT to populate the parent of each child until no more parents. ...

SET QUOTED_IDENTIFIER OFF works fine in this example - as long as you can guyarantee that you won't be getting strings with double quotes! If so, you need to...

The call looks OK to me. Do note that the function ignores errors in itself (this was a deliberate decision in the application that I built it for but...

You have a comma that should not be there :

(H3PRBL-H3POD+H3POD+H3IOD+H3AIBL+H3FOD) / (case when [H4CURR]= 'CHF' then 1.5476 else 1 end)

AS LNRTotalClaimEUR

Good point. Only the last output is returned to ADO as a resultset and this will be the 'rows affected' message unless NOCOUNT is set ON.

Even then, you will...

Thank you - much better. I'll do it that way (CHR(39)) in future. As you say, escaping quotes is messy and difficult to read so I prefer to...