[font="Verdana"]You may be able to move some of the common code into their own stored procedures or functions.

Failing that, have you considered using code templates?

[/font]

[font="Verdana"]Hmmm, does appear to be a bug with my code.

I changed this section:

BreakDown as (

select CommentNumber,

...

[font="Verdana"]I'm sorry, but aren't you employed to write the code? Why are you asking us to write the code for you? If you write it and get stuck,...

[font="Verdana"]Ah, anger management...

As a suggestion, go buy a collection of soft, squishy balls. Not only can you play with them as stress relievers, but you can also throw them...

[font="Verdana"]By the way folks... total awe in the time and effort you have all taken in answering that thread. Just amazing. Well done.[/font]

Bob Hovious (3/18/2009)

---

Do you wonder whether he is self taught, or had some Oracle background? (His dba wife!? He said she said that cursors versus set based depended...

[font="Verdana"]It's not too hard, and you can use a similar idea with GSquared's approach too.

declare...

[font="Verdana"]Hey Flo 😀

Yup. Sometimes the existing processes make it impossible to move to something like gateway procedures, hence why I said "failing that, use triggers." Some sort of...

[font="Verdana"]You can generally use object-level security to ensure that the only the stored procedure has rights to write to the table.[/font]

[font="Verdana"]Not quite sure why sequence numbers "need to be looped"...? With the right design (or often even with the right query overlaying a poor design), you can allocate sequence...

[font="Verdana"]Don't need a cursor for that. Look up the row_number() function in SQL Server Books Online.[/font]

[font="Verdana"]The only conversion in common across both SQL Server and Oracle is CAST(). That doesn't give you any formatting control. So unless the date format is set the...

[font="Verdana"]The best way is to use gateway stored procedures to handle your inserts and updates. So they can insert and update into the various tables as necessary.

Failing that, use...

[font="Verdana"]Okay, here's what I came up with. I'll wait with baited breath to be told off for using a recursive CTE. 😀

declare @String varchar(max);

declare @MaxLength tinyint;

set @String =...

[font="Verdana"]So what's the make-up of the data in your string? Are words only ever separated by space, or do you want to break on hyphens and control characters as...