I've been developing a stored procedure that uses a user defined
function in the query portion of the procedure. However, since the end
product needs to allow for dynamic table names, the UDF will not work.
I've been trying to get this to work with converting the UDF to a

Can someone give me a simple example of how to force a datetime value
to be stripped of the time portion when it is added/updated to a table.
I intend to use it for date only.
I figured a trigger was the way to do this but haven't gotten the

I do not know if this is the proper group to ask my question.  Please do
direct me to the proper place.
I have a database server and would like to store data for multiple
groups of customers.  The data is not shared amongst the groups but are

Hey all.
I'm running SQL server 2000, on W2K server. All the latest patches/etc
for both installed.
I've a need to allow remote access to the DB. I have a strong password

I was trying to user the code below to run a DTS job.  The job fails
when I get to the piece of code that begins:
EXEC @rc = sp_OAMethod @PackageToken,
'LoadFromSQLServer', ...

I am trying to speed up my update statements by removing inner select
statements.
 Example:
  update orders set shipname = (select contactName from

See if you can help me with the following:
I need to write an SQL code that will return me:
The 1st day & the Last day of the Previous Month in the following format
(smalldatetime):

Hello faculties,
   We've a production database that is being used by one of our clients
as a backend for his website. The database size is around 1GB.
  Recently we added some tables to our local database which is a

I need to get two values from a complex SQL statement which returns a single
record and use those two values to update a single record in a table. In
order to assign those two values to variables and then use those variables
in the UPDATE statement, I created a cursor and used ...

I have one form in access application which shows various fields from
the database. The fields are like No of PCs a client has,No of
employees,revenue etc.
Need of the user is to filter the data on the form and export the

Is there such a beast or is Microsoft going right from SQL Server 2000 to
SQL Server 2005?
TIA,
-Tom

I just finished a new query where I summarized detail information. I'm
wondering if I did this really awkwardly or is this a common way to
write SQL? I've cross referenced the end results and the data seems
consistant, so I am happy with the results.

I am running SQL Server 2000, still pretty new to this.
I ran the DTS Import/Export Wizard to create my table and insert the data
150,000 records.  The data was only suppose to be changed occassionally, a
record at a time.  Now I need to insert another 50,000 records, not quite

I couldn't connect to named instance in my client machine... I recieved the
error messange.. SQL Server Doesn't exist or Access denied. Can any one
guide me...
Thanks

I am a SQL novice and would very much appreciate your assistance with a
restore problem.  I am trying to restore a db from a backup location and am
getting the following error message:
"the media set for database "SEItoDDA" has 2 family memebrs but only 1 are