Danny Ocean (6/28/2012)

---

Hi,

Very badly represent the question. given option are not correct. your are showing only 3 values (columns) in option but after execute the query, you will find the...

smitausa (6/27/2012)

---

I have two fields in a SQL Server 2008 view.

ID and SubID. There are up to 24 subIDs for any ID.

In other words, there can be up...

Nice question .. learned something

Thanks ... but read the previous entries and see the opposite feelings. I was beaten from pillow to post ...

Any one interested in convincing this OP that for a development / design / implementation contract as a consultant they would help him/her solve their problem.

http://www.sqlservercentral.com/Forums/Topic1321325-391-1.aspx

Any one know if those spreading Colorado wild fires are threatening Steve's home or the horses? Any one hear from Steve on twitter or whatever?

http://news.yahoo.com/colorado-fire-near-pikes-peak-forces-11-000-014551591.html

bhuvneshk (6/25/2012)

---

Hi Regina,

Please try to search the syntax on BOL or do little Google for that before posting it to this forum.

As many of other useful queries remain ananswered due...

Is this what you are attempting?

CREATE TABLE #T(Col1 INT)

INSERT INTO #T

SELECT 1 UNION ALL

SELECT 1 UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT 1

SELECT SUM(DISTINCT(Col1)) AS 'Sum...

Koen Verbeeck (6/22/2012)

---

Hugo, thanks for the very lengthy and detailed explanation. I already figured out how it worked, but I found the original explanation "there isn't a WHERE clause" a...

The same as the Enterprise edition - practically depends on the server (number of cores, I/O, etc)

sql server developer (6/18/2012)

---

Hi Ron,

First of all thanks for the reply! The link you have sent shows the number of columns in Excel 2007. But even in SSRS 2008 R2...

sql server developer (6/18/2012)

---

Hi Ron,

First of all thanks for the reply! The link you have sent shows the number of columns in Excel 2007. But even in SSRS 2008 R2...

From

http://msdn.microsoft.com/en-us/library/aa730921(v=office.12).aspx#Office2007excelPerf_BigGridIncreasedLimitsExcel

The "Big Grid" and Increased Limits in Excel 2007

The Excel 2007 "Big Grid" increases the maximum number of rows per worksheet from 65,536 to over 1 million, and the number...

To start might I suggest using what is available here on SSC, in the left margin of the home page, or for that matter in the left margin of a...

I have no doubt that the problem is completely understood by yourself, having the table and its contents available to view. But we do not have that knowledge, so...