Can you please...

even when I am doing any updation in...

For table CLCProcessUnitDetailsCompany which is blank right now..

Create table CLCProcessUnitDetailsCompany

(

ProjectID int NOT NULL,

ProsposalID int NOT NULL,

SolutionID int not null,

UnitID int NOT NULL,

DevDateChanged DATETIME,

QuotDateChanged DATETIME,

ApprovalDateChanged DATETIME,

AddedBy nvarchar(50),

DateAdded datetime,

ChangedBy nvarchar(50),

DateChanged datetime,

CONSTRAINT PK_CLCProcessUnitDetailsCompany...

is it necessary...

Will this script work to accomplish my scenario?

Create Trigger Trg_DeviationRequestDetails_Ins

ON DeviationRequestDetails

After INSERT AS

BEGIN

MERGE INTO CLCProcessUnitDetailsCompany T

USING (SELECT drd.ProjectID, drd.ProposalID, drd.SolutionID,drd.UnitID

FROM DeviationRequestDetails drd)S

ON S.ProjectID = T.ProjectID AND

S.ProposalID...

Good question to start Monday morning 🙂

Oracle765 (8/22/2013)

---

Hi Errland

I have just actually posted a query regarding this.

I have just done that but my query seems to return to many rows eg

select count(*) from dbo.newtable

returns...

you are getting so much rows because you are doing CROSS JOIN...

I have modified your query, execute it and lemme know if you still find that issue-

select n.*,d.category

from newtable n

JOIN...

Thanks..

I wil donwlaod it and work on it 😛

+1

you can write a stored procedure for this and then call that stored procedure using Execute Sql task component........

Yes, its a bit complicated thing....

I have around 1k procedures and if follow thats steps its going to be like a summer vacation home work 😛

John Mitchell-245523 (8/22/2013)

---

Here you go. Obviously it doesn't return any rows for your sample data, but if it did, you could join back to A if you need the...

how are you passing value to the list...

if you pass values to list in this manner list(2,5) then you can create a procedure for this...

I have changed the query as per my understanding of the probleem...

Please let me know if you faced any issue -

;WITH cte AS

(

select * from (SELECT

distinct pehPaydate

,case Datepart(mm,pehPaydate)

--eft(substring(pehPErcontrol,5,len(pehPErcontrol)),2)

...