Alex Prusakov (5/6/2009)

---

There is no place that is perfect in every way. It is pure math and normal that a lot of people just want a paycheck but not an...

Original code:

BEGIN TRANSACTION

SELECT * FROM UserStats WHERE UserID = @UserID

IF @@ROWCOUNT = 0

BEGIN

INSERT INTO UserStats (UserID) VALUES (@UserID)

END

COMMIT TRANSACTION

What I would do:

insert into UserStats

select

@user-id

from

...

I saw the OP's reply before I saw your warning. Obviously the force was not with us at the time.

Technically, I'd say yes. You may want to consider licensing the other server on a per CPU license as well.

Alvin Ramard (5/6/2009)

---

Alvin Ramard (5/6/2009)

---

Lynn Pettis (5/6/2009)

---

Alvin Ramard (5/6/2009)

---

Lynn, let me know if you understand the OP's last reply in the thread about the rolling 12 months. I don't...

ericb1 (5/6/2009)

---

I have an ASPXGridView in VisualStudio (http://www.devexpress.com/Products/NET/Controls/ASP/Grid/)

This control builds grids, which is based off a view I have in SQL2k5. I needed to add a WHERE clause to...

Alvin Ramard (5/6/2009)

---

Lynn, let me know if you understand the OP's last reply in the thread about the rolling 12 months. I don't think he knows what you...

Alvin Ramard (5/6/2009)

---

ericb1 (5/6/2009)

---

sorry about that, I should have given more info. It's actually for another application, which is handling the indexing, so it's not an issue. Thanks...

From the Merriam-Webster on-line dictionary:

I guess it depends. I tend not to apply the CU's unless I have an issue that is addressed by the CU.

Not sure how performant this will be, and it may not be the best way to accomplish it.

create a view that accomplishes the openquery with NO criteria, you are asking...

Bruce W Cassidy (5/6/2009)

---

[font="Verdana"]Does anyone remember a language called Algol? I believe that in the original form, it had no concept of "reserved words", so it was perfectly valid...

Would you please post the code for your tvf?

If I read you right, correct, you can't use a stored procedure in a query like a table. that's why you would need to load the data returned from...

My fault, was looking at something else while typing. Move the last argument to the first, the first to the second, and the second to the third.