While you certain can use BCP - depending on where the folder happens to be, you end up having to get messy with user security. For that reason -...

Try:

CAST (o.[data] AS XML).value ('(/Operation/Initiator/@dn)[1]', 'nvarchar(255)') AS xmlChangeHistory

Create a table variable or temp table, and output into it.

declare table @outputtbl(alarm_account int);

update ACS set ACS.Contract_Start_Date = zzp.start

...

CirquedeSQLeil (2/24/2010)

---

Elliott W (2/24/2010)

---

I don't fully agree with Cirq..

I think a fundamental problem with many dev and test environments is limited data, prod data may not belong, but...

Sorry to say - but no. It's baked into the UPDATE (it's actually described, albeit badly in the BOL entry about UPDATE).

If you have any ability to add a...

It sounds to me that table1 and table2 have a 1 to many relation. In other words - the "left" side of the join is providing 346 rows, and...

Simply replacing the cursor with another looping process will tend to not give you any gain at all. While you will hear "don't use cursors" commonly as a mantra...

- You could batch them into a single XML document and process that inside SQL using SQLXML.

- you could look at using SQL Service Broker. One of the...

It actually sounds like standard Secure Computing/administration requirements. It's back to the age-old observation that the #1 way to get elevation of privilege attacks is to try to "hijack"...

Is it really necessary to do row-by-row inserts? You're killing performance that way. If it were possible to do this set-based you'd be inserting multiple times what you're...

WayneS (2/22/2010)

---

If you use sp_executesql, the dynamic string can be set up so that all variables are parameters, and the parameters also passed in thru sp_executesql. As you add/drop lines...

Ray K (2/22/2010)

---

I had one interview where they gave me (I think it was) a half-hour to answer ten programming questions. (It was sufficiently long enough ago that I...

Greg Snidow (2/22/2010)

---

That's pretty scary. I'm thinking an IF statement looking for key words like 'SET','UPDATE','DROP','ALTER', etc might work to thwart that kind of attemp. But if the...

Greg Snidow (2/22/2010)

---

Matt, thanks for the reminder. I work in a fairly safe environment, so I don't always consider that as a threat. However, I don't want to...

GSquared (2/22/2010)

---

James Goodwin (2/22/2010)

---

Here's the thing that gets me:

Why is everyone using CASE WHEN (number % 5)=0 And (number % 3)=0, instead of CASE WHEN (number %15) = 0?

I want...