Sean Lange (3/20/2013)

---

I think that the above would miss Claim 7149 which as I read your issue should show up on the list. This is easy enough to correct by...

The question you asked...

Something like this:

CREATE TABLE ClaimStatus(

ClaimID int NOT NULL,

StatusDate datetime NOT NULL,

StatusCode int NOT NULL);

INSERT INTO ClaimStatus VALUES (7150,'2013-03-11 10:41:29.823',100);

INSERT INTO ClaimStatus VALUES (7150,'2013-03-12 07:20:41.720',300);

INSERT INTO ClaimStatus VALUES (7150,'2013-03-15...

Post the DDL (CREATE TABLE statement) for the table, about 4 or 5 rows of sample data (NOT real data) that mimics the problem domain, and the expected results based...

Sean Lange (3/20/2013)

---

Sure this isn't too hard using a tally table.

insert #y

select #x.DocID, t.N

from #x

join tally t on t.N <= #x.pages

select * from #y

You can read about a...

Is this some sort of inventory database?

sixthzenz (3/20/2013)

---

I have several non-clustered covering indexes on a table that have the same key columns with few included columns. I'm wondering if i can just create one NC covering...

You do realize that shrinking a database will fragment the indexes used by the queries run to generate the reports and that this will impact the performance of the reporting...

Make these easier...

TheSQLGuru (3/20/2013)

---

tafountain (3/20/2013)

---

TheSQLGuru,

I did not intend to spark a debate 🙂 but here are my responses.

This...

Please post the following:

DDL for the two tables, including the indexes (leave off extended properties if you have those)

Actual execution plans for the good and bad query executions. Save the...

I would do something like this if it were my table:

select

ds.Item

from

dbo.YourTable yt

cross apply dbo.DelimtitedSplit8K(yt.YourColumn,'|')ds

where

ds.ItemNumber...

Considering that it says test items on it, how about you show us what you have written and we will provide you with feedback on changes you may want to...

try this and see if it helps:

select right('0' + cast(month(getdate()) as varchar),2)

Something like this, just off the top of my head:

declare @StartDate datetime,

@EndDate datetime;

select

@StartDate = dateadd(hh,...