well, SQL requires a paridigm shift here: you process everything in a set, and not loops;

there's a phrase in SQL called RBAR (Ree-bar) meaning Row By Agonizing Row, which is...

I modified this from somethign i saved in my snippets that is associated to the same issue: split a string on a specific number of character lengths.

if you search for...

well, i dunno about the kudos, but thank you,...

the extra STUFF is how most of us remove the delimiter;

while in this case, you could use LTRIM becasue we used a space, for any other delimiter(comma delimiter, pipes,...

ok i have this example in my snippets for turning CamelCase into a single string with spaces:

now, if each word becomes a column unto itself, that's tougher...

that would have to...

GilaMonster (12/20/2013)

---

Lowell (12/20/2013)

---

» in an actual execution plan, for any node, if the actual number of rows is orders of magnitude higher than the estimated number of rows, the statistics...

Oracle_91 (12/20/2013)

---

Hi Pals,

Assuming the query execution is slow , I have collected the actual execution plan. What should I look for in the actual execution plan . What are the...

a backup will almost always be larger than the maximum allowed attachment size for most mail servers; of the two mail servers i use, one has a limit of 4...

ramana3327 (12/19/2013)

---

If I took Basic authentication and gave gmail account as user name & Gmail account password in the password then it is working fine but if I use windows...

it's an oracle function that you'd access via a linked server then?

that's a different story, i must have missed that part.

you have a linked server in place already?

ie, from SSMS,...

you need to use a three part naming conventions which includes the schema:

testdb.dbo.Rfunctioname

testdb..Rfunctioname

you also may run into permissions problems, as the person calling the procedure or code needs access to...

i would go with explicitly identifying the collation in the statement;

here's some code examples you can copy and paste to see the issues:

an empty table with no data at all...

i had to wrap you r example a couple of times to get it to return an empty string instead of null;

does this help at all?

declare @id int

set @id...

there's a good article here on SSC by Brian Kelly that covers allof the tools i've ever used for finding sql servers:

.

Tools I Use to Scan for SQL...

Luis's /Seans's suggestions will perform the best;

if you want to stick with a scalar function, this post has a function fn_parsename, which fidns values form left-to-right, where the original parsename...