Glad we could help.

And don't worry, we don't apply the death penalty until the third time you post a question without fulfilling all possible requirements on it. :w00t:

I think you'd be best off building a custom service for that. Should be simple enough to build a .NET service that you grant access to the tables and...

Happen to know where to get a list of all the time-zone abbreviations? I tried a quick search online, including a couple of wikipedia articles, and couldn't get anything...

Steve Jones - SSC Editor (7/10/2012)

---

jay-h (7/10/2012)

---

SQLRNNR (7/10/2012)

---

If you can show that there is data to support a decision, it is more likely to be well received than one...

Should the code be sensitive to Daylight Time vs Standard Time (US), or should it rely on "EDT" vs "EST" in the input?

If sensitive without the input being modified, should...

Without your table structure and some sample data, we're left guessing on parts of this, and left doing more work than would be necessary if you provided that. We're...

How about something like this?

CREATE VIEW dbo.Rnd

AS

SELECT NEWID() AS R ;

GO

ALTER FUNCTION dbo.character_scramble

(@OriginalVal_in VARCHAR(MAX))

RETURNS VARCHAR(MAX)

AS

BEGIN

...

Jeff Moden (7/10/2012)

---

ChrisM@Work (7/10/2012)

---

Jeff Moden (7/9/2012)

---

In 2008 or less, I'd REALLY like to know how to create a view that does a running total without forming a Triangular Join. ...

I'm used to using GUIDs instead of identities for Merge Replication, specifically to avoid these kinds of problems.

Assuming you don't have the option of switching to those at this late...

Jeff Moden (7/10/2012)

---

SQLKnowItAll (7/10/2012)

---

Hmm... So, because it worked on a set of 3 records you will accept it? Do you even know what that is...

ChrisM@Work (7/10/2012)

---

GSquared (7/10/2012)

---

Just looked in Jeff's old article on running totals, and on his PC, the quirky-update running total on a million rows of data was about 6 seconds. ...

I'll assume by the smiley at the end that this was meant sarcastically/facetiously.

I'm...

There are times when cursors are the best or even the only viable solution. No question about that. Generally speaking, avoid them. But in specific cases, they're...

Just looked in Jeff's old article on running totals, and on his PC, the quirky-update running total on a million rows of data was about 6 seconds. Assuming margin-of-error...

The prior attempt is still rolling back, so I modified the script as follows:

USE tempdb

GO

IF OBJECT_ID(N'tempdb..Simpletable2') IS NOT NULL

DROP TABLE Simpletable2 ;

IF OBJECT_ID(N'tempdb..vwRunningTotals2') IS NOT...