Something like this should do the trick:

declare @date1 datetime

set @date1 = '20050228'

select dateadd(day,-day(@date1),dateadd(month,2,@date1))

Phil

Thanks Steve, saves me responding

Phil

Hi Nathan

I've had to solve this before. Try this:

WHERE LastName = IsNull(@var1,LastName) AND

IsActive = IsNull(@var2, IsActive)

Phil

I don't think there's a really nice solution to this one. But this might work:

select t1..., t2..., t3...

from

t1 inner join t2 on t1.id = t2.id cross join...

"... If so, make sure you create an update trigger ..." - no need. Just change the create trigger line as follows:

CREATE TRIGGER dbo.EmailINS ON Email FOR INSERT, UPDATE

Phil

Something like this should get you most of the way:

create TRIGGER [name] ON

FOR INSERT

AS

update

set created_by = SUSER_SNAME(),

last_modified_by = SUSER_SNAME(),

date_created = GETDATE(),

date_last_modified = GETDATE()

from inserted

where

.Seqno = inserted.seqno;

create...

Hmmm - not quite sure what you're after. Do you have a 'person' table containing an e-mail field and want to maintain a separate table which contains just e-mail address...

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