kate.fletcher 42758 (7/5/2013)

---

Fascinating post!

To me, the sort of conference you describe is actually little more than a re-gurgitated technical manual! The kind that lists all the possible commands/ methods...

Has Google broken down in your country? I'm sorry, but you've been asking questions all morning of which most of them...

I answered in your other thread:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/3b210497-77a7-4241-9327-832a876dc1a4/how-do-i-select-one-date-prior-using-ssis-expression

That seems to be working.

Now just nest another conditional check to check for Sundays, and you're all set.

How to Drop a TempDB Database File[/url]

First Google result for sql server remove tempdb data file.

How about you explain a bit more what you are trying to accomplish?

dfine (7/5/2013)

---

[font="Arial"]Yes, this is one time exercise. I planned to go with SSIS package because as per the company policy I should not use linked server approach. There are 129...

What? Please read the link in my signature on how to post questions on...

akamorse (7/5/2013)

---

OK, it seems i must have confused the whole thing. I managed to just solve it

SELECT MeterID, COUNT(TimeStamp) AS Count, SUM(WattHours) AS WattHours, MONTH(TimeStamp)...

Why don't you give it a shot first and then post back if you run into problems?

Making the whole thing improv would be quite hard for a technical event: how would you prepare your demo's?

I do support the community voting for sessions: that way the sessions...

Easy one to end the week, thanks!

Helical Joan2 (7/4/2013)

---

Hi,

I need generate dynamic files through a query in a foreach loop container.

How can I overridden a global variable in a script component (not a script...

This is a deprecated stored procedure and there's no reason to use...

OK, so just add COUNT(Timestamp) to your query.

For next time, read the link in my signature about how to post questions. It will get you answers more accurately and more...