WangcChiKaBastar (1/3/2012)

---

I had a trigger on a table for Delete event which calls a stored proc P_Test that takes one parameter.

I dropped the trigger but when I delete a record...

Check to see if you merely unpinned it, or overlapped it.

Is it in a grey bar on the left side of the object explorer, or in a tab at the...

No, there isn't. SQL Server always logs. There isn't a 'nologging' option for a database either, it's just a simpler mode where it'll re-use existing log space once...

Any chance you've got the Deadlock Graph handy?

Right idea Sean but I believe he'll need to use a derived column instead, since I'm assuming he's using SSIS. Can replace the existing but I usually prefer a...

"I just ate at Whattaburger!" I mean seriously, they're tossing them in food for advertising assistance...

You're right, it doesn't, I was just trying to be thorough.

And then there's me, who's a DB Developer and not a front-end guy, and I build the back end architecture.

Why don't I usually use constraints except in "absolute, must have"...

Brandie Tarvin (1/2/2012)

---

Evil Kraig F (12/30/2011)

---

My favorite RPG of all time was Shadowrun. 2nd Edition. I recently tried to GM a campaign (well, recently being a year and...

My favorite RPG of all time was Shadowrun. 2nd Edition. I recently tried to GM a campaign (well, recently being a year and a half ago) in the...

I had a full head of steam going early last year in my self-training for the MCM, blogs, got a few articles up here, etc... and realized I just tried...

bwagner 90365 (12/29/2011)

---

I'm fairly knowledgable with T-SQL, but I have a question before I attempt my next endeavor. We currently have an application that requires our team to enter...

drew.allen (12/29/2011)

---

I would use Row_Number, because using MAX() in a subquery has the possibility of duplicate values if there are multiple records...

Gonzo in the Cannon.. then the wall... then the roof... then the clouds... and another wall... random...

I wouldn't do this with Row_Number, I'd approach it this way:

SELECT

elx.*

FROM

dbo.esg_ldc_xref AS elx

JOIN

(SELECT

Account_Number,

MAX(End_Date) AS MaxEndDate

FROM

dbo.esg_ldc_xref

GROUP BY

Account_number

) AS drv

ONelx.Account_number = drv.Account_number

AND elx.end_date = drv.End_Date

WHERE

customer_tkn in ( 56134996 , 90640028, 92448615)