Jeff Moden (6/24/2015)

---

Ah... hang on a minute while I get the egg off...

Each SELECT statement will cause the data to be read from the table.

sgmunson (6/24/2015)

---

Meatloaf (6/23/2015)

---

Hi,

I have created a phone list and am using a union to be able to display letter category. However, what I would like to do is only...

Meatloaf (6/24/2015)

---

Hi Alvin,

It is close to the first query. What is different is my first query will show all letters regardless if there is a lastname.

For example, my current...

Meatloaf (6/24/2015)

---

Hi, Thank you doing the union with distinct is working. What I would like to display is the letter as a header with names following. If...

...

Sean Lange (6/24/2015)

---

Alvin Ramard (6/24/2015)

---

Deprecated? Why didn't I know that? Oh yes. I'm stuck on older versions...

Jeff Moden (6/23/2015)

---

Alvin Ramard (6/23/2015)

---

Meatloaf (6/23/2015)

---

Hi,

I have created a phone list and am using a union to be able to display letter category. However, what I would like to...

Meatloaf (6/23/2015)

---

Hi,

I have created a phone list and am using a union to be able to display letter category. However, what I would like to do is only show...

Lynn Pettis (6/23/2015)

---

Steve Jones - SSC Editor (6/23/2015)

---

This is exactly what DLM Dashboard was designed to do. Catch changes in schema. It works well for me in small projects here.

Disclosure:...

leetrueman (6/23/2015)

---

The first one

CREATE NONCLUSTERED INDEX idx_Transactions_TransTime

ON dbo.transactions (trans_time, SiteID)

INCLUDE (transactionID,siteID,areacode,gamename,sitename)

GO

is reporting

Msg 1909, Level 16, State 2, Line 1

Cannot use duplicate column names in index. Column name 'SiteID' listed more...

Getting back to the original intention of this thread ... Are the posted questions getting worse? For some posters at least, YES!!!!!

sqlinterset (6/22/2015)

---

I have a table has data of all months. i want to have this table data in the form as first it lists data

from 1 month to current...

sault (6/22/2015)

---

The log backups should not multiply to 100's. That is my problem. They never import or write the data into the main database unless a...

Keep in mind that when using data flows in SSIS, the data has to go from the source server to the SSIS server and then to the destination server. ...

Karthiart (6/21/2015)

---

Hi All,

I have an excel with 3 sheets. 3rd sheet contains pivot template. I want to copy that 3rd sheet and create 3 more sheets in the same...