Viewing 15 posts - 13,711 through 13,725 (of 13,869 total)
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
October 6, 2004 at 12:09 am
I wouldn't bet against it - some bright guys out there.
October 5, 2004 at 11:23 pm
This link is relevant but not good news. I think you might have to recast as a stored proc.
Regards
Phil
October 5, 2004 at 9:28 pm
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...
October 5, 2004 at 9:11 pm
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...
October 5, 2004 at 5:59 pm
Same execution plans for all methods -> use the one that makes most sense to you ![]()
October 4, 2004 at 11:14 pm
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...
October 4, 2004 at 10:02 pm
And this is how I do it:
select cast(floor(cast(getdate() as float)) as datetime)
... same principle as ikorenbl.
October 4, 2004 at 6:35 pm
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
September 30, 2004 at 6:59 pm
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...
September 28, 2004 at 11:21 pm
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
September 27, 2004 at 10:17 pm
Yes, just use
select substring([textfield],1,100)
Regards
Phil
September 27, 2004 at 9:45 pm
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...
September 26, 2004 at 10:12 pm
Not sure, should happen automatically. Are you correctly terminating the connection from the VB app to SQL Server? (Set connection = null etc).
Regards
Phil
September 26, 2004 at 9:58 pm
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,...
September 26, 2004 at 6:04 pm
Viewing 15 posts - 13,711 through 13,725 (of 13,869 total)