Hi Anthony

Try using the decimal function:

Eg

select cast(14.1 as decimal(19,7)) as dp7, cast(14.1 as decimal(19,2)) as dp2

etc.

Check BOL for a full description of the function arguments.

Regards

Phil

Hi Suhaimij

Can you post the view design here?

Regards

Phil

Check out this recent script for ideas:

http://www.sqlservercentral.com/scripts/contributions/1141.asp

It certainly does some of what you're after.

Regards

Phil

David

You can call the getdate() function at any time and it will return the current system datetime. It is a built-in SQL Server function and therefore does not need...

Perhaps I should have signed myself

PhilfromEnglandbutlivinginOz

Thanks for that! As I'm supposed to have a day job, I couldn't spend too much time wading through your stored proc - no offence

Hi David

Can you provide sample data for cl.hours, cs.hoursperday, cs.startdate etc and also what you want to be returned in each case? As your expression is getting quite complex,...

Haven't seen this myself, but ...

Check out this link and see whether it's of any use:

http://dbforums.com/t485458.html

By default, SQL Server tables/databases are not full-text indexed. As the error message indicates, you cannot use CONTAINS or FREETEXT within queries unless the underlying data is full-text indexed.

As...

That's because it hasn't changed. It changed only for the duration of execution of the sp_executesql command. I could not find a way of making the db context...

OK, what I think happens is that the database context changes only for the duration of the sp_executesql command and then reverts immediately afterwards.

So ... if you expand your definition...

I'm assuming that you're using Enterprise Manager...

When you perform the restore, the destination file paths default to what they were on the previous server and you need to manually amend...

The statement works, but the change in database context lasts only while the SQL statement executes. Here's a quote from BOL:

"If the executed string has a USE statement that changes...

Don't know why you didn't have success with the methods you mention, but try this:

declare @sql varchar(400)

set @sql='select ''?''as dbname;select * from information_schema.routines

where charindex(''shipping_total'',specific_name) 0'

exec sp_msforeachdb @sql

(Assuming you want...

Your restore error message is not appearing - I think it is looking for a linked jpg file - please update your post to include it.