Viewing 15 posts - 11,656 through 11,670 (of 26,486 total)
cphite (5/25/2012)
Lynn Pettis (5/25/2012)
cphite (5/25/2012)
blampe (5/25/2012)
May 25, 2012 at 2:03 pm
CptCrusty1 (5/25/2012)
oK.. TONS of research later and I realize my hang...
May 25, 2012 at 1:30 pm
Look up the INSERT statement syntax in Books Online.
Really not enough info to tell you more, but then you already know that.
May 25, 2012 at 1:23 pm
CptCrusty1 (5/25/2012)
May 25, 2012 at 1:20 pm
CptCrusty1 (5/25/2012)
Lynn, Did you look at the video link I posted?
Must have missed that one, too.
May 25, 2012 at 10:53 am
Sean Lange (5/25/2012)
Lynn Pettis (5/25/2012)
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
I posted Gail's favorite yesterday in case you missed it.
http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
Yes, I think I...
May 25, 2012 at 10:49 am
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
May 25, 2012 at 10:36 am
Lynn Pettis (5/25/2012)
Revenant (5/25/2012)
Lynn Pettis (5/25/2012)
May 25, 2012 at 10:26 am
Revenant (5/25/2012)
Lynn Pettis (5/25/2012)
May 25, 2012 at 10:22 am
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...
May 25, 2012 at 10:19 am
Slight problem with your views (or at least the code you posted). Both views are based on table1.
May 25, 2012 at 10:12 am
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...
May 25, 2012 at 9:53 am
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...
May 25, 2012 at 9:51 am
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...
May 25, 2012 at 9:48 am
cphite (5/25/2012)
blampe (5/25/2012)
May 25, 2012 at 9:42 am
Viewing 15 posts - 11,656 through 11,670 (of 26,486 total)