cphite (5/25/2012)

---

Lynn Pettis (5/25/2012)

---

cphite (5/25/2012)

---

blampe (5/25/2012)

---

The countSSN procedure runs fine, but what I am trying to do is actually physically replace the values in the table with these count values...

CptCrusty1 (5/25/2012)

---

I'M WRONG!!!! OK! I ADMIT IT!!!!! SOMEONE GET A BOWL OF CROW FOR ME TO EAT!!!!

oK.. TONS of research later and I realize my hang...

Look up the INSERT statement syntax in Books Online.

Really not enough info to tell you more, but then you already know that.

CptCrusty1 (5/25/2012)

---

OK... dba says something else is going on, so I'm going to believe him.. BUT.. he also said there could be an issue with the execution sequence which is...

Must have missed that one, too.

Yes, I think I...

You asked about NOLOCK, here is one link. I'll keep looking for others.

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

Lynn Pettis (5/25/2012)

---

Revenant (5/25/2012)

---

Lynn Pettis (5/25/2012)

---

Could I get a few more people to look at the last few posts in this thread please? I want to be sure what...

Revenant (5/25/2012)

---

Lynn Pettis (5/25/2012)

---

Could I get a few more people to look at the last few posts in this thread please? I want to be sure what I said...

After fixing your view, and looking a bit closer at the data in this sample code, your problem may also be in the how you are joining the data together.

If...

Slight problem with your views (or at least the code you posted). Both views are based on table1.

Could I get a few more people to look at the last few posts in this thread please? I want to be sure what I said is possibly the...

Here is the code from the initial post, formatted.

CREATE VIEW [dbo].[vw_ScheduledReceipts]

AS

SELECT term.StateCode AS OriginState

,dest_ad.[State] AS DestinationState

,ImpExp = CASE

WHEN term.StateCode = ord.DestState

THEN 0

ELSE 1

END

,Carrier# = CASE

WHEN ord.CarrierID >= 2000

THEN...

Personally, I have the mdf/ndf/ldf files skipped on the server level backups. I have scheduled full/differential/transaction log backups handling the databases. As long as those files (bak/trn) are...

cphite (5/25/2012)

---

blampe (5/25/2012)

---

The countSSN procedure runs fine, but what I am trying to do is actually physically replace the values in the table with these count values generated by the...