Paul,

I know you know this - this is just be...

But the OP blasted him right back

torpkev (12/20/2010)

---

I could put a cursor on the table - use variables to hold the ethnicity types and various if statements to get the end value and then do an...

Something like:

SELECT PersonID,

Ethnicity = CASE WHEN (Expression to determine Caucasion) THEN 'Caucasion'

...

Well, the expected results that you provided are not based on the sample data you provided. (the expected...

Greg Edwards-268690 (12/20/2010)

---

WayneS (12/19/2010)

---

WayneS (12/16/2010)

---

What are your preferences for VM machines - VMWare or VirtualPC?

I've been using VMWare for years (and am happy with it), but to install a 64-bit...

WayneS (12/16/2010)

---

What are your preferences for VM machines - VMWare or VirtualPC?

I've been using VMWare for years (and am happy with it), but to install a 64-bit Windows 7 and...

Gianluca Sartori (12/17/2010)

---

GilaMonster (12/17/2010)

---

The x64 processor architecture is sometimes known as AMD64...

Charles Kincaid (12/17/2010)

---

I did not know that you could put a CTE in a view. I tried it and it worked. Seems reasonable given what a view actually...

The actual code being run is:

(Deadlock victim)

From procedure: DB.dbo.proc_AddWorkflow

IF (@Configuration & (128 | 1024 | 512)) = 0 AND

((@Configuration & 256) <> 0 OR

NOT EXISTS (SELECT

*

FROM

dbo.Workflow

WHERE

SiteId = @SiteId AND

ListId =...

This should give you an idea for how to do this.

If this doesn't work, please follow the advice given by Gianluca.

-- See how you start off by actually creating a...

This code:

SET NOCOUNT ON;

DECLARE @test-2 TABLE (Name char(5), createdate datetime);

INSERT INTO @test-2

SELECT 'Test1', '12/01/2010' UNION ALL

SELECT 'Test2', '12/02/2010' UNION ALL

SELECT 'Test3', '12/03/2010' UNION ALL

SELECT 'Test4', '12/04/2010' UNION ALL

SELECT 'Test5', '12/05/2010';

SELECT...

It sounds to me like the either the PK or a UNIQUE constraint is firing. The first runs fine because there are no duplicates; the second+ fails because of a...

If you post your deadlock graph, we can probably help you figure it out.

fthiemonge (12/17/2010)

---

I'm a big fan of making my own templates in the template explorer. Not many people in my office use them but they are a huge help getting you...