Matt Wilhoite (11/9/2009)

---

I have a solution that works using a loop and dynamic SQL. But this has some stipulations with it. I changed the table variables to be...

Matt Wilhoite (11/9/2009)

---

This is really quick and probably dirty. I am trying to come up with a better way to determine the joins cause right now you will need...

arun.sas (11/6/2009)

---

Sharul Nizam (11/6/2009)

---

--RID always same, TrnxID always unique, RNam alway same

--BusN may be same may be not, TTime always unique

--TripDte always same, TTID sometime no value sometime have value

--SeatN...

My table and...

My origin table as follow,

-- TrnxID in @tPosiHdr is unique

declare @tPosiHdr TABLE (

TrnxID int...

Kindest Jeff Moden,

Tq for that info. 🙂

tq to all of you. 🙂

Kindest Mr. Anirban Paul and Mr. John Mitchell ,

Tq to both of you. Really appreciate it.

If divide table into more table, is that affect the performance? It is because if we're running the queries, it will cost more join table. More inner join we're using,...

tq all. i will help me.

How i can avoid using table variable for boost the performance?

Hi,

I did'nt understand the statement,

INSERT @t

SELECT 'KL202', 'JPJ' UNION ALL

SELECT 'KL202', 'JPJ' UNION ALL

SELECT 'KL202', 'JPN' UNION ALL

SELECT 'KL202', 'JIM' UNION ALL

SELECT 'KL202', 'JIM' UNION ALL

SELECT 'KL101', 'JPJ' UNION ALL

SELECT...

I did not see the Delete statement to clear REPLAY_LOG_NEW become

REPLAY_LOG_NEW

ACTIVITYID | Student

-------------------

2  | James

2  | William

According to your SQL Scripts, REPLAY_LOG_NEW have a same data with REPLAY_LOG.

where i need to put delete...

tq sushila. . it's work.

tq everyone. especially mr. JeffB. your solution give me an idea to solve it.