Alvin Ramard (6/12/2015)

---

Sean Lange (6/12/2015)

---

tsobiech (6/12/2015)

---

I think I'm just going to have to resign myself to the fact that I'm going to have to "manually" change the dates, every time,...

tsobiech (6/12/2015)

---

I think I'm just going to have to resign myself to the fact that I'm going to have to "manually" change the dates, every time, then copy/paste/format the data...

tsobiech (6/12/2015)

---

I need to run this report quarterly, thus it would be so much easier if I could just use something like Excel to "query" this data and return only...

spam reported

What is the timeout set to on the connection where this is happening? You have to isolate what is causing the problem. This may or may not be related to...

Have you checked out the stairway on indexes? http://www.sqlservercentral.com/stairway/72399/%5B/url%5D

Not sure why the previous links were funky...something weird is going on....

--EDIT--

The links had a couple invalid characters.

Sioban's Article[/url]

Jeff's fantastic article[/url]

This is one Sioban wrote on using a tally table...

RonKyle (6/5/2015)

---

The...

Brian J. Parker (6/5/2015)

---

Alan.B (6/5/2015)

---

RonKyle (6/5/2015)

---

I like this caveat, especially as it now excuses my one use I...

briancampbellmcad (6/4/2015)

---

Hope this helps as far as DDL and what the data looks like:

CREATE TABLE [dbo].[Billing](

[indx] [int] IDENTITY(1,1) NOT NULL,

[peopleId] [int] NULL,

[chargeamount] [money] NULL,

[billMonth] [int] NULL,

[billYear] [int] NULL,

CONSTRAINT [PK_Billing1st] PRIMARY...

PO Number has become the name of the value to indicate how a company identifies a purchase order. They...

Ahh the debate between natural and surrogate keys. This has been going on since the dawning of relational data. With things like VIN it is probably easiest to use that...

Robert Eder (6/4/2015)

---

The problem with script A is the constraint name will be system generated. Script B is also written to use a system generated name. It is...

Ray K (6/4/2015)

---

I found out last night that my presentation for SQL Saturday has been accepted! I've attended more than a few SQL Saturdays, but this will be my...

ArnoKwetters (6/4/2015)

---

Sorry Sean,

I was not intend to confuse you but I just would let other people know what strange behaviour SSMS (and SQL Server) sometimes has.

As mentioned before in one...