Lynn Pettis (6/9/2009)

---

AND!! Based on many of the PhD's I have met (this doesn't...

SELECT DATEADD(month, -1, GETDATE())

DECLARE @NoPrevious INT

SET @NoPreviou = 13

SELECT DATEADD(month, -@NoPrevious, GETDATE())

Not exactly there yet, without some sample data. It relies on having a primary key, pKey, in numerical sequence

UPDATE T1

SET T1.ColC = T1.ColA - T1.ColB,

...

Hi

I'm sure Barry & Gail will give full answers, but this interpretation may help.

Don't think of O(n) / O(n^2) as proper mathematical formulas that can be solved. Think of...

I like the variety of stuff that comes up in this thread. There's always something interesting to look at in a bored moment.

I never did computers at University...

I wish I could, but - its corporate PC - controlled by some central...

What do I do to deserve this 🙁

Before you click on the link, be aware that they OP has posted vast quantities of data - twice - it now crashes...

Less haste please ...

1) See my first reply - Is that CREATE TABLE statement correct? - if not can you post a correctef version.

2) Can you format your sample data...

The code is in a nice box, because its enclosed in

[ code ] ... your code here ... [ /code ] blocks - I have put extra spaces...

Hi Byron, and welcome to the forum.

First of all see this article on how to get the best help

http://www.sqlservercentral.com/articles/Best+Practices/61537/

I've tried to understand your problem, and I'm probably oversimplifying here -...

RBarryYoung (6/2/2009)

---

Had to do a search for it, not having been to the...

[subjectchange]

Steve. Can you upload a new avatar photo please it looks like a photo in 16/256 colours - I'm sure its not my display settings as other peoples' avatars display...

I've figured out where I went wrong.

1) While you can backup the master key and certificates, you can't back up a symmetric key.

2) if you want to re-create the same...

Roy Ernest (6/2/2009)

---

I dont think any of my articles would have been published in another site than here. Especially the Upsert I was trying to push as a good idea....

OK You've done things a different way to me.

But I've got it very wrong.

I've checked my data, and I can't access data encrypted before the database was restored :angry: ...