If you use round(float,0,1), it truncates float to integer (ie 0.5 and above are not rounded up), so the given example actually works OK. Eg

select round(1.999999,0,1) as IntPart

returns 1.000000

I wouldn't bet against it - some bright guys out there.

This link is relevant but not good news. I think you might have to recast as a stored proc.

Regards

Phil

Sounds like one of those (common) applications where integrity is left completely in the hands of the application. As a developer who is new to the db, you have no...

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,...