You mean to say you need to merge these two tables, or join them?

The subquery here is acting as an 'expression' and I think since this is returning more than one value, it can not be used as an expression. Query would throw...

There could be ways to do this without the dynamic query also, but i can think of this at the moment,

declare @wheresql nvarchar(max)

declare @selectsql nvarchar(max)

declare @sql nvarchar(max)

Set @selectsql =...

Not sure if I understood your requirement correctly but if this part of...

Paul White (9/7/2009)

---

PP (9/7/2009)

---

I just ran the script given by Paul completely, I was just trying to understand how thats happening.Thats it.

I mean, there were 114 records with 2009 as...

Thanks Bob for the reply,

I just ran the script given by Paul completely, I was just trying to understand how thats happening.Thats it.

I mean, there were 114 records with...

Dear Paul,

Can you please help me understand how this is happening? :hehe:

SELECT count(*)

FROM dbo.DateIndexTest -- returns 1000 records

SELECT count(*)

FROM dbo.DateIndexTest

WHERE any_date_year = 2010...

Thanks GSquared 🙂

yeah, snehal.gamaji.career should not be bothered about the value for which the trigger fires as long as the purpose is achieved unless there is any special reason why...

Gianluca Sartori (9/3/2009)

---

INSERT INTO TABLE1 select *, date_deleted

from TABLE2

Where KEY_ID In (Select KEY_ID From table3 Where Invoice_Num in (select Invoice_num from #TempDelete))

I suggest that you replace the *...

Yes, I know its bit less elegant. Execute task should have worked! I dont know whats happening. Just to reproduce the problem, I tired to create execute task with my...

Anything that you could see in eventvwr?

sorry I am not sure exactly what could be the problem and could not reproduce it, but I do have similar setup where I do the zipping, I am using...

Is there a logging option in that zipping tool?

Scott (9/2/2009)

---

The job step never completes so there's nothing in the history (apart from the stop job request I have to issue). The package runs in a couple of minutes...

GSquared (9/2/2009)

---

create trigger dbo.NameStuff on dbo.MySourceTable

after insert

as

set nocount on;

insert into dbo.MyTargetTable (Name)

select Name

from inserted

where Name is not null;

It'll look something like that. If you select from the "inserted" table...