This should work, though it's a bit ugly

SELECT * FROM order WHERE ord_id IN

(

SELECT Col_A FROM Ref UNION

SELECT Col_B FROM Ref UNION

...

The delete and backup are done in a DTS package, with an On_Completion workflow between them. I added the delete in after the first time I got this error. The...

SELECT MAX(id) FROM Table GROUP BY age, height, gender

Re performance, I'm just speaking from prior experience. I do MIS and as such run very large, very long queries. I found that changing the date rounding method from a...

This also works well. In practise I've found it a bit faster (though usually too little to notice)

Set @DATE = CAST(FLOOR(CAST (getdate() AS FLOAT)) AS DATETIME)

Try this

Select A.pId from tblPrp A

where A.p_id in (

select p_id from FacilityText where fac_id in (1,2)

group by p_id

having count(id)=2)

Run them in Query analyser with the execution plan enabled, see where the difference lies

I'm guessing you're only passing 3 parameters to the stored procedure

You have to declare and pass a variable for the proc to return a value. Output parameters are different to...

Sorry for the misunderstanding about syntax. I'm not used to seeing tables owned by anyone other than dbo.

Have a look here http://support.microsoft.com/default.aspx?scid=kb;en-us;827448 (MS knowledge base article 827448). See if that...

What xtype did you get? If it's TR, then I don't know what's wrong. If that's the case, then maybe you could post the entire script (if it's not too...

UTR_Duplicate_REQ might be something other than a trigger

run the below query and see what you get for xtype

select xtype from sysobjects where name='UTR_Duplicate_REQ'

I also disagree with the answer. I'm guessing books online is wrong. Syscolumns contains 1 row for each parameter in a udf, as well as an additional row that, I'm...

Unfortunatly I have no control over table names. Amoung the tables I have in this db are a couple called System_

I can do some sql to find all tables that...

sp_help '

I'm guessing it uses sysobjects in the background and it's not much use if you want to use the date in later code.

Looks perfect. Thanks for your help