Hi Kristin, no problem. I don't think I was too far away with my last attempt Here's a refined version (it...

I'm sure that we can help you out with just a bit more information.

1) What is the link between Records and Chains?

2) What do you want to set Records.Chainpath to?

3)...

It's not as easy as you might expect. Here's a bit of SQL that might get you heading in the right direction:

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

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