Stefan Krzywicki (5/22/2012)

---

Many should format it all at once, like with...

umar.memon (5/22/2012)

---

I am looking for a Table Valued function to do this functionality, pass comma delimited field, and than it will treturn me an updated one so I can use...

Perhaps one day I'll be smart enough to report a SQL bug to Microsoft and have them acknowlege it as such. I'll need...

SQL Kiwi (5/22/2012)

---

It works out how many of each digit are in the initial string, and...

SQL Kiwi (5/22/2012)

---

I would probably implement this in a SQLCLR scalar function, but this is another option for T-SQL:

SELECT

REPLICATE('0', LEN(f.string) - LEN(REPLACE(f.string, '0', ''))) +

...

For a demonstration in awkwardness and to avoid the initial split string, I humbly offer the following solution:

Create Table #temp

(MRN nchar(10) null,

additional_procedure varchar(max),

additional_procedure_Location varchar(max))

insert into #temp (MRN,additional_procedure,additional_procedure_Location)

SELECT...

Jeff Moden (5/22/2012)

---

In my experience and depending on the subject and previous familiarity to teach a course well, it takes 10 minutes to 8 hours of prep time for each...

Lynn - I believe it was a parsing opportunity and that this is the thread to which Jeff refers: http://www.sqlservercentral.com/Forums/Topic1300365-392-2.aspx

shaunna (5/22/2012)

---

The records are not always one minute apart, they can actually be time stamped fairly irregularly because the polling servers that record the data can have delays before writing...

Cadavre (5/22/2012)

---

It's easy enough to fix, but last time I pointed out that I thought you'd missed something you seemed slightly ticked off so I thought I'd try something different...

Doesn't work obviously! Note the statement at the end...

If there are CPU...

The really funny thing is that I used to use this form too. Until I realized the SET statement would never...

While I was on my way home I kicked myself for not realizing the case it wouldn't work on.

Glad to see someone rose to the occasion and corrected me before...

Jeff Moden (5/22/2012)

---

The really cool part is that both of you rose to the occasion. 🙂

Shifting gears a bit... Lynn wrote...

I have learned to stay away from scalar functions....