Thom A (10/5/2016)

---

Sean Lange (10/5/2016)

---

Be careful if you use this code as a starting point. It has scalar values being populated from the inserted table. This is very problematic because...

Thom A (10/5/2016)

---

I'm going to admit here, triggers are not my forté. I rarely use them as our main database is third party, and repopulated every night (so we have...

peter478 (10/3/2016)

---

Sorry 🙂 , I just wanted to find some solution (example!) how to do it, I expected solution from your side, but you are always writing about first week....

ACK!!!! And of course this happens on Friday instead of Monday. Here is hoping you...

Eirikur Eiriksson (9/29/2016)

---

As Sean rightly mentioned, there are many ways of parsing and extracting values from an XML. Many of those methods are similar in syntax but may vary hugely...

This works until you have a [ or ] or some other funky characters in your...

chris.asaipillai-624309 (9/29/2016)

---

Hi there

I have a SQL table called dbo.AuditItem.

This contains a column called [OldRow]. This column is in XML format

I want to write a query to extract a piece of...

Even posted on a proper forum this question lacks clarity. It is not at all clear what you are trying to do. Have you looked at the FOR EACH loop?...

Your problem is right here.

FROM Customer, Address

You have separated your tables with commas using an old style join syntax. Since you don't specify which rows to match in your where...

mw112009 (9/28/2016)

---

A picture pf the text ( a portion of it ) is attached ( I can not give you the entire file due to security reasons )

As for...

mw112009 (9/28/2016)

---

Please see attached. This works fine and gets the Definitions of views saved in a txt file.

One little issue: Take a look at the first highlighted circle ( with...

bmg002 (9/27/2016)

---

you are already doing that.

if you are using 3 values in the object declaration, you are declaring the database, the schema and the object.

so in your case:

JIREM10.dbo.JIRABConcentration

JIREM10 is the...

mpdillon (9/27/2016)

---

Update. It does not seem to be a permissions issue. I believe it is a syntax issue.

Truncate Table [FS-JirEMSQL].JIREM10.dbo.JIRABConcentration Fails

But

Truncate Table JIREM10.dbo.JIRABConcentration is...

The absolute best solution would be stop naming tables _2008 etc. Add in a transaction year or similar as a column in the table and this is no longer an...

That is way cool.