It's looking pretty strange and I'm running out of ideas. Have you checked Event Viewer to see whether any exceptions are being generated?

Have you thought about breaking the transfer...

Same execution plans for all methods -> use the one that makes most sense to you

Hi srv

Is the job failing at the same stage every time - ie is the failure linked to elapsed time, or to a particular T-SQL instruction/batch?

Do you know that the...

And this is how I do it:

select cast(floor(cast(getdate() as float)) as datetime)

... same principle as ikorenbl.

Something like this should work:

DECLARE @server as varchar(100), @sqltext as varchar(100)

SET @server = 'stageServer1'

set @sqltext = 'select top 10 * from ' + @server + '.[databasename].[owner].[tablename]'

exec(@sqltext)

Regards

Phil

MSDE is cut-down SQL Server and I'm therefore sure that you should use that if you can. Moving to Access will create a lot of rework - eg stored...

Not sure about Reporting Services, but IsNull() as a T-SQL function takes two arguments:

ISNULL (check_expression, replacement_value )

So it might be worth starting there. Check BOL for more details.

Regards

Phil

Yes, just use

select substring([textfield],1,100)

Regards

Phil

Changing the db to Oracle??? You won't find that suggestion here!

If you are working on a month-by-month basis, can't you just run a...

Not sure, should happen automatically. Are you correctly terminating the connection from the VB app to SQL Server? (Set connection = null etc).

Regards

Phil

David, please clarify what you're trying to do. I cannot think of a situation where you would need to create a stored procedure as part of a function call,...

This is pretty bad news! Is there any way that you can get a complete list of all city names into a separate SQL Server table?

You could then traverse...

Excellent, never used that before. Far better than my suggestion.

If you re-read the original post, you will see why the straightforward 'top 10' method will not work in this case.

I think the way to do this is to find the top 10 'counts' and then to return all the records that have these counts.

So, if your table is called...