Can you use another DATABASE

HTH

OR:

select  right('00'+ cast(month(getdate()) as varchar(2)),2)

Just one minor change to snow.surfer on the select list use:

 SELECT IsNull(counts.company_no,'?') as Company_no, depts.dept_no, IsNull(counts.count,0) as Counts FROM ...

HTH

If you DROP and recreate the table Yes of course you will get the error but in that case you could DISABLE the Constraint do your stuff and Re enable...

Use a foreign Key Constraint with a  NOT Null option on the column

HTH

Sorry but I believe that does NOT answer the question posted

select P1.Person_id from P_Person P1 join P_Person P2 on P1.Person_id =P2.Person_ID where P1.Comp_id=1 and P2.Comp_id=2

Watch out for that Identity Function Solution with select into

IT DOES NOT ALWAYS WORKS !

hungry for why?      --> look in here

HTH

this looks like an indexing problem to me

try varchar(8000), should you need more just pass more parameters and execute them as exec (@param1 + @param2 + @param3 + @param4 + ...)

HTH

Don't understand yet the purpose but:

Select col_a

from some_table

where

 Date_col =

coalesce (select date from tableA where id = host_id(), getdate())

OR

Select col_a

from some_table

where

 Date_col =

(case when exists (select * from...

To be honest I hope you don't find such thing

Yes You can't nest a sp that uses the insert exec construct. Try to use those at the Top level instead.

HTH

I would either

1. Built the search TSQL on the client with sp_execsql and declare each word as a parameter

or

2. create a wrapper to the procedure that "Tal McMahon" proposed and...

Forgot to mention

step 3.5

-- Dissable All Triggers and constraints 

exec sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

exec sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER  all"

step 5

-- Enable...