Valid points, but if your databases are all on the same server, one customer can still affect others.

As far as disk IO is concerned, there are things you can do...

Picture this .... you get 1 million schools ... 1 million databases to manage!

Would be much easier to manage one database.

I know there's many other points to consider, but from...

You can't do: SELECT @count = (Select COUNT(*) FROM [dbo]. + @TableStat);

You need to build a string that has the query you want to execute, then execute that string.

I don't like using the error output when I can remove the erroneous data myself. I would do it differently.

I would add a condition split in the data flow to...

Would the query below be a better starting point for you?

SELECT

DATEPART(Year, [date]) AS [Year]

,DATEPART(Month, [date]) AS [Month]

,SUM(pyd_amount)

FROM paydetail p

WHERE p.itm_code in ('A','B','C','D')

and [date] between '1-1-2014' and '1-31-2014'

ORDER...

You need...

If you don't see any SSAS database on SQL 2005 then it looks like you are not using it and therefore don't need to install it.

You can install it later...

I'm not aware of anything like that existing.

Sounds like you will have to create your own.

aliens218 (12/11/2014)

---

Hi all, I'm looking for a solution where end users can click a web button to download the results of query (sp or view). I know I could...

chulheekim (12/11/2014)

---

I think I heard something like if it is more than 50% fragmented, then it has to be rebuilt. If Reorg will do its job, I will do ...

I don't understand what you mean by "restart".

Actually, this was a badly worded question.

The question was asking how many rows will be affected. It should have been asking what message will be displayed.

(I got the correct...

Phil Parkin (12/11/2014)

---

First, I am assuming that you confused 'BB' and 'CC' in your sample data and query.

It would probably be easier to use T-SQL to get your data into...

How much do you know about using Integration Services?

Koen Verbeeck (12/10/2014)

---

Grant Fritchey (12/10/2014)

---

Weirdest thing, my subscription to The Thread got turned off. I just figured after a couple of weeks you guys had finally given up on this...