Found most of what I was looking for, thanks to anyone who tried.

http://www.codeproject.com/KB/database/foreachadossis.aspx

Ping back here with the actual DDL and some sample data if you get...

YSLGuru (1/31/2011)

---

Thanks for the suggestion but do you know if there is an equivelant syntax that shows all the servers...

Celko, the last week or two of you was pleasant. Did they take you off the meds?

Anyway, no, there is no simple way of getting the before/after rows that...

With no sample data and no ddl, it's hard to help you here other then to give you some troubleshooting steps.

Try commenting out portions of the code until you don't...

dajonx (1/31/2011)

---

Hi,

I was wondering if there is a way to remove a killed SPID that has been in rollback for a week without restarting SQL service. The SPID was...

I don't have the setup to test this, so sorry for using you as the guinea pig, but can you try changing this:

SET @SQLString = N'SELECT @CountOUT = COUNT(*) FROM...

*facepalm* Picard's gonna make a comeback.

FROM

AZVIEWS.DBO.VW_SNF601 HIS WITH (NOLOCK) --18877

LEFT OUTER JOIN

azVIEWS.DBO.VW_SNF617 A WITH (NOLOCK) --18552

ON HIS.EID = A.EID

AND A.ORDERSTARTDATE >=DATEADD(HOUR,8,CAST(CONVERT(DATE,GETDATE()-1)AS DATETIME)) AND A.ORDERSTARTDATE <= GETDATE()

LEFT...

It's...

Actually, my guess is that's way off target. That's server architecture, a whole...

vadon97 (1/31/2011)

---

I work with SQL databases on a high level... meaning I run queries and stored procedures, and backup/restore databases on the regular. I want to apply for...

In general... yes. Unless you're doing different forms of mathmatics to the date.

The DATEADD you're seeing, is it wrapping a DATEDIFF? If so, they're stripping away pieces of...

I would personally approach this in a different method, using a full outer join structure.

CREATE NONCLUSTERED INDEX idx_my_table ON #my_table (mt_state, mt_cust_id, mt_Invoice_No)

GO

SELECT

ISNULL( drvActive.mt_cust_id, drvInactive.mt_cust_id) AS mt_Cust_id,

ISNULL( drvActive.MaxActive, drvInactive.MaxInactive) AS...

Odd, that link should have taken you right to it. Ah well.

Next: finding...

sdownen05 (1/31/2011)

---

Thanks, Craig. This seems to work. My concern was that, the way you constructed it, sinced it didn't pull the price along with the max date and the item...