Another quick question, is it possible to put a index on a temp table and if
so what is the syntax.
Thanks Phil

Just a quick question for anyone, I have a stored procedure that uses a lot
of variables in a where statement, the only problem with this is it's very
slow, I am just listing them something like this
WHERE

Real new person question here but during my query practise I created some
parameter queries in the enterprise manager however theses will not work when
I open query analyser. Can anyone tell where I’ve boobed?
Many thanks

I am new to sql (very new).
I have two database, let's call it database1 and database2.
Both database contains last name, first name and address information.  
Database1 has approximatley 12000 records and database2 has approximately

how can I keep track of who is making modifications to a existing stored
procedure.
thanks
samy

Is it possible to fire a trigger on a specific time i.e. when the system
time is 1200 hrs(for eg) ,  trigger fires automatically and run a script
Regards,
Muhammad Bilal

I am trying to write an update query that update the BG1 field in the
Customer table with the BG value in the Agreements Table from a different
database.
Here is what I have so far . . .  but it doesn't work - I get the error

I'm using sql 2000 and Access 2002. I need to create a parameter query that
would ask the following statement: "Enter the work order number".
How would I do this in sql?
Thanks for the help,

I'm not sure if I understood this correctly.
If I create a temporary table with the name #SomeTempTab,
can anybody else see this table while I'm using it and before I drop it.
So if two users at the same time trying to create the table with this name