SQLKnowItAll (7/16/2012)

---

ScottPletcher (7/16/2012)

---

CREATE TRIGGER dbo.project_trg_ins

ON dbo.project

AFTER INSERT

AS

UPDATE...

Something like below should do it:

SELECT

CASE WHEN backup_month IS NULL THEN 'ALL'

ELSE LEFT(DATENAME(MONTH, backup_month), 3) END AS...

CREATE TRIGGER dbo.project_trg_ins

ON dbo.project

AFTER INSERT

AS

UPDATE p

SET

...

JayWinter (7/12/2012)

---

In this case SKU and UPC are the same and therefore its usage is correct. However my challenge is that there may be more than 1 record that meets...

Presumably the ContactID is indexed.

If there can only be single-line gaps, you can do this:

SELECT

c1.ContactID - 1 AS Missing_Number

FROM #Contact c1

WHERE NOT EXISTS...

dan-572483

I was surprised to see that the Estimated Execution Plan shows a slightly higher cost for LEFT(LastName,2) over LIKE. The Plan for LIKE recommended creating a nonclustered index...

Not quite.

LIKE 'xxx%' can...

I don't think you really need indexing, since you can do everything in a single pass of the table, w/o JOINs, etc..

SELECT

ACTIONID,

CASE...

Lynn Pettis (7/11/2012)

---

Matt Miller (#4) (7/11/2012)

---

Lynn Pettis (7/11/2012)

---

This works as well:

CREATE TABLE [dbo].[TEST1](

[ID] [VARCHAR](10) NULL,

[VALUE] [int] NULL

);

GO

INSERT INTO dbo.TEST1 (ID, VALUE) SELECT 1, 10;

SELECT 'PRE' LABEL1, * FROM dbo.TEST1;

DECLARE @SAVE1...

Lynn Pettis (7/11/2012)

---

ScottPletcher (7/11/2012)

---

gerard-593414 (7/11/2012)

---

I have a table which holds the next Invoice Number. What SP code should I use to increment it (Cant be self incrementing)

There are numerous...

gerard-593414 (7/11/2012)

---

I have a table which holds the next Invoice Number. What SP code should I use to increment it (Cant be self incrementing)

There are numerous users and want...

I think the query below is equivalent to your original one, w/o all the unnecessary join (unless the join on DAY restricts the rows selected from the "report" table). ...

cfradenburg (7/10/2012)

---

ScottPletcher (7/10/2012)

---

Jeff Moden (7/9/2012)

---

ScottPletcher (7/9/2012)

---

SELECT

(ident - 1) % 3,

MAX(CASE WHEN (ident - 1) % 3 = 0 THEN value ELSE 0...

Jeff Moden (7/9/2012)

---

ScottPletcher (7/9/2012)

---

SELECT

(ident - 1) % 3,

MAX(CASE WHEN (ident - 1) % 3 = 0 THEN value ELSE 0 END) AS...

SELECT

(ident - 1) % 3,

MAX(CASE WHEN (ident - 1) % 3 = 0 THEN value ELSE 0 END) AS part,

...