so:

select replace('1 2 3 4',' ',',')

Is that what you are looking for?

Are you talking about a delimited string split? Like this:

1,2,3,4 to

1

2

3

4

At the previous employer where we had Notes, the Notes programmer wrote code that pushed data into a database on SQL Server, so I never had to setup a transfer...

Alvin Ramard (2/5/2010)

---

CirquedeSQLeil (2/5/2010)

---

Alvin Ramard (2/5/2010)

---

Better yet, can we...

Luke L (2/5/2010)

---

Alvin Ramard (2/5/2010)

---

CirquedeSQLeil (2/5/2010)

---

Anybody notice that the Thread has surpassed 11,000 posts?

Yes, but you'll have to wait for Gail's Blog post...

UT- (2/5/2010)

---

Thanks Lynn.

I took following code from BOL and its using StopAt with full backup, how come?

RESTORE DATABASE MyAdvWorks

FROM MyAdvWorks_1, MyAdvWorks_2

WITH NORECOVERY, STOPAT...

At this point, not sure where to go. I haven't had to work with Lotus Notes since early 2005. If I get some time, I'll do some more...

subs99 (2/5/2010)

---

Hmmm.. I'm not sure that's accurate... I thought that if a...

No, to complete a point in time restore you also need transaction log backups.

Please run this in SSMS when connected to the server in question and post the results:

select @ @VERSION -- no spaces between the @ signs, had to add a space...

The only t-log backups you need for a restore are those created AFTER the full backup completed.

No,...

Please post the entire and complete error message.

Ninja's_RGR'us (2/5/2010)

---

Good catch... but it's only true if we're seeing the whole picture... it's rare that we have the real query here. Quite often we are missing columns in...

I reformatted your code, made a few changes (you really need to look at removing 3 part naming as , iirc, this is being depreciated in future versions of SQL...