Lowell,

Try this change. I stumbled on to it so I can't explain (at this time) why it makes the in-line code work.

WHERE N < DATALENGTH(@vbCrLf + @input) -- REMOVED...

Steve Jones - Editor (3/2/2010)

---

Well this was interesting. Had someone ask for their account to be closed here since the questions haven't been good the last month and the quality...

I'm not sure at this time. This is something i will have to try a play with when I have a little more time. Nice SQL Puzzle, I...

Lowell,

Try this function, and pass in the char(13) + char(10) as the 2 character deliminater.

CREATE function [dbo].[DelimitedSplit2] (

@pString varchar(max),

@pDelimiter varchar(2)

)

returns table

as

return

with

a1 as...

What I get tired of are the OP's that think they need to post the same question multiple times in different forums.

Maybe, on the dog-pile. Really depends on the thread and...

Please do not cross post. It just fragments responses and adds confusion.

Please post replies here.

Please do not cross post. It just fragments responses and adds confusion.

Please post replies here.

Paul White (3/2/2010)

---

Chris Morris-439714 (3/2/2010)

---

Is it just me, or are the posters who appear to be the students, the ones who have the nerve to post their homework here, the...

Several things to check. First, was the log truncated (BACKUP LOG WITH TRUNCATE_ONLY) or was the database changed from FULL recovery model to SIMPLE recovery model and back? ...

This:

select name, is_trustworthy_on from sys.databases

Also from BOL:

The types of operations that cause master to be updated, and that require a backup to take place, include the following:

Creating or deleting a user database.

...

True, but just keep in mind that those never will change requirements always do. Best to be prepared should it occur.

The only type of backup permitted with the master database is full backup.

From BOL:

Now, for the gotcha, not all UTC offsets are hourly. You will find some that have an odd offset, like 12.5 hours. In this case, you may want the...