Ed Wagner (3/8/2016)

---

Sean Lange (3/8/2016)

---

Ed Wagner (3/8/2016)

---

Michael L John (3/8/2016)

---

Ed Wagner (3/7/2016)

---

jasona.work (3/7/2016)

---

A couple people have commented on this elsewhere, but what the heck...

https://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/

To paraphrase a bit:

Dr. Peter Venkman: This...

Ed Wagner (3/7/2016)

---

jasona.work (3/7/2016)

---

A couple people have commented on this elsewhere, but what the heck...

https://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/

To paraphrase a bit:

Dr. Peter Venkman: This server is headed for a disaster of biblical proportions.

DBA:...

Stix83 (3/1/2016)

---

If I create my function as below, I get the following error:

Must declare scalar variable "@EndDate"

what I mean by the following is:

I don't want to put in a specific...

Stix83 (3/1/2016)

---

I have 3 functions that return a separate value for each one, i.e.:

CountOpps = Total Opps Created

CountRevWon = Total Revenue on Closed Opps

CountAssRValue = Total Revenue on Assessment Value

I...

Can you generate the scripts from development for all of the procedures, functions, and so forth?

Then, you could restore the DB from production, and run the scripts to update the...

Actually, I support your efforts 100%.

Please continue to download and run random code that you downloaded from the internet, without any understanding of it, and certainly without caring...

There are a couple things you can do.

You can run a query on a regular basis to test for new members. This may help get you started.

SELECT ...

Sean Lange (2/12/2016)

---

Luis Cazares (2/12/2016)

---

http://www.sqlservercentral.com/Forums/Topic1760779-2799-1.aspx

I was going to comment on that thread, but I...

mw112009 (2/12/2016)

---

Sean:

As promised I will share it later. Why ? I picked the sp from a website ( just a hour ago ). Before I share it, let me make...

Jeff Moden (2/11/2016)

---

Yeah... but I'm...

You need to test for the existence of a record in a table, and if it does not exist, you want to insert a record in another table, correct?

My question...

Yes, you are trying to use a trigger when you should be doing this test prior to doing the insert.

IF NOT EXISTS(SELECT 1 FROM SomeTable WHERE whatever test you...

Yeah, but I'm still younger than Moden!

Sean Lange (2/11/2016)

---

Michael L John (2/11/2016)

---

Sean Lange (2/11/2016)

---

Grumpy DBA (2/11/2016)

---

Sean Lange (2/11/2016)

---

Back in the late 80's early 90's when mix tapes were the thing I had a War Games themed...

Sean Lange (2/11/2016)

---

Grumpy DBA (2/11/2016)

---

Sean Lange (2/11/2016)

---

Back in the late 80's early 90's when mix tapes were the thing I had a War Games themed mix tape. I actually still...