An easier solution would be to create a STAGING type table import your EXCEL data into that "real" table and then grab the data you want out of it.

OR

You could...

I would get with the people that manage that server and ensure that the ports, permissions, etc..  are set-up to allow the xp_loginconfig to run.  I would also make sure...

Have you tried the following:

SELECT dbo.udf_FunctionNameHere ??  Also some require () at the end..

If you are trying to directly reference the #table it will not work.  You will have to do the code inside a stored procedure.  The problem is the system looks...

Assuming that the roles are supposed to be 2, 10, 13, 16...  Have you checked to ensure that the roles you are expecting are not being weeded out by the...

Change the compatibility level of the DB to 7.0 (SQL 7).  You should then be able to generate the code scripts required to rebuild the database on your other server...

IF you are using standard field storage for UTC then the below should work.  Please note that this code will return Greenwich Mean time (Zulu time for you pilots...)

-- 1994-11-05T08:15:30-05:00

--...

rockmoose,

Your guess is as good as mine...  I do all my code in QA, other places than paste...

1st thing I would try is close out ALL Access databases, applications etc..  and re-open.

You may have to attempt a re-start as well.  If you are getting this on Zoom...

This code might help you get close to what you want.  All you will need to do is INSERT new line after every account is done

DECLARE @iCnt INTEGER

DECLARE @Loop INTEGER

DECLARE...

John,

Have you tried drilling down through EM to "see" what tables exist??

You should be able to see Sheet1$, Test$ etc.

and refer to it as test...Sheet1$

Please see message

http://www.sqlservercentral.com/forums/post.aspx?forumid=23&messageid=133959

Same thread

How bout

DECLARE @employee_id

SET @employee_id = (SELECT employee_id FROM ##employee WHERE code = 'AA')

SELECT * FROM table1 WHERE fieldx = @employee_id

Ok, this is what I would try,

1. change the fields that you are thinking are bombing due to DATE to CHAR where you know the code works when you run...

Steve,

I have full faith in you and this site.  I have been around for a little while with you.  I have e-mails from Oct 2002 which is unfortunate because...