Roles are your friend here...you should add the user to the db_datareader role which will have the same effect. You have to ask yourself, do you really want to...

That was a great article Gail! Thanks for sharing, It's one of those subtle things most probably learn the hard way.

So with that in mind here is update code......

GilaMonster (6/13/2016)

---

You mean other than the one I linked in my first...

GilaMonster (6/13/2016)

---

I disagree MERGE is NOT atomic (it should be, it isn't) and hence both it and the...

ChrisM@Work (6/13/2016)

---

Y.B. (6/13/2016)

---

Maybe something like this would be better suited...

IF EXISTS (SELECT 1 FROM SomeTable WHERE ID = @id)

UPDATE SomeTable SET SomeText = @SomeText

ELSE

INSERT INTO SomeTable VALUES (@ID, @SomeText)

EDIT: Although...

Maybe something like this would be better suited...

IF EXISTS (SELECT 1 FROM SomeTable WHERE ID = @id)

UPDATE SomeTable SET SomeText = @SomeText WHERE ID = @ID

ELSE

INSERT INTO SomeTable VALUES (@ID,...

Greg Edwards-268690 (6/9/2016)

---

Y.B. (6/9/2016)

---

So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?

I realize that there...

So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?

I realize that there are good use...

Me 😉

amy26 (6/8/2016)

---

LOL you're right I was over complicating it... DENSE_RANK worked just peachy.... I admit I didn't know about the dense_rank function ... *blush*

Don't worry, those aren't the actual names...

You might be over complicating things...is this what you want?

DECLARE @myTable TABLE (Code VARCHAR(7))

INSERT INTO @myTable

VALUES ('AB10003'), ('RG42421'), ('RG42421'), ('RG42421'), ('DG31311')

SELECT DENSE_RANK() OVER (ORDER BY Code) AS RowNum, Code FROM...

Erik de Jonge (6/8/2016)

---

Unfortunately not. We were testing with a very basic query 'select * from table where date >= date1 and date <= date2' type query. Something we'll have...

I understand when stuff goes wrong in production usually the panic sets in. However, before you reset SQL did you at least capture an execution plan of the long...

Grant Fritchey (6/1/2016)

---

yb751 (6/1/2016)

---

Steve Jones - SSC Editor (6/1/2016)

---

yb751 (6/1/2016)

---

Christmas in June!!!

The purchase of some Red Gate tools finally got approved by my boss. 😀

Feels like I've been begging...

Trust me, I'm not crazy about it either. I have a couple of other ideas but until I hear from the OP I'd just be taking more shots in...