Andy Warren (8/8/2014)

---

I've only had one bad title - Delivery Lead. The client knew what it meant, I knew what the client wanted, but no one else on the team...

ratneshsinghparihar-1130833 (8/6/2014)

---

@david-2

Yes , i missed the sql as well .

30 years ago when RDBMS were taking into shape and wining over file systems . The choice for developers was to...

put a ";" in front of the WITH. WITH is very finnicky about having a separation between it and any previous SQL statements

As in:

Select *

From CampServ.dbo.SampleFakeCustomerData

//This is where I...

The "." is similar to DOS-style directory commands: it means the "root" of the current element.

The "[1]" means the first occurrence of that particular path within your...

Agreed - and both go well...

GoofyGuy (8/4/2014)

---

Matt Miller wrote:

... depending on the type of process you're dealing with, it may not be physically possible to test every single permutation, so - yes in some cases...

GoofyGuy (7/31/2014)

---

Steve Jones - SSC Editor (7/31/2014)

---

GoofyGuy (7/31/2014)

---

"A job that runs long or doesn't run at all can sting just as bad as one that fails."

What's the difference?

There is no...

Do you know for a fact that the delete operation finishes? With an ODBC connection, you would be subject to connection timeouts, which as I recall would rollback the operation.

Also...

Here's an example which might prove useful:

declare @addinfo xml;

declare @empinfo xml;

declare @toplevel xml;

set @toplevel='<Regions>

<Region>

<Name>North</Name>

<Stores>

<Store>

...

There has been a rash of spam posts to advertise pay channels for various types of events. Pretty sure the admins had to clamp down on various posts (probably...

mballico (7/23/2014)

---

To clarify the problem. The initial calculation is: Round (177673.74 * 0.21,2) = 37311.49

Then I need to make the opening of each item and the corresponding calculation, which...

Eric -

You might get lucky here (some folks deal with both Oracle and SQL Server), but If you need Oracle help, you probably want to ask on an Oracle...

Miles Neale (7/24/2014)

---

Steve,

In reading both your post and the reference article, I find them both true and accurate. There are those who will look at data as the hallowed...

Agreed! Any time you're in a dev tool, you can ultimately make something secure or insecure.

That said - I do think that some of the newer VS improvements (especially...

Dalkeith (7/18/2014)

---

I personally like MS Access. Its sweet spot is definitely complicated internal systems with limited distribution and users but that covers a great deal of systems.

I would prefer...