both of you are great.

all answers is my inspiration

ray-SQL (3/3/2010)

---

Your constraint is

CONSTRAINT [tPickPointD01] UNIQUE NONCLUSTERED

(

[tpphidx] ASC,

[desn] ASC

)

so looks like the update...

Ok guys. Felt better now.

For me, XML parameter will hurt performance it's a myth

It's true using XML as input parameter will hurt the...

ALZDBA (3/2/2010)

---

write an update statement in stead of the delete / insert.

Keep in mind, you need to check if it actually updated a row (@@rowcount)

Because if it didn't, you'll have...

oh. my brain problem actually. he..he

Ok guys. Me understood now. cheers ..

tq to all. all your answer is my inspiration.

The tables have been segmented because of performance issue. Me going to using Partitioned Views technology.

How about that?

NewBeeSQL (2/22/2010)

---

Is this you are looking for?

declare @tblStr varchar(max)

declare @intMnth int

set @intMnth =1

while @intmnth < 12

begin

set @tblStr = 'CREATE TABLE [dbo].[DERInfo_2010'+cast(@intmnth as varchar(10))+'](

[trnxid] [int] IDENTITY(1,1) NOT NULL,

[DDate] [datetime] NOT...

This query really new to me.

Is that ok, if me dont want to store this departtimes into triptimer table? It's look enough to store the departure date and departure...

Me cannot imagine how this 2 sql statment can related.

Really looking for help

lmu92 (2/14/2010)

---

It depends. You could use ROW_NUMBER and a temp table or, if you need to get the ID...

lmu92 (2/14/2010)

---

Where exactly did you get stuck?

Do you have difficulties to shred the xml data?

If so, the following might help you.

If you want us to do the complete work for...

tq sir