Sean Lange (6/14/2016)

---

ScottPletcher (6/14/2016)

---

My advanced knowledge, "tricky" q is:

In autocommit mode, when can an UPDATE statement partially complete, some UPDATEs made, some not, where SQL does not roll it back?...

My advanced knowledge, "tricky" q is:

In autocommit mode, when can an UPDATE statement partially complete, some UPDATEs made, some not, where SQL does not roll it back?

Edit: And...

Maybe this:

insert into #mailing

(segment

,contact_number)

select @mailing + RIGHT('0' + CAST(base_value + row_num AS varchar(2)), 2)

,AccountNumber

from (

select distinct AccountNumber, ROW_NUMBER() over(order by AccountNumber) as row_num

...

I'd make a slight adjustment, since I prefer to check conditions as near to the source as possible, and it might even be slightly more efficient:

SELECT X1,

...

Eric M Russell (6/9/2016)

---

Sean Lange (6/9/2016)

---

Eric M Russell (6/9/2016)

---

patrickmcginnis59 10839 (6/9/2016)

---

Eric M Russell (6/7/2016)

---

Luis Cazares (6/7/2016)

---

Was I too late for April fools' day?

This is what happens when you trust a...

GSquared (6/9/2016)

---

Sean Lange (6/7/2016)

---

Jeff Moden (6/7/2016)

---

I think it's a great question. It shows whether or not...

SQL Server has built-in performance reports that could help you here.

Using SSMS, for the instance that contains the db having the problem:

1) right-click on the instance name

2) select "Reports"

3) select...

With just a quick look, I'd do something like below. I tried to follow your naming style, naturally change as needed.

Since we can't guarantee unique ProductNumbers across companies, we'll...

Dennis Q Miller (6/1/2016)

---

Stacey Decker (10/30/2014)

---

I agree, why allow two values to mean the same thing? I handle this by allowing optional fields such as AddressLine2 to be NULL and...

The best clustered index is almost always the single most critical performance factor for a table. You could gain some mild efficiencies looking at other things, but a far,...

cyp901 (5/31/2016)

---

I believe what Jeff Moden was trying to say...

You can use derived tables within the query to provide computed values, you don't need variables.

Also, here's a quick demo to show that you can query from different tables, as...

djj (5/26/2016)

---

ScottPletcher (5/26/2016)

---

If the table structures to be returned are the same for all conditions, you can use UNION ALL with the appropriate WHERE conditions so that only one query...

For up to 3 accidents total, it's relatively straightforward, with a single table pass for each table -- afaik, beyond 3 would require additional code/complexity (at least one additional join/select...

You SET @startdate twice instead of setting @enddate 🙂

..

set @startdate = '01-01-2016'

declare @enddate datetime

set @startdate = '10-10-2016' --should be set @enddate = ...

...