EDIT: removed, posted in wrong thread.

Code below has fewer calcs and does not depend on any SQL date settings.

DECLARE @year int

SET @year = 2012 --<<-- chg as needed

SELECT

month_start,

...

Lynn Pettis (9/14/2012)

---

/****** Object: UserDefinedFunction [dbo].[DelimitedSplit8K] Script Date: 09/14/2012 09:43:51 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DelimitedSplit8K]') AND type in (N'FN', N'IF',...

SELECT

TimeFrame / 100, CAST(TimeFrame AS int) % 100

FROM dbo.TimePeriod

WHERE

model= 'A1' AND

TimeFrame / 100 = (

...

Btw, yes, PRINT is exceedingly slow. Use it only when absolutely necessary.

ChrisM@Work (9/14/2012)

It's quite common for a product to "evolve" over time without its' stock code changing - it's rampant in the fashion world. Clients, agents, reps all know an item...

stanlyn (9/13/2012)

---

Hi Scott,

Running your script, it returns:

Which begs the question on why the Page table has 3 PK_Page_Identity indexes, as it should have only one. That's the only thing...

Is the PK also a clustered index?

Is the identity column used in any another index?

Please post the DDL for the filtered index.

Perhaps, perhaps not. But is that a good way to do it, regardless of how common it...

You can use this to check for files that still exist in a given filegroup(s):

SELECT

FILEGROUP_NAME(a.data_space_id) AS File_Group,

OBJECT_NAME(p.object_id) AS Table_Name,

...

SELECT

Item,

MAX(CASE WHEN [Group ID] = @group1 THEN Permission ELSE '' END) AS Group1_Permission,

MAX(CASE WHEN [Group ID] =...

Lynn Pettis (9/13/2012)

---

ScottPletcher (9/13/2012)

---

but if you are creating a table of product groups (<'BK','Books'>,<'SH','Shoes'>,<'BG','Bags'>) etc.. I would put an ID field on that and use that instead, otherwise if someone...

but if you are creating a table of product groups (<'BK','Books'>,<'SH','Shoes'>,<'BG','Bags'>) etc.. I would put an ID field on that and use that instead, otherwise if someone decides they need...

A company I worked for produces clothing catalogues. Each catalogue has a 2 character reference. They produce about 130 catalogues/adverts a year, but not all letters get used...

Eugene Elutin (9/12/2012)

---

Greg Snidow (9/12/2012)

---

Jeff Moden (9/12/2012)

---

It's even more annoying when you need it and it's...