You're missing some quotes

....WHERE p.TplanCond='thistestplan'

Without the quotes sql is looking for a column named thistestplan, which I assume from your comment doesn't exist.

Replace the where clause in the string...

And the second query has a syntax error in that there is a space between Table and 2

(Table 2 instead of Table2)

Articles on managing a data warehouse would be greatly appreciated.

Specifically any differences between managing a data warehouse as opposed to managing an OLTP system

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...

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...