... and, even more generic, if your target values are in a table :

DECLARE @params Integer

SELECT @params = COUNT(*) FROM dbo.TargetValues

SELECT pp.Person_id

FROM P_Person pp

JOIN dbo.TargetValues tv

ON...

An alternative, generic, solution would be :

SELECT Person_id

FROM P_Person

WHERE Comp_id IN (1, 2, 3, ...)

GROUP BY Person_id

HAVING COUNT(*) >= @NoParams

Try :

SELECT p1.Person_id

FROM P_Person p1

JOIN P_Person p2

ON p2.Person_id = p1.Person_id

...

I have encountered this before and got around it by rewriting the query 'the other way round'. Instead of the main query being on the local server and the...

I can confirm that TempDB has got the 'wrong' collation sequence so your explanation fits. Thanks for your response.

There are two types os spec to consider :

Business specs should describe the functionaslity required and need not refer to SQL at all.

Systems specs on the other hand need top...

Date 0 is 1/1/1900.

WARNING : Visual Basic uses 31 December 1899 as its base so, if you start handling dates as numerics, you can get a mismatch - it caught...

As always, it depends on what you are doing. In general terms, I would expect Jeff's function to be faster, especially as you would have to join on a...

The upper limit is 8092 bytes (nence nvarchar is 4046 characters of two bytes each) which is the maximum length of a record, but any other fields have to fit...

There was an extensive exchange on this a while ago and I think Jeff's solution came out fastest - but I don't remember the float method being considered.

I always get...

You probably need to use a derived table as a nested query, eg :

SELECT t1.KeyID, SUM(t1.TotalQuantity) - SUM(dt.Unshipped)

FROM Table1 t1

JOIN (SELECT KeyID, TotalQuantity AS...

Why do you want to do it?

If you don't need the field, it's more efficient not to get it in the first place (network traffic). If you did need...

I'm not into DTS but this error comes, for example, when CursorLocation and CursorType are incompatible. I suggest that you lok at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjconnection.asp

It's probably your connection object. Is it open? What are it's properties?

Sorry, my formatting seems to have disappeared!

SELECT s.Record_Count,

t.Trip_ID,

s.Compart_No,

t.Boat_ID,

...