Ed Wagner (7/24/2015)

---

Sean Lange (7/24/2015)

---

Wow so much complaining about skipping a word in the question. I don't recognize most of the names of those complaining. I suspect that is because...

Wow so much complaining about skipping a word in the question. I don't recognize most of the names of those complaining. I suspect that is because they haven't posted their...

rs-337036 (7/23/2015)

---

I want to CONCATENATE a field if the rows have the same Id. For example the data looks like

ID Name ...

Ed Wagner (7/23/2015)

---

Lynn Pettis (7/23/2015)

---

Ed Wagner (7/23/2015)

---

Sean Lange (7/23/2015)

---

I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink...

Ed Wagner (7/23/2015)

---

Sean Lange (7/23/2015)

---

I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across...

I was just doing some work on our new ERP that we are migrating to and I nearly spit out my drink when I ran across this.

MVXJDTA.MPDOPE.POOPNO

Seriously that table has...

Siberian Khatru (7/22/2015)

---

My brain is dead today, but isn't there an automatic log of some sort to check and see what exactly was changed by a given SQL command? ...

Alvin Ramard (7/22/2015)

---

Lynn Pettis (7/21/2015)

---

Stephanie Giovannini (7/21/2015)

---

Lynn Pettis (7/21/2015)

---

Stephanie Giovannini (7/21/2015)

---

Sean Lange (7/21/2015)

---

If this is a sql job, which I assume it is, just ask them for any built in...

Great question. This code is a good example of "just because you can do something doesn't mean you should".

Mr.Sahand (7/22/2015)

---

Try this, should work for you.

CREATE TRIGGER a_insert ON a

FOR INSERT

AS

BEGIN

Set XACT_Abort oFF

begin try

DECLARE @a AS VARCHAR(40)

SET @a = 'count of transaction' + CONVERT(VARCHAR(10), @@TRANCOUNT)

PRINT...

Lynn Pettis (7/21/2015)

---

Stephanie Giovannini (7/21/2015)

---

Sean Lange (7/21/2015)

---

If this is a sql job, which I assume it is, just ask them for any built in function to get the current datetime....

traczek2 (7/21/2015)

---

Hello. I am trying to complete this Microsoft lesson at: https://technet.microsoft.com/en-us/library/ms167305(v=sql.110).aspx

I am on WIN 8.1 and using SQL Server 2014.

Step 1 is completed.

Step 2 is...

If this is a sql job, which I assume it is, just ask them for any built in function to get the current datetime. If they hesitate more than a...

andrew gothard (7/21/2015)

---

Sean Lange (7/21/2015)

---

andrew gothard (7/21/2015)

---

Hi all,

I have the following scenario.

We have a...

laorozco1 (7/21/2015)

---

Good Morning All:

Can someone helpme with this query?

I need a query that when i provide a data in this case '313126459' it check if exixt in BC2, then if...