in SSRS

Tired that code again but still not working,

Randomizing ContactID's and CallDateTime's...

(1000000 row(s) affected)

Building/populating the #HistoryTest table...

Msg 208, Level 16, State 1, Line 19

Invalid object name 'AdventureWorks.Person.Contact'.

J Livingston SQL (6/5/2013)

---

that's not...

I have replace name with PID, but its coming up blank

Any ideas

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..HistoryTEST','U') IS NOT NULL

DROP TABLE HistoryTEST

--===== Create the test table...

Thanks

I have added PID to the data below The PID is unique ID per customer so on the below i want to see

PID = 22

calldatetime 25/02/2012

NextCallDateTime = 28/02/2013

numberofdays =...

Hope this helps a bit,

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP...

Sorry the PID in the table that is unique ID per customer. --- [PID] [int] NOT NULL,

Jeff Moden (5/30/2013)

---

Tyekhan (5/30/2013)

---

Yes the num column is unique, but the best thing to...

Yes the num column is unique, but the best thing to use would be ID as the same records would have the same ID.

Jeff Moden (5/30/2013)

---

So, any feedback on my...

Thank you for the code i have just tested it, its coming up with the below code error,

'Randomizing ContactID's and CallDateTime's...

(1000000 row(s) affected)

Building/populating the #History table...

Msg 208, Level 16, State...

No solution found that works yet, Still need help 🙁

Jeff Moden (5/25/2013)

---

Dammit. I'm sorry. I lost track of this thread and it took me a while to...

I would like the first call on both day (first & fifth), they will only be 1 for each day any way as it come every 2-4 days.

Jeff Moden (5/20/2013)

---

Tyekhan...

Yes that's what i want, if anyone can help me with it.thanks

alezar (5/20/2013)

---

Hi, as Sean asked it will be great if you could improve description of your req.

What I understand...

Next CallDateTime information is in the data but its not called Next CallDateTime, its CallDateTime.

So if records 1 CallDateTime was after the select date e.g 01/05/2013 then they revisited on...