Hi,

Good question.

Does below written statements is one query statment:

INSERT INTO t2

OUTPUT inserted.id INTO @temp

SELECT d.id, t1.value FROM t1

INNER JOIN define d ON t1.name = d.name

Hi,

Thanks,

The link is not opening.

Atleast tell yes or No if confirm

Dear ToM,

OK, that's because you haven't...

Thanks TOM

But I am asking about the if else condition:

Suppose in one row at one time one startdate is coming but other termination date and officiatingstartdate is coming...

Tom please help one more thing

Use HRMS

Go

Create TRIGGER SteagingAfterInserttest ON [dbo].[staging]

FOR INSERT,UPDATE

AS

Update Staging set Startdate=Startdate+'T00:00:00.000' where EmpId in (Select EmpId from inserted);

Update Staging set Terminationdate=Terminationdate+'T00:00:00.000' where EmpId in...

Tom I have a confusion here,

Here we have FOR INSERT in trigger statement that means it will run on insert command only.

How will it run for update?

The same I have to done for update query can I use single trigger for both purpose...

Tom u r genius everyone knows...

The problem is of forefront application it only understood the date in format of

yyyy-MM-ddTHH:mm:ss.fff (For example: 2009-11-06T07:00:00.000)

Hi all,

Some how I have created this below trigger

create TRIGGER trgAfterInsert6 ON [dbo].[Employee_Test_datee]

FOR INSERT

AS

declare @emppdate varchar(50);

declare @empname varchar(100);

declare @empsal decimal(10,2);

declare @prim int;

declare @empid_date varchar(50);

select @emppdate=i.emp_date from inserted i;

select...

Thanx,

Here HRMS persons are not giving rights on there table they only provides data...and the forefront database save the date columns in format of varchar.

Can it possible the date format...

Thanks Rozema and chris: My requirement is:

I have two databases one is of HRMS application and another for forefront application.Now some table data comes from HRMS database to forefront database...

Hi Chris,

Thanks,

I have not much idea about trigger.

Can I set the below scriptlet in a insert ,update trigger.

if data already exist then update should run otherwise insert should run.

use enterpriseonly

go

declare...

Hi Rozema,

Thanks

declare @dt datetime;

select @dt = getdate();

select convert(varchar(23), @dt, 126);

How can I store a value of a column in @dt?

as below query is giving error...

use enterpriseonly

go

declare @dt;

@dt=SELECT d1 FROM [EnterpriseOnly].[dbo].[datee];

Error:

Msg...